Data Engineering Specialist (Architect)

About Our Company:

At AstraZeneca, we pride ourselves on crafting a collaborative culture that champions knowledge-sharing, daring thinking, and innovation – ultimately providing employees with the opportunity to work across teams, functions and even the globe.

Recognizing the importance of individualized flexibility, our ways of working allow employees to balance personal and work commitments while ensuring we continue to build a strong culture of collaboration and partnership by engaging face-to-face in our offices 3 days a week. Our head office and BlueSky Hub in downtown Toronto are purposely crafted with collaboration in mind, providing space where teams can come together to strategize, brainstorm, and connect on key projects.

Our dedication to sustainability is also central to our culture and part of what makes AstraZeneca is an excellent place to work. We know the health of people, the planet and our business are interconnected which is why we’re taking bold actions to address some of the biggest challenges of our time, from climate change to access to healthcare and disease prevention.

Summary of Position:

Are you passionate about data and excited by the challenge of transforming data sources into exceptional Business Intelligence? We're seeking a problem solver to enhance our Information Management capabilities. If you're ready to tackle the complexities of data management and optimization, this role is perfect for you. You will be responsible for data discovery, integrating new data, managing changes to existing sources, and architecting solutions to optimize data delivery for our Insights & Analytics and Data Science teams.

As a Data Engineering Specialist, you will oversee the enterprise data architecture for AstraZeneca Canada. You will define and govern data standards, streamline data architecture, and contribute to data solution design and integration across local and global projects. Serving as the data architecture Subject Matter Expert for the Canadian Enterprise Analytics platform, you will drive new data modeling into the Data Warehouse and collaborate on creating a semantic layer to support reporting and analytics. With your comprehensive knowledge of data, data models, and BI architecture, you will resolve data issues and assist business users with data inquiries.

What You’ll Do:

• Serve as an internal consultant on data architecture throughout the project development life cycle.
• Lead data discovery and analysis to support the data science team.
• Provide leadership in data engineering for Canadian IM projects, including ETL design and data integration.
• Conduct data analysis and resolve data issues by identifying and addressing root causes.
• Implement process improvements by automating tasks, optimizing data delivery, and enhancing infrastructure scalability.
• Collaborate globally and locally on integration design and map data into target models.
• Support data integration, reporting, and analytics by designing optimal data delivery.
• Assist users with data and data model inquiries.
• Design the semantic layer and architecture of BI tools like Power BI for reporting solutions.
• Help implement BI reports and dashboards.
• Define and enforce data architecture best practices and maintain related policies and standards.
• Maintain diagrams for relational systems and dimensional models for Data Warehouses and Data Marts.
• Review architecture designs from third parties.
• Lead or support projects for requirements gathering and solution architecture.
• Manage Power Apps and Power Automate processes for scheduling and data integration.
• Act as IT owner for specific applications, addressing business issues with global teams.

What We’re Looking For:

• Over 4 years of practical experience in Information Management, specializing in Data Analysis, Integration, Modeling, ETL/ELT, and BI architecture.
• Bachelor's degree in Computer Science, Mathematics, Information Technology, or Engineering.
• Proficient in data analysis and profiling.
• Skilled in writing advanced SQL queries for data exploration, analysis, and reporting.
• Capable of defining and optimizing ETL specifications.
• Experienced with AWS technologies, including RedShift, S3, Python, Glue, and PySpark.
• Expertise in developing dimensional data models for reporting and analytics.
• Familiar with data modeling tools.
• Experienced in using Power Apps and Power Automate.
• Strong project management and business analysis skills for requirements gathering and project leadership.
• Excellent communication skills for stakeholder engagement and design discussions.
• Experience with global IT organizations and offshore teams.
• Knowledgeable in enterprise reporting and analytics tools like Power BI.
• Skilled in developing data structures for an Enterprise Data Warehouse on RedShift.
• Familiarity with NoSQL database architecture and REST API processing would be considered an asset.

Who We Are:

Great People want to Work with us! Find out why:

• GTAA Top Employer Award for 10 years
• Top 100 Employers Award
• Canada’s Most Admired Corporate Culture
• Learn more about working with us in Canada
• View our YouTube channel

At AstraZeneca Canada, you will be part of a team of specialists that is valued across the enterprise. Our role is crucial during this time of evolution for AstraZeneca. We are encouraged to apply entrepreneurial thinking in a creative yet rigorous environment. Our strength lies in our global network where we work seamlessly together. The business invests in our growth; whether deepening expertise or expanding horizons. We thrive on challenge and change. Here you can expect respect for diverse views while working collaboratively to solve challenges. Our workplace values wellbeing and flexibility.

Join us at AstraZeneca Canada where your expertise can make a significant impact!

AstraZeneca is an equal opportunity employer that is committed to diversity and inclusion and providing a workplace that is free from discrimination. AstraZeneca is committed to accommodating persons with disabilities. Such accommodation is available on request in respect of all aspects of the recruitment, assessment and selection process and may be requested by emailing AZCHumanResources@astrazeneca.com (mailto:AZCHumanResources@astrazeneca.com).

AstraZeneca embraces diversity and equality of opportunity. We are committed to building an inclusive and diverse team representing all backgrounds, with as wide a range of perspectives as possible, and harnessing industry-leading skills. We believe that the more inclusive we are, the better our work will be. We welcome and consider applications to join our team from all qualified candidates, regardless of their characteristics. We comply with all applicable laws and regulations on non-discrimination in employment (and recruitment), as well as work authorisation and employment eligibility verification requirements.