Data Engineer
2 Months ago • 3 Years + • $110,000 PA - $130,000 PA
Data Analysis
Job Description
Medscape, a division of WebMD, is seeking a passionate and adaptable Data Infrastructure Engineer to support medical education evaluation and grant-seeking efforts. This role involves developing and maintaining data warehouse tables and schemas, building and optimizing end-to-end ETL workflows using Python or Bash scripting on Linux servers, and leading data quality assurance processes including profiling, validation, reconciliation, and testing to ensure data accuracy. The engineer will monitor ETL jobs, troubleshoot failures, implement alerts, and collaborate with analysts and scientists to translate requirements into scalable data solutions. Additionally, responsibilities include building and maintaining dashboards with tools like Tableau or Looker, identifying and resolving performance bottlenecks in SQL queries and data models, and documenting workflows and configurations. The company emphasizes an Equal Opportunity/Affirmative Action employer.
Good To Have:
- Experience with Google Cloud Platform services
- Experience with Tableau or Looker
- Experience in big data environments
- Experience in a sales-driven or matrixed organization
- Master's degree in a related discipline
Must Have:
- 3+ years of experience building ETL pipelines
- Expert-level SQL skills
- Proficiency in Python or Bash scripting
- Data warehouse design and table/schema creation
- Data modeling for OLTP and OLAP
- Experience with data quality assurance
- Strong Linux proficiency
- Excellent analytical and problem-solving skills
- Strong attention to detail
- Clear verbal and written communication
Perks:
- Health Insurance (medical, dental, vision)
- Paid Time Off (vacation, sick leave, holidays)
- 401(k) Retirement Plan with employer matching
- Life and Disability Insurance
- Employee Assistance Program (EAP)
- Commuter and/or Transit Benefits (if applicable)
- Eligibility for discretionary company bonus
Description
Medscape, a division of WebMD, develops and hosts physician portals and related mobile applications that make it easier for physicians and healthcare professionals to access clinical reference sources, stay abreast of the latest clinical information, learn about new treatment options, earn continuing medical education credits and communicate with peers.
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.
Do you have a passion for processing raw data, developing and maintaining datasets, and improving data quality and efficiency? If the answer is yes, then we want you on your team! Medscape Education is seeking a passionate, adaptable, and team-oriented Data Infrastructure Engineer to support independent medical education evaluation and grant-seeking efforts. By joining Medscape Education, the leading provider of medical education for clinicians across the globe, you will have the opportunity to contribute to initiatives that truly make an impact on physicians, nurses, pharmacists, and other healthcare providers, and thus, the lives of those around you.
Responsibilities:
With guidance from the director and in collaboration with the Analytics and Automation team, you will:
- Develop and maintain tables and schemas in the data warehouse according to defined data models
- Build, optimize, and operate end-to-end ETL workflows (ingest, transform, load) on Linux servers using cron scheduling and shell or Python scripting
- Lead the data QA process: define and execute profiling, validation, reconciliation, and testing procedures to ensure data accuracy and integrity
- Monitor ETL jobs, troubleshoot failures, and implement automated alerts and recovery mechanisms
- Collaborate with data analysts, data scientists, and other stakeholders to translate requirements into scalable data solutions
- Partner with other team members to build, deploy, and maintain Tableau and/or Looker dashboards and reports
- Identify and resolve performance bottlenecks in SQL queries, ETL code, and data models
- Document ETL workflows, data quality checks, server configurations, and operational runbooks
Qualifications:
- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Data Infrastructure Engineering, or a related discipline; Master’s degree is a plus
- At least 3 years hands-on experience designing and building ETL pipelines
- Expert-level SQL skills (complex querying, optimization, performance tuning)
- Proficiency in a scripting language for ETL orchestration (Python, Bash, etc.)
- Hands-on experience with data warehouse design and table/schema creation (Vertica preferred)
- Solid understanding of data modeling for both OLTP and OLAP systems
- Experience with data quality assurance processes (profiling, validation, reconciliation, QA testing)
- Strong Linux proficiency (shell scripting, cron job scheduling, log monitoring, process management)
- Excellent numerical and analytical skills, with exceptional attention to detail
- Strong problem-solving ability and ability to work quickly under pressure
- Outstanding time management, organizational skills, and documentation practices
- Clear verbal and written communication, capable of translating technical concepts for non-technical stakeholders
Preferred Qualifications:
- Experience with Google Cloud Platform services (BigQuery, Dataflow, Cloud Storage, IAM)
- Prior experience with business intelligence and visualization tools (Tableau, Looker)
- Experience in big data environments
- Experience working in a sales-driven or highly matrixed organization
Compensation range: $110,000 - $130,000 per year
Bonus Eligible:
This position is also eligible for a discretionary company bonus, based upon business results.
Benefits:
Employees in this position are eligible to participate in the company sponsored benefit programs, including the following within the first 12 months of employment:
- Health Insurance (medical, dental, and vision coverage)
- Paid Time Off (including vacation, sick leave, and flexible holiday days)
- 401(k) Retirement Plan with employer matching
- Life and Disability Insurance
- Employee Assistance Program (EAP)
- Commuter and/or Transit Benefits (if applicable)
Eligibility for specific benefits may vary based on job classification, schedule (e.g., full-time vs. part-time), work location and length of employment.
Set alerts for more jobs like Data Engineer
Set alerts for new jobs by WebMD
Set alerts for new Data Analysis jobs in United States
Set alerts for new jobs in United States
Set alerts for Data Analysis (Remote) jobs
