Data Engineer 2

Our team members are at the heart of everything we do. At Cencora, we are united in our responsibility to create healthier futures, and every person here is essential to us being able to deliver on that purpose. If you want to make a difference at the center of health, come join our innovative company and help us improve the lives of people and animals everywhere. Apply today!

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