As a Senior Data Engineer on our Provider Data as a Service team, you will develop and maintain database functionality to support corporate products and services.  Primarily, your focus will be on mastering healthcare provider data for display on the Healthgrades.com website. You will collaborate with cross-functional database and product development teams using Agile / Scrum, SQL Server, .Net and Open Source technology.

In your 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 technologies so experience or interest in learning Elasticsearch, Aurora, MySQL, Spark, Streamsets, Kafka, Python, or Scala is a plus. If you are interested in growing your expertise in these technologies, this will be an exciting opportunity for you.

Primary Responsibilities:

• Create T-SQL statements that perform efficiently against large data sets
• Performance tune of large Data Warehousing platforms, with focus on schema bound views, database partitioning, and etl/query optimization
• Create 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 relates to RDBMS, Data Warehousing, and Business Intelligence
• Build and maintain complex T-SQL statistical algorithms
• Design of specialized data structures for the purpose of data consumption by a public facing website and/or Business Intelligence data visualization
• Load, process and migrate incoming data feeds and create outgoing data extracts
• Create and maintain documentation to support developed applications

Qualifications:

• Strong RDBMS and Microsoft SQL Server 2014/2016 skills
• SQL Programming / ETL and data architecture management experience
• Data modeling and corporate-level data 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 deliverables.
• Good collaboration and idea sharing in team environment.
• A Bachelor’s Degree in related field or equivalent experience.

Preferred Qualifications:

• 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 energetic work environment while setting the stage for continued success.

• Meaningful Work – helping millions of Americans connect with their healthcare providers
• Changing the Game – evolving, fast paced culture with career advancement opportunities
• Community Builders – partnering with local charity and wellness initiatives
• Robust Perks – generous PTO, 401k contributions, tuition assistance, entertainment discounts and more!