Senior Data Integration Developer

Posted Yesterday

AI Interview Copilot

Job Details

Full Time

Location

Canada

Job Description

Overview
At KPMG, you'll join a team of diverse and dedicated problem solvers, connected by a common cause: turning insight into opportunity for clients and communities around the world.

The role of a Senior Data Integration Developer (Operation Team) is to deliver services and solutions for KPMG Canada internal clients through the Enterprise Analytics CoE using the suite of Microsoft Azure Data Services and data integrations.

What you will do

Develop and implement data integration solutions using Azure services like Azure Data Factory, Logic Apps, and Azure Synapse Analytics
Migrate on-premises data to Azure cloud environments, ensuring data integrity and consistency
Design, develop, and maintain ETL (Extract, Transform, Load) processes to extract data from various sources, transform it according to business requirements, and load it into data warehouses or data lakes
Build and manage data pipelines, ensuring their smooth operation, troubleshooting issues, and optimizing performance
Create and maintain data models for structured and unstructured data, ensuring data is accurately represented and accessible
Work closely with business analysts, data engineers, and other stakeholders to understand data requirements and deliver appropriate solutions
Ensure that all data integration processes comply with organizational security policies and regulatory requirements.
Automate data integration tasks to improve efficiency and reduce manual intervention
Document data integration processes, data flow diagrams, and architecture for future reference and maintenance.
Continuously learn and apply new features and best practices for Azure data integration services
Identify and resolve issues within data integration processes, ensuring high availability and reliability of data flows
Optimize data integration workflows for better performance and scalability

What you bring to the role

Atleast 7 years of experience in designing, developing, and managing data pipelines within Azure Data Factory
Familiarity with CI/CD pipelines, version control, and deployment practices using Azure DevOps
Skills in monitoring data integration pipelines and optimizing performance to handle large datasets efficiently
Experience with ETL tools and processes, including data extraction, transformation, and loading into data warehouses or lakes
Understanding of data security practices, including encryption, role-based access control, and compliance with regulatory requirements
Experience in managing a team of developers and conducting code reviews
Ability to create and manage workflows using Azure Logic Apps and develop serverless solutions using Azure Functions
Ability to troubleshoot and resolve issues in data integration processes efficiently
Experience with data visualization and analytics tools like Power BI or Azure Analysis Services
Proficiency in scripting languages like Python, PowerShell, or Scala for automation and data processing tasks
Experience with integrating data from APIs and other web services into Azure-based solutions
Understanding of Azure storage options like Blob Storage, Data Lake Storage, and Azure Files
Strong knowledge of SQL, including complex queries, stored procedures, and database management with platforms like Azure SQL Database and SQL Server
Current Microsoft Azure certifications are a plus

Providing you with the support you need to be at your best
Our Values, The KPMG Way
Integrity, we do what is right | Excellence, we never stop learning and improving | Courage, we think and act boldly | Together, we respect each other and draw strength from our differences | For Better, we do what matters

KPMG in Canada is a proud equal opportunities employer and we are committed to creating a respectful, inclusive and barrier-free workplace that allows all of our people to reach their full potential. A diverse workforce is key to our success and we believe in bringing your whole self to work. We welcome all qualified candidates to apply and hope you will choose KPMG in Canada as your employer of choice. For more information about Inclusion, Diversity & Equity in Recruitment, please click here .

Adjustments and accommodations throughout the recruitment process
At KPMG, we strive for an inclusive recruitment process that allows all candidates to Come As You Are and Thrive with Us. We aim to provide a positive experience and are ready to offer adjustments or accommodations to help you perform at your best. Adjustments (an informal request), i.e. extra preparation time or the option for micro breaks during interviews, and accommodations (a formal request), i.e. accessible communication supports or technology aids are tailored to individual needs and role requirements.

To begin a confidential conversation about adjustments or accommodations at any point throughout the recruitment process, we encourage you to contact KPMG's Employee Relations Service team for support by emailing cdnersteam@kpmg.ca or by calling 1-888-466-4778, Option 3.

For information about accessible employment at KPMG, please visit our accessibility page .

About KPMG

KPMG LLP is the Canadian member firm of KPMG International. We provide Audit, Tax, and Advisory services to many of the public and private business, not-for profit, and public sector organizations in Canada. Nationally, there are 40 offices and over 700 partners and 7,000 employees working together to help Canadian businesses achieve their goals. Leveraging the skills, knowledge and passion of our firm and our people allows us to serve our clients with uncompromising professionalism, cutting through complexity to provide valuable insight—in Canada and around the world. KPMG s.r.l./S.E.N.C.R.L. est le cabinet canadien membre de KPMG International Cooperative (« KPMG International »). Nous offrons des services professionnels en audit et en fiscalité ainsi que des services-conseils à une vaste clientèle composée notamment de sociétés ouvertes et fermées, d’organismes sans but lucratif et d’organisations du secteur public au Canada. KPMG compte 40 bureaux à l’échelle nationale, au sein desquels collaborent plus de 700 associés et 7 000 employés pour aider les sociétés canadiennes à atteindre leurs objectifs. Nous misons sur les compétences et le savoir-faire de notre équipe pour servir nos clients − au Canada et ailleurs dans le monde − avec rigueur et professionnalisme. Notre mission première : simplifier la complexité en proposant des perspectives éclairantes.