Lead Data Engineer

| Greater Denver Area

As a Lead Data Engineer on Healthgrades' Facility Data as a Service team, you will develop and maintain database functionality to support corporate products and services, focused on mastering healthcare claims data for consumption across Healthgrades' products. You will collaborate with multi-functional database and product development teams using Agile / Scrum, SQL Server, .Net and Open Source technology.

In this role, you will implement database technologies and development processes to support database development for a Data Platform that is changing the game. On this product, we are currently transitioning our Microsoft technology stacks to other Open Source technology stacks, so experience or interest in learning those tools is a plus. If you are passionate about growing your expertise in these technologies, this will be a great opportunity for you.

 

What You Will Do:

  • Oversee day-to-day operational matters, provide training, and supervise performance related to company and individual OKRs
  • Lead and manage complex development projects including plans, designs, technical leadership, schedules, and resource allocation while also being a hands-on engineer
  • Build and maintain complex T-SQL statements that perform efficiently against large data sets
  • Performance tune large Data Warehousing platforms, with a focus on schema bound views, database partitioning, and etl/query optimization
  • Build and maintain Windows Workflow Engine Packages and Models using Windows Workflow Foundation
  • Create and maintain automated ETL processes with special focus on data flow, error recovery, and exception handling and reporting
  • Create and modify data models and implementations as they relate to RDBMS, DW, and BI
  • Design of specialized data structures for the purpose of data consumption by a public facing website and/or Business Analytics data visualization
  • Load, process and migrate incoming data feeds and create outgoing data extracts
  • Create and maintain documentation to support developed applications

 

What You Will Bring:

  • Ability to participate in a culture of communication, collaboration and creativity
  • Previous experience in a lead or management role with direct reports
  • Strong RDBMS and Microsoft SQL Server 2014/2016 skills
  • SQL Programming / ETL and data architecture management experience
  • Experience building and maintaining database structures, ETL processes, stored procedures, audit reports, data extracts, SSIS, SSAS, SSRS, etc. to meet project objectives
  • Perform Unit Tests and internal QA checks to insure high quality work
  • Good collaboration and idea sharing in team environment
  • A Bachelor’s Degree in related field or equivalent experience

 

Preferred Qualifications:

  • Data modeling and corporate-level data management experience
  • Previously worked with Windows Workflow Foundation, Windows Workflow Designer and Windows Presentation Foundation technologies
  • Experience with Elasticsearch, Aurora, MySQL, Spark, Streamsets, Kafka, Python, and Scala is a plus

 

Why Healthgrades?

At Healthgrades, we recognize that our people drive our greatest achievements. We are passionate about maintaining a fulfilling, rewarding and high-energy work environment while setting the stage for your continued success.

  • Meaningful Work – empowering consumers with data to make the right decisions for themselves and their families
  • Changing the Game - evolving, dynamic culture with career advancement opportunities
  • Community Builders- participating in local charity organizations and wellness initiatives
  • Robust Perks – generous PTO, 401k contributions, tuition assistance, entertainment discounts & more!
Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • jQueryLibraries
    • ReactLibraries
    • ReduxLibraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • SparkFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • Google AnalyticsAnalytics
    • OptimizelyAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • JIRAManagement
    • SalesforceCRM

Location

Downtown Location- your favorite coffee shop, restaurants, breweries, and nightlife are all steps from the office, as well as, transportation lines.

An Insider's view of Healthgrades

What’s the vibe like in the office?

The vibe is pretty chill; everybody dresses very casual, the newly designed office offers a lot of space for collaboration, great kitchens with free snacks and beer/cider/kombucha on tap. We also have 4-6 weeks of time off and flexible work schedules.

Regina

Program Management Director

What's the biggest problem your team is solving?

Evolving consumer expectations are pushing doctors and practice owners to adopt convenient, on-demand delivery of services. Getting doctors to appreciate these changes and mature their business can be a struggle. We’re taking a data-driven, analytical approach to prove that meeting patients' expectations can be a big win for growing their practice.

Steven

VP, Product Management

What makes someone successful on your team?

Good communication. Whether you are falling behind or cruising forward, being able to convey where you are and where you may need additional support really helps with productivity and learning.

Dan

Software Engineer

How do you collaborate with other teams in the company?

Even while working cross-functionally with several different teams, the multiple forms of technology in place make collaboration efficient – Zoom, Slack, Google Drive, etc. Our physical space is set-up nicely for face-to-face coordination with open office space, a big kitchen, and many meeting rooms. We also have plenty of quiet spaces.

Jamie

Senior Product Marketing Manager

What are Healthgrades Perks + Benefits

Healthgrades Benefits Overview

Our inclusive package offers flexible options customizable for everyone – no matter what your family looks like.

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
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Company Outings
Game Room
Stocked Kitchen
Happy Hours
Relocation Assistance
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
More Jobs at Healthgrades19 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Marketing
Operations
Product
Project Mgmt
Sales
Project Mgmt
new
Denver
Marketing
new
Denver
Design + UX
new
Denver
Sales
new
Denver
Project Mgmt
new
Denver
Developer
new
Denver
Data + Analytics
new
Denver
Operations
new
Denver
Product
new
Denver
Data + Analytics
new
Denver
Data + Analytics
new
Denver
Marketing
new
Denver
Data + Analytics
new
Denver
Product
new
Denver
Product
new
Denver