Sr. Data Warehouse Developer

| Greater Denver Area

Role
We're looking for a Senior Business Intelligence Engineer who is creative and decisive to join our centralized team of data analytics. 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. As the Sr. Business Intelligence Engineer, you will define the BI architecture roadmap and manage the backlog across multiple data disciplines: DBA, Warehousing, BI and BigData. You will also partner with engineers and business stakeholders across the organization when developing solutions.
We are a vibrant company that is primed for growth and looking for 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
  • Maximize data warehouse availability and performance
  • Identify opportunities for performance improvements, cost reductions and process improvements
  • Develop long-term capacity projections and plan new paths forward for technical systems and platforms
  • 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
• 5+ years work experience in data development/design/consulting
• Bachelors Degree
• Proficiency in 1 or more SQL dialects
Eligibility Requirements
• Interested candidate must submit a resume/CV through www.nbcunicareers.com to be considered
• 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

You have experience with:
• Accomplishing a lot, quickly, and with limited resources (History with startups or other experience)
• 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
• Advanced data warehouse dimensional design
• Building and managing ETL and data integration systems
• Conventional RDBMS systems, bottlenecks, and performance considerations
• Articulating data warehouse design considerations
• Comprehending and internalizing large, rapidly evolving data models. You must not be frightened of a schema with 500+ tables with changes deployed weekly
• Using data and measurement to drive decisions and outcomes; examples might include A/B or multivariate testing, funnel analysis or other quantitative experience optimization

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
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages

Location

999 18th Street, Denver, CO 80202

What are Bluprint Perks + Benefits

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Dental Benefits
Vision Benefits
Health Insurance Benefits
Onsite Gym
Retirement & Stock Options Benefits
401(K) Matching
Child Care & Parental Leave Benefits
Generous Parental Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Company Outings
Some Meals Provided
More Jobs at Bluprint17 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Marketing
Operations
Content
Operations
new
Denver
Content
new
Denver
Developer
new
Denver
Developer
new
Denver
Design + UX
new
Denver
Design + UX
new
Denver
Design + UX
new
Denver
Data + Analytics
new
Denver
Design + UX
new
Denver
Finance
new
Denver
Content
new
Denver
Marketing
new
Denver
Content
new
Denver
Marketing
new
Denver