Data Operations and ETL Analyst

IQVIA; Województwo mazowieckie; In loco; PLN 110.000 - 203.000; Tempo pieno

Descrizione del lavoro

IQVIA is seeking an LPD Production Analyst to support end-to-end processing of healthcare and market data in the LPD production environment. You will ensure timely and accurate execution of manual and automated ETL workflows from parsing to OD/BO loading, validating source files, and coordinating country-specific deployments.

The role requires hands-on ETL experience with Informatica PowerCenter, production support, data validation, and process optimization, with collaboration across global

Competenze

• Bachelor's degree in IT, CS, data analytics, engineering or related field.
• 2–5 years in Data Operations, Production Support, ETL operations, or Application Support.
• Experience with production environments and critical data processing workflows.
• Experience with healthcare, pharmaceutical, or commercial data environments preferred.

Mansioni

• Execute and monitor manual and automated LPD data processing workflows.
• Manage data processing from Parser through OD and BO loading.
• Validate and prepare incoming source files for processing.
• Trigger workflow executions to support production timelines.
• Monitor workflow status and investigate failures or exceptions.
• Utilize Informatica PowerCenter Workflow Manager and Monitor to run ETL jobs.
• Review mappings, dependencies, directories, and configurations.
• Upload and manage source files on Informatica servers.
• Coordinate deployment of country-specific workflows.
• Investigate data loading issues across OD and BO environments.
• Analyze ETL failures, logs, and data discrepancies.
• Support month-end and period-close activities.

Conoscenze

Informatica PowerCenter

ETL concepts

SQL troubleshooting

Windows servers

Linux servers

Batch scripting

Data quality checks

Formazione

Bachelor's degree in IT, CS, Data Analytics, Engineering or related field

Strumenti

Snowflake

GitLab

JIRA

WinSCP

Descrizione del lavoro

The LPD Production Analyst is responsible for supporting the end-to-end processing of healthcare and market data through the LPD production environment. The role ensures timely and accurate execution of manual and automated data workflows from parsing and ingestion through Operational Data (OD) and Business Objects (BO) loading processes.

This position requires hands‑on experience with ETL workflows, Informatica PowerCenter, production support activities, data validation, troubleshooting, and process optimization. The analyst will work closely with global operations, technical support teams, and business stakeholders to ensure data integrity, process stability, SLA adherence and information and global data privacy for France Data. Long term, the role will expand to supporting other functions within the team such as ARA & Data IQ.

Roles And Responsibilities

Data Processing & Workflow Management

• Execute and monitor manual and automated LPD data processing workflows.
• Manage data processing activities from Parser through OD and BO loading environments.
• Validate and prepare incoming source files for processing.
• Manually trigger workflow executions when required to support production timelines.
• Monitor workflow status and investigate processing failures or exceptions.

Informatica Administration & ETL Support

• Utilize Informatica PowerCenter Workflow Manager and Workflow Monitor to execute and manage ETL jobs.
• Review mappings, file dependencies, directories, and workflow configurations.
• Upload and manage source files on Informatica servers.
• Perform session locking and unlocking activities to prevent workflow conflicts during manual processing.
• Coordinate deployment and execution of country-specific workflows.

Production Support & Troubleshooting

• Investigate and resolve data loading issues across OD and BO environments.
• Analyze ETL failures, log files, workflow errors, and data discrepancies.
• Support month‑end and period‑close activities.
• Troubleshoot database and workflow‑related issues impacting data availability.
• Perform root cause analysis and recommend corrective actions.

Data Quality & Validation

• Verify file naming conventions, control files, and loading requirements.
• Conduct data validation checks before and after workflow execution.
• Ensure data completeness, accuracy, and consistency throughout the ETL lifecycle.
• Support data reconciliation and issue resolution.

Process Control & Operational Excellence

• Follow established production control procedures and operational standards.
• Maintain documentation, runbooks, and knowledge articles.
• Identify opportunities for automation and process improvements.
• Support business continuity and disaster recovery activities.

Stakeholder Collaboration

• Work closely with Operations, Technical Support, Database Administrators, and Global Production Teams.
• Communicate processing status, incidents, risks, and resolutions to stakeholders.
• Participate in operational reviews and continuous improvement initiatives.

Requirements

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, Engineering, or a related field.
• 2 to 5 years of experience in Data Operations, Production Support, ETL operations, or Application Support.
• Experience supporting production environments and managing critical data processing workflows.
• Experience working with healthcare, pharmaceutical, or commercial data environments is preferred.

Technical Skills

• Informatica PowerCenter (Workflow Manager and Workflow Monitor)
• ETL concepts and data integration processes
• SQL and database troubleshooting, Proficient in SQL-
• Windows and Linux server environments
• File transfer tools (WinSCP or equivalent)
• Batch scripting and job scheduling
• Data quality validation and reconciliation

Preferred Skills

• Production Support / Application Support experience
• Incident and problem management
• Root Cause Analysis (RCA)
• Process improvement and operational excellence methodologies
• Knowledge of healthcare data processing environments
• Snowflake, Gitlab, ID Gatekeeper and JIRA, - nice to have

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 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 zł109,600.00 - zł203,400.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.