Oh Snap!
This job is no longer active - but you can still view the details below.

Sr. Data Warehouse Developer

| Greater Denver Area

We're looking for a Senior Data Warehouse Developer who is creative and decisive to join our data team. The ideal candidate is a stellar PM who thrives on enabling change, enjoys designing and developing data warehouses, and is a whiz at optimizing data layer efficiencies. You will partner with engineers and business stakeholders across the organization when developing solutions. We’re a vibrant, growing company that appreciates adventurous thinkers. Come join us if that’s you.
Responsibilities:
From the start, you can expect to:

  • Extend and refine the current data warehouse to serve complex and evolving needs
  • Manage BI Tool integrations
  • Identify opportunities for performance improvements, cost reductions, and process improvements
  • Understand business goals, timelines, and requirements spanning many different business units and functional groups. Translate the above to clearly articulated, actionable project requirements and tasks
  • Balance timelines, dependencies, effort, and expected value of solutions to establish and argue for priorities of given projects
  • Ensure tight alignment between ongoing development activities and the analytics team

Basic Qualifications
• 3+ years’ work experience in data development/design/consulting
• Bachelor's Degree
• High-level proficiency in 1 or more SQL dialects
 
Eligibility Requirements
• Interested candidate must submit a resume/CV through www.nbcunicareers.com to be considered
• Per NBCU policy, willingness to travel and work overtime, and on weekends with short notice as needed
• Must be willing to work in Denver, CO
• Must have unrestricted work authorization to work in the United States

• Experience with full product ownership (design, implementation, and maintenance); experience at startups or smaller companies is a plus!
• Strong understanding of SQL theory and practice. 100+ line queries, 7-way joins, and correlated subqueries do not scare you. You can write window functions off the top of your head AND know how and when to use them.
• Data warehouse dimensional design knowledge and the ability to articulate design decisions.
• Working knowledge of RDBMS systems, bottlenecks, and performance considerations; experience with non-conventional systems (e.g. AWS Redshift & Athena, Hive, Presto, Vertica, Greenplum) a plus!
• Ability to study & understand large, rapidly evolving data models (200+ tables with frequent changes).
• Experience with how measurement data can drive business decisions (e.g. A/B or multivariate testing, conversion funnel analysis, UX optimization).
• Bonus: some experience with general-purpose programming/scripting in a UNIX/Linux environment (e.g. Python, Bash)

NBCUniversal’s policy is to provide equal employment opportunities to all applicants and employees without regard to race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation, marital status, pregnancy, veteran status, membership in the uniformed services, genetic information, or any other basis protected by applicable law. NBCUniversal will consider for employment qualified applicants with criminal histories in a manner consistent with relevant legal requirements, including the City of Los Angeles Fair Chance Initiative For Hiring Ordinance, where applicable.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • SwiftLanguages
    • LESS/SASSLanguages
    • jQueryLibraries
    • ReactLibraries
    • ReduxLibraries
    • Node.jsFrameworks
    • HandlebarsFrameworks
    • MySQLDatabases
    • PostgreSQLDatabases
    • DynamoDatabases
    • Google AnalyticsAnalytics
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement
    • BrightspotCMS
    • SalesforceCRM
    • SendGridEmail
    • SailthruEmail

Location

We're on the second floor of the Denver Place North Tower building, conveniently located in downtown Denver's Central Business District.

An Insider's view of Bluprint

What’s the vibe like in the office?

Bluprint is a special place to work. The camaraderie in the office is, to me, the backbone of everything we do really well, and it's my favorite part. I always feel supported, and there's never a shortage of help to be found for any project! Everyone is dedicated, passionate, and works incredibly hard to realize our vision.

Brian

Customer Support Supervisor

What does your typical day look like?

Working at Bluprint is like hanging out with my best friends every day! I get to do what I love and create with a stellar group of people. There's literally nothing more you could ask for in a job!

Marteen

Editor

How has your career grown since starting at the company?

I've gained skill sets that are hard to come by in my field. From small, internal shoots with fellow employees, to travel shoots in LA and New York with complete strangers. Bluprint presents ever-changing challenges for me, and it's only made me stronger and more efficient at what I do. That kind of growth is invaluable.

Evan

Producer

What is your vision for the company?

Bluprint is uniquely positioned as the only destination combining premium content, world-class talent, a robust community, and access to all the tools you need to help you achieve your personal goals. Our mission is to revolutionize the way people engage with lifestyle passions and pursuits.

John Levisay

CEO

What does career growth look like on your team?

I started off as an associate in Customer Support and have been promoted on a few occasions to now being one of the managers. It has been great for my career to see our department from all angles so I can better support my team, customers, and the company.

Carly

Customer Support Team Manager

What are Bluprint Perks + Benefits

Culture
Eat lunch together
Team owned deliverables
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Unconscious bias training
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Employee Stock Purchase Plan
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Bluprint provides employees with a flexible work schedule that includes flexible start and end times.
Remote Work Program
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
On occasion
Relocation Assistance
Professional Development Benefits
Tuition Reimbursement
Diversity Program
Lunch and learns
Promote from within
Continuing Education stipend
Online course subscriptions available
More Jobs at Bluprint5 open jobs
All Jobs
Design + UX
Dev + Engineer
Product
Content