Data Integration Developer

KPMG-Canada; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

KPMG Canada is seeking a Data Integration Developer to join their Operation Team. This role involves delivering data integration solutions for internal clients using Microsoft Azure Data Services. Responsibilities include developing ETL processes, managing data pipelines, and ensuring compliance with security standards. Candidates should have proficiency in Azure Data Factory, strong SQL skills, and experience with data visualization tools like Power BI. Join KPMG in fostering a diverse and inclusive workplace.

Qualifications

• Proficient in Azure Data Factory and ETL processes for data integration tasks.
• Ability to automate with scripting languages like Python or PowerShell.
• Experience in data security practices and regulatory compliance.

Responsibilities

• Develop and implement data integration solutions using Azure services.
• Migrate on-premises data to Azure cloud environments.
• Design and maintain ETL processes for data extraction and loading.

Skills

Data Pipeline Management

Azure Data Factory

Data Security

ETL Processes

Troubleshooting

SQL

Scripting Languages

Education

Microsoft Azure Certifications

Tools

Azure DevOps

Power BI

Job description

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 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

• Proficiency 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.
• 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.

Adjustments and accommodations throughout the recruitment process

At KPMG, we are committed to fostering an inclusive recruitment process where all candidates can be themselves and excel. We aim to provide a positive experience and are prepared to offer adjustments or accommodations to help you perform at your best. Adjustments (informal requests), such as extra preparation time or the option for micro breaks during interviews, and accommodations (formal requests), such as accessible communication supports or technology aids, are tailored to individual needs and role requirements. You will have an opportunity to request an adjustment or accommodation at any point throughout the recruitment process. If you require support, please contact KPMG's Employee Relations Service team by calling 1-888-466-4778.

Create a job alert for this search