Lead, Data Engineering

WebMD
United States, New York, New York
Nov 12, 2024
Description Position at WebMD WebMD is the most recognized and trusted brand of health information and the leading provider of health information services, serving consumers, physicians, healthcare professionals, employers and health plans through our public and private online portals and WebMD the Magazine. The WebMD Health Network includes WebMD, Medscape, MedicineNet, eMedicine, RxList, theheart.org and Medscape Education. Our consumer portals and mobile health applications provide engaging, relevant and credible health and wellness information, personalized health assessment tools and access to online communities. 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. Imagine if your work helped people better understand the conditions affecting their best health or the health of someone under their care. A job in the Technology organization at Healthwise focuses on delivery of health education to any scenario that helps someone get informed about and involved in their health care. Since 1975, the Healthwise mission has been to help people make better health decisions. This mission-combined with our innovative spirit-has led to health education and technological solutions used to deliver education as part of care millions of times each month. JOB SUMMARY 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, 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 7+ 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 Maintains previously deployed software and reports - Power BI, SSIS 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 To perform this job successfully, an individual must be able to perform the essential functions satisfactorily with or without reasonable accomm odation.