Data Engineering Technical Lead

Mufg Investorservices; Toronto; Hybrid; CAD 70,000 - 110,000; Full time

Job summary

Join a forward-thinking company as a data flow developer, where your expertise in data transformation and validation will be key to enhancing operational efficiency. You will develop and maintain data flows, ensuring accuracy and timely delivery while collaborating with a dynamic team. This role offers an exciting opportunity to work with cutting-edge ETL tools and contribute to innovative solutions within a vibrant culture that embraces hybrid working. If you're passionate about data and looking for a brilliantly different career, this position is perfect for you.

Benefits

Hybrid working

Learning & Development opportunities

Innovative culture

Team collaboration

Qualifications

• 5+ years of experience with ETL tools and data-related process controls.
• Strong skills in Python and SQL for data ingestion and transformation.

Responsibilities

• Develop data flows and maintain existing flows using nifi ETL tool.
• Perform testing and provide post-implementation support for data accuracy.

Skills

Data Transformation

Data Validation

SQL

Python

ETL Tools

Apache NiFi

Data Verification

Agile Methodologies

CI/CD

Attention to Detail

Education

Bachelor's degree in Computer Science

Tools

Apache NiFi

Amazon Redshift

Snowflake

Databricks

GitHub Actions

GitLab CI

Jenkins

Job description

MUFG Investor Services is a trusted partner to many of the world’s largest public and private funds, providing asset servicing and operational solutions built for alternatives. With over $1 trillion in client assets under administration, we offer fund administration, banking, payments, fund financing, foreign exchange overlay, corporate and regulatory services, custody, business consulting, and more. Operating from 17 locations worldwide, we help clients mitigate risk, enhance efficiency, and navigate the operational complexities of today’s investment management landscape. As a division of Mitsubishi UFJ Financial Group (MUFG), one of the world’s largest financial institutions with approximately $3 trillion in assets, we combine deep expertise with the strength and stability of a leading financial institution. To learn more, visit us at www.mufg-investorservices.com.

Job Description

The successful candidate will be part of a team which will be responsible for the correct, timely and efficient flow of data from various source systems to various end points.

You Will:

• Develop data flows based on the requirement by executing the necessary steps of data transformation, data validation and mapping using nifi, SQL and Python.
• Develop necessary components to establish connection with various sources of data and destinations via API, SQL, S3, SFTP and any other communication protocol.
• Maintain and apply changes on existing flows running on nifi ETL tool.
• Perform thorough testing and validation to support the accuracy of data transformations, data verification and delivery.
• Develop unit tests and regression tests.
• Prepare release plans and coordinate with the stakeholders and release engineers to ensure the proper execution.
• Provide post-implementation support and troubleshoot any potential issues.
• Provide 2nd and 3rd level support to operation teams and resolve issues in a timely manner.
• Prepare documentation of existing and new data flows as well as clients’ procedures.

Qualifications

You Have:

• Bachelor’s degree in Computer Science or a related technical field or equivalent experience.
• 5+ years of commercial experience with ETL tools (experience with Apache NiFi will be considered an advantage).
• Experience in data-related process controls.
• Experience working with a team of developers using agile methodologies to achieve planned process deliverables.
• Experience with at least one of the following: Amazon Redshift, Snowflake, or Databricks.
• Extensive experience with writing Python and Pyspark, specifically for writing complex data ingestion pipelines, developing ETL/ELT jobs, and implementing distributed data processing solutions.
• Experience with CI/CD, implementing continuous integration workflows using tools like GitHub Actions, GitLab CI, or Jenkins.
• High level of accuracy and attention to detail.

Preferred:

• Experience with programming languages such as Python will be considered an advantage.
• Experience with Apache Kafka or AWS Kinesis is desirable.

Additional Information

What’s in it for you to join MUFG Investor Services?

Take a look at our careers site and you’ll find everything you’d expect from a career with the fastest-growing business at one of the world’s largest financial groups. Now take another look. Because it’s how we defy expectations that really defines us. You’ll feel that difference in all kinds of ways. Our vibrant CULTURE. Connected team. Love of innovation, laser client focus, and next-level LEARNING & DEVELOPMENT. Oh, and we really walk the talk when it comes to HYBRID WORKING.

So, why settle for the ordinary? Apply now for a Brilliantly Different career.

We thank all candidates for applying; however, only those proceeding to the interview stage will be contacted.