WebMD logo

BI Engineer

WebMD

2 years

Mumbai

Posted:7 hours ago

Job Description

About the Company
Headquartered in El Segundo, Calif., Internet Brands® is a fully integrated online media and software services organization focused on four high-value vertical categories: Health, Automotive, Legal, and Home/Travel. The company's award-winning consumer websites lead their categories and serve more than 250 million monthly visitors, while a full range of web presence offerings has established deep, long-term relationships with SMB and enterprise clients. Internet Brands' powerful, proprietary operating platform provides the flexibility and scalability to fuel the company's continued growth. Internet Brands is a portfolio company of KKR and Temasek.

WebMD Health Corp., an Internet Brands Company, is the leading provider of health information services, serving patients, physicians, health care professionals, employers, and health plans through our public and private online portals, mobile platforms, and health-focused publications. The WebMD Health Network includes WebMD Health, Medscape, Jobson Healthcare Information, prIME Oncology, MediQuality, Frontline, QxMD, Vitals Consumer Services, MedicineNet, eMedicineHealth, RxList, OnHealth, Medscape Education, and other owned WebMD sites. WebMD®, Medscape®, CME Circle®, Medpulse®, eMedicine®, MedicineNet®, theheart.org®, and RxList® are among the trademarks of WebMD Health Corp. or its subsidiaries.

Medscape Education, 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.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status

For Company details, visit our website: www.webmd.com / www.internetbrands.com

Overview
Do you have a passion for building scalable data pipelines, designing robust data models, and turning raw data into reliable, analytics-ready datasets? If the answer is yes, then we want you on our team! Medscape Education is seeking a passionate, adaptable, and detail-oriented Data 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:

Working for the Analytics team, you will:

  • Design and implement data warehouse models (star schemas) to support reporting and analytics needs.
  • Build and maintain aggregation and summary tables to optimize query performance for downstream reporting and dashboards.
  • Design, develop, and maintain ETL/ELT pipelines to extract, transform, and load data from source systems into the data warehouse.
  • Communicate with stakeholders on requirements, strategies, and progress throughout the development lifecycle.
  • Integrate and manage data across Vertica and Google BigQuery (GBQ), including cross-platform data movement and synchronization.
  • Write efficient, well-structured SQL for data transformation, validation, and performance tuning across large datasets.
  • Develop and maintain Python-based data processing scripts and automation for scheduled data loads and transformations.
  • Implement data quality checks, validation rules, and monitoring to ensure accuracy, completeness, and consistency of data.
  • Incorporate logging, error handling, retry logic, and alerting to ensure end-to-end pipeline reliability.
  • Manage version control (Git) for ETL code, schema definitions, and data pipeline configurations.
  • Monitor pipeline and warehouse performance; troubleshoot production issues and deliver timely fixes.
  • Document data models, ETL architecture, and operational runbooks; share best practices with the team.
  • Continuously evaluate new tools, technologies, and approaches to improve data infrastructure and pipeline efficiency.
  • Leverage Claude and other AI coding assistants to accelerate development, applying strong prompting and review skills to ensure generated code is correct, secure, and maintainable, and pairing it with clear, thorough documentation to maximize development efficiency.

Qualifications

  • Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
  • 2+ years of experience in data engineering, data warehousing, or ETL development.
  • Proven experience designing and implementing dimensional data warehouse models (star schemas).
  • Hands-on experience building and optimizing aggregation/summary tables for reporting and analytics.
  • Strong experience designing, building, and maintaining ETL/ELT pipelines.
  • Hands-on experience with Vertica and Google BigQuery (GBQ), including query optimization and data movement between platforms.
  • Advanced SQL skills for complex querying, transformation, and performance tuning.
  • Strong Python proficiency for data processing and pipeline automation (pandas, SQLAlchemy, or similar).
  • Experience with data quality frameworks, validation, and monitoring practices.
  • Familiarity with REST APIs, JSON/XML parsing, and file-based data ingestion (CSV/Excel).
  • Version control (Git) and collaborative development workflows.
  • Knowledge of security best practices for handling sensitive data.
  • 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.
  • Proficient with Claude and similar AI coding assistants, including effective prompt design, code review/validation, and producing well-organized technical documentation to maximize development efficiency.

Preferred Qualifications

  • Familiarity with cloud platforms (GCP, AWS, or Azure) for compute, storage, and data warehousing.
  • Experience with workflow orchestration tools (Airflow, dbt, or similar).
  • Exposure to BI tools (Tableau, Power BI, Looker) and how they consume warehouse/aggregated data.
  • Understanding of AI/ML data pipeline needs and how data engineering supports downstream ML/analytics workflows.
  • Experience in big data environments.
  • Experience working in a sales-driven or highly matrixed organization.


We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

Skills Required

Online Media Software Services Automotive Healthcare Mobile Applications Analytics Data Warehouse Reporting and Analytics ETL SQL Data Transformation Performance Tuning

Learn the skills this job asks for

See your skill gap for Data Analyst →

Free courses, interview questions and practice for each skill.

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
WebMD logo
WebMD

RecommendedJobs for You

WebMD logo

Mumbai

WebMD logo

Mumbai

WebMD logo

Navi mumbai

Haleon logo

Bengaluru

WebMD logo

Mumbai

WebMD logo

Mumbai

WebMD logo

Navi mumbai

Haleon logo

Bengaluru