Data Engineer (Consultants)

IQVIA; Bengaluru; Hybrid; INR 800,000 - 1,200,000; Full time

Job summary

A leading healthcare analytics company is seeking a Data Engineer with 2.5 to 5 years of experience to design and optimize data engineering solutions. In this hybrid role, you will manage ETL processes, conduct requirement analysis, and collaborate with stakeholders on data warehousing projects. The ideal candidate has a Bachelor's degree in a related field and strong skills in SQL and Python. This full-time position offers a dynamic environment in the healthcare sector.

Qualifications

• 2.5 to 5 years experience in data engineering.
• Proven ability in building data warehousing solutions and ETL processes.
• Strong skills in SQL and Python for data manipulation.

Responsibilities

• Design and implement robust ETL/ELT pipelines.
• Conduct in-depth analysis of source systems.
• Collaborate with stakeholders for successful data warehouse development.

Skills

Data Engineer

Databricks

Python/Pyspark

SQL

AWS

Azure

Education

Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related quantitative field

Master's Degree in a related field preferred

Tools

SQL Server

Oracle

PostgreSQL

Snowflake

Redshift

Azure Synapse

Spark

Hadoop

Hive

Project management tools (Jira, Asana, Smartsheet)

Job description

Job Title / Primary Skill: Data Engineer

Years of Experience: 2.5 to 5 years

Job Location: Pune (Hybrid)

Must Have Skills: Data Engineer, Databricks, Python/Pyspark, SQL, AWS/Azure

Job Overview

As a Data Engineering Consultant, you will be instrumental in designing, developing, and optimizing robust data engineering solutions that support critical business analytics and reporting. You will provide high-quality, timely development and on-time input for service delivery, managed services, or implementation-oriented client projects. Assignments will range from foundational analysis and problem-solving to contributing to the architecture of complex data solutions and potentially leading small technical teams. Your contributions will directly impact client satisfaction objectives. You will also be responsible for developing technical modules and low-level designs while monitoring the technical quality standards of onshore/offshore development teams.

Essential Functions

• Designing and Building Data Warehouse Solutions: Design and implement robust ETL/ELT pipelines to process structured and unstructured data. Support the end-to-end design and build of new data warehousing solutions, including understanding intricate business data needs, translating them into technical specifications, and planning for efficient data integration and delivery.
• Requirements Gathering and Data Modelling: Conduct in-depth analysis of source systems and business requirements to generate detailed data warehousing specifications, including conceptual, logical, and physical data models. Create comprehensive technical documentation, including design specifications, data flow diagrams, and mapping documents.
• Stakeholder Collaboration: Manage internal and external cross-functional stakeholders, including business users, data architects, ETL developers, and BI specialists, to ensure successful data warehouse development and adoption.
• Strategic Data Architecture: Develop scalable data architectures using technologies like Spark, Hadoop, and cloud-native tools (AWS, Azure). Leverage deep technical expertise and business acumen to identify strategic alternatives and work with project lead to recommend optimal data warehousing architectures that align with client business goals.
• Knowledge Development: Continuously develop a broad knowledge of data warehousing methodologies, industry best practices, and emerging technologies (e.g., cloud data platforms, data lakes) through project delivery and formal/informal learning opportunities.
• Independent and Team Work: Work effectively both independently and as a vital part of a technical team, contributing to all phases of the data warehousing lifecycle.
• Client Engagement: Attend, support, and present technical solutions and progress updates at client meetings.
• Mentorship and Knowledge Sharing: Contribute to the learning, development, and mentoring of junior team members.

Qualifications

Educational Background

• Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related quantitative field.
• Master's Degree in a related field preferred.

Technical Expertise

• Proven experience in designing, developing, and implementing enterprise data warehouses using various database technologies (e.g., SQL Server, Oracle, PostgreSQL, Snowflake, Redshift, Azure Synapse).
• Strong proficiency in SQL and Python
• Experience with big data tools (e.g., Spark, Hadoop, Hive).

Preferred Qualifications

• Prior work experience in pharmaceutical domain
• Hands‑on experience in project management tools (Jira, Asana, Smartsheet, etc.)
• Team management — experience leading small project teams (2‑3 members)
• Knowledge of Generative AI concepts and tools
• Strong hands‑on experience in either of the cloud platforms — AWS, Azure.
• Understanding of data governance, data quality, and master data management principles.
• Experience working in Agile / Scrum environments.

Professional Attributes

• Works willingly and effectively with others in and across the organization to accomplish team goals.
• Knowledge and understanding of the fundamental processes of business, their interaction, and the impact of external/internal influences on decision‑making, growth, and decline, specifically as they relate to data strategy.
• Knowledge of consulting methods, tools, and techniques related to data warehousing and business intelligence.
• Knowledge of current events and developments within the data management industry and major competitors.
• Effective time management and project organization skills, with the ability to manage multiple priorities.

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Information Technology

Industries

Hospitals and Health Care

Referrals increase your chances of interviewing at IQVIA by 2x