Senior Consultant - Data Engineer (Data Conversion & Reconciliation)

Canada
$80,000-138,000 per year
Permanent
Full-time

22 days ago

We use cookies to offer you the best possible website experience. Your cookie preferences will be stored in your browser's local storage. This includes cookies necessary for the website's operation. Additionally, you can freely decide and change any time whether you accept cookies or choose to opt out of cookies to improve website's performance, as well as cookies used to display content tailored to your interests. Your experience of the site and the services we are able to offer may be impacted if you do not accept all cookies. Modify Cookie PreferencesReject All Cookies Accept All CookiesSearch JobsSearch JobsJob DescriptionApply nowStartPlease wait...Job Title: Senior Consultant - Data Engineer (Data Conversion & Reconciliation)Posting Start Date: 9/23/25Job Description:--What will your typical day look like?

Lead data mapping, migration, and validation activities to ensure seamless data conversion processes.
Analyze and document business requirements, operational processes, and test cases related to data conversion and reconciliation.
Collaborate with technical and business stakeholders to define integration points and data flows.
Develop and maintain detailed process documentation, including requirements specifications and test plans.
Utilize SQL, Excel, and other data analysis tools to perform data validation, reconciliation, and quality checks.
Support system integration and user acceptance testing, troubleshooting issues as they arise.
Provide subject matter expertise on asset classes, trade lifecycle, portfolio accounting, and performance measurement.
Work closely with cross-functional teams to ensure alignment on data conversion and operational workflows.

About the teamWe are seeking an experienced Senior Consultant - Business Analyst to join our AI and Data team, focusing on data conversion and reconciliation for large-scale financial platforms. The ideal candidate will demonstrate strong expertise in data modeling, integration points, and operational workflows, with prior experience using BlackRock Aladdin highly advantageous. This role requires a deep understanding of asset classes, trade lifecycle, portfolio accounting, performance measurement, and reconciliation workflows.Enough about us, let's talk about youYou are someone with these required skills, experience and qualifications:

5+ years of strong Python or Scala programming skills (Core Python and PySpark)
5+ years of experience with building and optimizing 'big data' pipelines, architectures, and data sets. Familiarity with data pipeline and workflow management tools (e.g., Airflow, DBT Kafka).
Strong experience implementing solutions on Snowflake
Proven experience as a Business Analyst in data conversion, migration, and reconciliation projects.
Strong understanding of data models, integration points, and operational workflows in financial services.
Prior experience with BlackRock Aladdin is highly advantageous.
Familiarity with asset classes, trade lifecycle, portfolio accounting, and performance measurement.
Top technical / programming skills - Python, Java or Scala, Hadoop Suite, Cloud Data Platforms Preferably Snowflake/Databricks and SQL. Experience working with flat files, Database API sources is a must to both ingest and create transformations.
Proficient in SQL, Excel, and data analysis tools.
Strong documentation skills, including requirements, process, and test documentation.
Excellent analytical, problem-solving, and communication skills.
Ability to work independently and manage multiple priorities in a fast-paced environment.

It would be great for you to have some of these nice to haves as well:

Bachelor's degree in Computer Science, Information Systems, Finance, or a related field.
Experience in deployment, maintenance, and administration tasks related to Cloud (Azure Preferred), OpenStack, Docker, Kafka and Kubernetes
Experience with large-scale system implementations in the asset management or financial services industry.
Knowledge of regulatory requirements and industry best practices in data management and reconciliation.

Total RewardsThe salary range for this position is $80,000 - $138,000, and individuals may be eligible to participate in our bonus program. Deloitte is fair and competitive when it comes to the salaries of our people. We regularly benchmark across a variety of positions, industries, sectors, targets, and levels. Our approach is grounded on recognizing people's unique strengths and contributions and rewarding the value that they deliver.Our Total Rewards Package extends well beyond traditional compensation and benefit programs and is designed to recognize employee contributions, encourage personal wellness, and support firm growth. Along with a competitive base salary and variable pay opportunities, we offer a wide array of initiatives that differentiate us as a people-first organization. On top of our regular paid vacation days, some examples include: $4,000 per year for mental health support benefits, a $1,300 flexible benefit spending account, firm-wide closures known as "Deloitte Days", dedicated days of for learning (known as Development and Innovation Days), flexible work arrangements and a hybrid work structure.Apply nowStartPlease wait...Get connectedServicesIndustriesCareersLegalConnect© 2024. See Terms of Use for more information. Deloitte refers to one or more of Deloitte Touche Tohmatsu Limited, a UK private company limited by guarantee (“DTTL”), its network of member firms, and their related entities. DTTL and each of its member firms are legally separate and independent entities. DTTL (also referred to as “Deloitte Global”) does not provide services to clients. Please see www.deloitte.com/about to learn more about our global network of member firms.×Cookie Consent ManagerWhen you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. Because we respect your right to privacy, you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.Required CookiesThese cookies are required to use this website and can't be turned off.Show More DetailsRequired Cookies Provider Description Enabled
SAP as service providerWe use the following session cookies, which are all required to enable the website to function:

"route" is used for session stickiness
"careerSiteCompanyId" is used to send the request to the correct data center
"JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor
"Load balancer cookie" (actual cookie name may vary) prevents a visitor from bouncing from one instance to another

Functional CookiesThese cookies provide a better customer experience on this site, such as by remembering your login details, optimizing video performance, or providing us with information about how our site is used. You may freely choose to accept or decline these cookies at any time. Note that certain functionalities that these third-parties make available may be impacted if you do not accept these cookies.Show More DetailsFunctional Cookies Provider Description Enabled
YouTubeYouTube is a video-sharing service where users can create their own profile, upload videos, watch, like, and comment on videos. Opting out of YouTube cookies will disable your ability to watch or interact with YouTube videos.Advertising CookiesThese cookies serve ads that are relevant to your interests. You may freely choose to accept or decline these cookies at any time. Note that certain functionality that these third parties make available may be impacted if you do not accept these cookies.Show More DetailsAdvertising Cookies Provider Description Enabled
LinkedInLinkedIn is an employment-oriented social networking service. We use the Apply with LinkedIn feature to allow you to apply for jobs using your LinkedIn profile. Opting out of LinkedIn cookies will disable your ability to use Apply with LinkedIn.AddThisGoogle Analytics is a web analytics service offered by Google that tracks and reports website traffic.

Deloitte

Apply Now