Data Engineer

Description

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 understood fashion
• Demonstrates expert proficiency by sharing learnings with team and in technical showcases
• Independently discovers solutions and collaborates on insights and best practices
• Takes ownership of team’s work deliverables and actively participates in mentoring of team members
• 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
• Consistently works across the organization to enable teams to support each other
• Ensures that credit is shared and given when due
• Works to build and improve strong relationships across the organization
• Leverages those relationships to better plan for and position the engineering organization
• Leads strategic organizational decisions and plans
• Consistently works at a strategic level, influencing decisions to achieve organizational alignment on major goals
• Facilitates organization-wide discussions, ensuring that everyone has an opportunity to share their opinion and be heard, and that discussion outcomes tie to stated goals
• Encourages quiet participants and ensures no one person dominates the conversation

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

• Advanced experience with data engineering in a cloud development - Microsoft Azure is preferred
• Advanced experience with self-service query tools and dashboards - preferably Power BI
• Advanced understanding of 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