The Data Engineer (Data Operations) is responsible for building, maintaining, and optimizing downstream data pipelines and analytics-ready datasets that power business intelligence and reporting. This role focuses on data troubleshooting, transformation, and delivery, ensuring that upstream data is validated and converted into reliable, curated data sources for BI and analytics teams. The individual will work hands-on with Snowflake, SQL, and Python to develop data models, resolve data issues, and support production data operations, enabling the BI team to efficiently consume high-quality data through their visualization tools. Experience with R is a plus, as we transition from R into new technologies.
Essential Functions
Build and maintain curated data layers and data sources
Develop and optimize SQL- and Python-based transformations in Snowflake
Troubleshoot data quality issues originating from upstream pipelines, including identifying root causes and coordinating fixes where needed
Validate incoming datasets and ensure accuracy, completeness, and consistency before they are surfaced to downstream users
Design and manage analytics-ready data models and tables to support reporting and dashboards
Serve as a key point of contact for reporting data layers ensuring data sources meet usability and performance needs
Monitor data pipelines and datasets for failures, anomalies, and performance issues, and proactively resolve them
Support production operations, including incident management, backlog prioritization, and SLA adherence
Partner with upstream engineering teams to escalate and resolve ingestion-related issues, while not owning ingestion directly
Improve processes for data validation, monitoring, and operational efficiency
Qualifications
Bachelor’s degree
7+ years of experience in data engineering, data operations, or backend data development
Strong hands-on experience with:
Snowflake (data warehouse design, optimization, and management)
SQL (advanced querying, performance tuning, and data transformation)
Python (data processing, scripting, and automation)
Proven experience building and supporting production-grade data pipelines and workflows
Strong experience with ETL/ELT tools, orchestration frameworks (e.g., Airflow, Atomic), or similar pipeline management tools
Experience troubleshooting data issues, pipeline failures, and data inconsistencies, with strong root cause analysis skills
Solid understanding of data modeling, data warehousing concepts, and data lifecycle management
Familiarity with CI/CD, version control (Git), and production deployment practices
Strong problem-solving skills and ability to work independently in fast-paced environments
Excellent communication skills with the ability to explain data issues and solutions to both technical and non-technical stakeholders
Experience working with healthcare, pharmaceutical, or life sciences data strongly preferred
IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at https://jobs.iqvia.com
IQVIA is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by applicable law. https://jobs.iqvia.com/eoe
IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.
The potential base pay range for this role, when annualized, is $69,300.00 - $173,200.00. The actual base pay offered may vary based on a number of factors including job-related qualifications such as knowledge, skills, education, and experience; location; and/or schedule (full or part-time). Dependent on the position offered, incentive plans, bonuses, and/or other forms of compensation may be offered, in addition to a range of health and welfare and/or other benefits.Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
