Data Engineer

Description

Position at WebMD

WebMD is an Equal Opportunity/Affirmative Action employer and does not discriminate on the basis of race, ancestry, color, religion, sex, gender, age, marital status, sexual orientation, gender identity, national origin, medical condition, disability, veterans status, or any other basis protected by law.

The ideal candidate has experience and passion for data engineering. They are an expert in their field – whether that be the front end (data visualization, DAX, Power BI, SQL) or the back end (SSIS, Azure Data Factory, Synapse, data modeling, SQL) of the data engineering world.

Exhibits expert knowledge of architecture and system design principles. This person has a consistent record of very strong ownership for their area, and is considered the guru in their technical space. This person is able to solve complex cross-functional challenges and perform complex analysis of business needs and provide innovative solutions. Works across the organization to foster a culture of architecture that allows for iterative, autonomous development and future scaling. Guides teams in the organization in anticipation of future use cases and helps them make design decisions that minimize the cost of future changes.

DUTIES & RESPONSIBILITIES

• Builds software to extract, transform, and load data – SSIS, Azure Data Factory, Synapse

• Models data for efficient consumption by reporting and analytics tools – Azure Analysis Services, Power BI, SQL Databases

• Maintains previously deployed software and reports – Power BI, SSIS, AAS, SQL Server

• Designs dashboards and reports to meet business needs

• Presents technical problems with solutions in mind, in a constructive and understandable fashion

• Demonstrates proficiency by sharing learnings with the team and in technical showcases

• Independently discovers solutions and collaborates on insights and best practices

• Takes ownership of their work deliverables

• Actively seeks out opportunities to help improve the team’s practices and processes to achieve fast flow

• Works with other developers to facilitate knowledge transfer and conduct code reviews

• Ensures that credit is shared and given when due

• Works to build and improve strong relationships among team members

REQUIREMENTS

• 3+ years of Data Engineering experience

• Bachelor’s Degree in Information Systems, Computer Science, Business Operations, or equivalent work experience

• Advanced experience with Standard Query Language (SQL) and data modeling/architecture

• Advanced experience with Data Analysis Expressions (DAX)

• Advanced experience and understanding of data integration engines such as SQL Server Integration Services (SSIS) or Azure Data Factory, or Synapse

• All offers are contingent upon the successful completion of a background check

PREFERRED SKILLS AND KNOWLEDGE

• Proficiency with data engineering in a cloud development environment - Microsoft Azure is preferred

• Proficiency with self-service query tools and dashboards - preferably Power BI

• Proficiency with star schema design and managing large data volumes

• Familiarity with data science and machine learning capabilities

• Ability to interact with people, inside and outside the team, in order to see a project to completion

• Experience protecting individual privacy, such as required by HIPAA