Data Engineer

This is us

At Avenga, we believe that human creativity empowers technology that matters. Operating globally, our 6000+ specialists provide a full spectrum of services, including business and tech advisory, enterprise solutions, CX, UX and Ul design, managed services, product development, and software development.

This is the job

We are looking for a  Data Engineer to join our team supporting the development of the Agile Insights Platform - a multi-tenant, cloud-native analytics platform tailored for pharmaceutical commercial programs. The platform enables data integration, KPI configuration, and dashboard delivery across Field Sales, Engagement Centers, Digital Amplifier, and Patient Services modules.

As a Data Engineer, you’ll play a key role in configuring and validating KPI logic, integrating client data sources, and supporting synthetic data workflows, while collaborating closely with cross-functional teams to ensure platform accuracy and scalability.

This is you

• Strong proficiency in SQL and QSQL (for KDB+) with the ability to translate logic between the two
• Experience with data mapping using GUI-based tools for source-target alignment
• Proficiency in cross-dataset joins and relational data validation
• Scripting experience in Python or SQL for automation and test data generation
• Comfortable working with YAML-based KPI logic templates
• Hands-on experience querying and validating data in Snowflake
• Knowledge of Azure Data Factory for orchestrating data pipelines
• Understanding of Azure DevOps Pipelines and CI/CD deployment automation
• Experience supporting QA and testing teams to validate KPI and dashboard logic
• Familiarity with Auth0, Oracle APEX, and role-based access provisioning

This is your role

• Map and integrate client data using GUI tools, Azure Data Factory, and Snowflake.
• Configure KPI logic using SQL, QSQL, and YAML, supporting both standard and client-specific metrics.
• Generate and validate synthetic data for QA using Python or SQL.
• Set up dashboards and ensure correct KPI rendering across services.
• Manage access provisioning and deployments via Auth0, Oracle APEX, and Azure DevOps Pipelines.
• Support cross-functional teams by resolving data and logic issues and preparing client-ready data exports.