BI Engineer

WebMDNavi Mumbai, Maharashtra, India

Full-time

Posted 8 hours agoStill open, checked 1h ago

About the job

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.