Data Engineer 2

Cherchez-vous à faire une différence dans la vie d’un patient? Chez AmerisourceBergen, vous trouverez une culture innovante et collaborative, axée sur le patient et soucieuse de faire la différence. En tant qu’organisation nous sommes unis par notre responsabilité d’œuvrer pour des vies plus saines. Joignez-vous à nous et postulez dès aujourd’hui# Ce que vous ferez# ## Purpose Summary To design, build, support and maintain scalable, reliable data solutions that enable the business to make timely, data-driven decisions. This role owns the data pipelines, integrations and analytics tooling — including Snowflake and Power BI — that underpin reporting and analytics across the organisation, working closely with the Development, Cloud and Security engineering teams to ensure data solutions are delivered securely, reliably and efficiently. The role is forward-looking, embracing AI-assisted tooling to accelerate delivery and improve data quality, while maintaining strong working knowledge of existing data tooling to support and maintain legacy data integrations and solutions. ## Primary Duties and Responsibilities
* I design, build, support and maintain scalable, secure data pipelines and integrations across the organisation's data estate.
* I develop and maintain data models, ETL/ELT pipelines and analytics solutions using Azure Synapse Analytics, Snowflake, Power BI and related data tooling.
* I take accountability for the quality, performance and ongoing support of the data solutions I deliver, including legacy data integrations.
* I champion effective and responsible use of AI-assisted tooling (e.g. GitHub Copilot, Claude) to improve the speed, quality and efficiency of data engineering delivery.
* I work closely with the Development, Cloud and Security engineering teams to ensure data solutions are architected, delivered and operated securely and reliably.
* I troubleshoot and resolve complex data issues, including data quality, performance and integration failures, across both modern and legacy platforms.
* I maintain and support existing legacy data integrations and solutions, ensuring continuity of service while planning their modernisation where appropriate.
* I build and maintain dashboards, reports and self-service analytics capability in Power BI for business stakeholders.
* I liaise with business stakeholders to understand data and reporting requirements and translate them into effective technical solutions.
* I adopt a security-first approach to the data solutions I design and build, ensuring data is handled in line with governance, privacy and compliance requirements.
* I contribute to the definition and evolution of data architecture, standards and best practice across the organisation.
* I can accurately estimate the time and effort required for data engineering tasks and projects.
* I partner with the Cloud and Development teams to ensure data platforms scale effectively within our cloud infrastructure.
* The employee agrees to take on additional reasonable tasks that align with their abilities, if required. ## Experience and Educational Requirements
* Bachelor's degree in Computer Science, Data Engineering, Information Systems or a related field, or equivalent professional experience.
* 5+ years of experience in data engineering, data warehousing or business intelligence roles.
* Strong hands-on experience with Snowflake or an equivalent cloud data warehouse platform.
* Strong hands-on experience with Power BI, including data modelling, DAX and report/dashboard development.
* Experience building and maintaining ETL/ELT pipelines and data integrations, including legacy systems.
* Practical experience using AI-assisted tooling (e.g. GitHub Copilot, Claude) to improve data engineering delivery.
* Strong SQL skills and experience with data modelling, including dimensional modelling and star schemas.
* Experience working with cloud platforms (Azure, AWS or GCP) and cloud-native data services.
* Understanding of data governance, data quality and data security principles.
* Experience working closely with Development, Cloud and Security engineering teams in a cross-functional environment.
* Experience with Azure Synapse Analytics is desirable.
* GxP, GCP and/or TMF (Trial Master File) knowledge preferred but not mandatory.
* Excellent problem-solving skills and the ability to diagnose and resolve complex data issues.
* Rapidly absorbs and critically assesses new information and applies it effectively, keeping pace with evolving data and AI tooling.
* Strong communication skills, with the ability to translate technical data concepts for non-technical stakeholders.
* Makes decisions which impact the success of assigned work, i.e. results, deadlines and quality, and supports collaborative ways of working across the team.
* Investigates, defines and resolves complex data issues across a broad range of technical contexts.
* Learning and professional development — keeps own data and AI tooling knowledge current and shares learning