Senior Consultant - Data Engineer (Data Conversion & Reconciliation)

Job Type: Permanent
Work Model: Hybrid
Reference code: 130562
Primary Location: Toronto, ON
All Available Locations: Toronto, ON

Our Purpose

At Deloitte, our Purpose is to make an impact that matters. We exist to inspire and help our people, organizations, communities, and countries to thrive by building a better future. Our work underpins a prosperous society where people can find meaning and opportunity. It builds consumer and business confidence, empowers organizations to find imaginative ways of deploying capital, enables fair, trusted, and functioning social and economic institutions, and allows our friends, families, and communities to enjoy the quality of life that comes with a sustainable future. And as the largest 100% Canadian-owned and operated professional services firm in our country, we are proud to work alongside our clients to make a positive impact for all Canadians.

By living our Purpose, we will make an impact that matters.

• Have many careers in one Firm.
• Enjoy flexible, proactive, and practical benefits that foster a culture of well-being and connectedness.
• Learn from deep subject matter experts through mentoring and on the job coaching

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 team

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

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

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

Our promise to our people: Deloitte is where potential comes to life.

Be yourself, and more.
We are a group of talented people who want to learn, gain experience, and develop skills. Wherever you are in your career, we want you to advance.

You shape how we make impact.
Diverse perspectives and life experiences make us better. Whoever you are and wherever you're from, we want you to feel like you belong here. We provide flexible working options to support you and how you can contribute.

Be the leader you want to be
Some guide teams, some change culture, some build essential expertise. We offer opportunities and experiences that support your continuing growth as a leader.

Have as many careers as you want.
We are uniquely able to offer you new challenges and roles - and prepare you for them. We bring together people with unique experiences and talents, and we are the place to develop a lasting network of friends, peers, and mentors.

The next step is yours

At Deloitte, we are all about doing business inclusively - that starts with having diverse colleagues of all abilities. Deloitte encourages applications from all qualified candidates who represent the full diversity of communities across Canada. This includes, but is not limited to, people with disabilities, candidates from Indigenous communities, and candidates from the Black community in support of living our values, creating a culture of Diversity Equity and Inclusion and our commitment to our AccessAbility Action Plan , Reconciliation Action Plan and the BlackNorth Initiative .

We encourage you to connect with us at View email address on onjobcentre.ca if you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations) or View email address on onjobcentre.ca for any questions relating to careers for Indigenous peoples at Deloitte (First Nations, Inuit, Métis).

When you apply, we will review your application using Deloitte's Global Talent Standards to ensure a consistent recruitment experience. Our recruitment advisors and hiring teams will utilize human screening combined with AI technology to help identify the skills and qualities that matter most to our business, while safeguarding your privacy and using AI responsibly.

Deloitte Canada has 20 offices with representation across most of the country. We acknowledge that Deloitte offices stand on traditional, treaty, and unceded territories in what is now known as Canada. We recognize that Indigenous Peoples have been the caretakers of this land since time immemorial, nurturing its resources and preserving its natural beauty. We acknowledge this land is still home to many First Nations, Inuit, and Métis Peoples, who continue to maintain their deep connection to the land and its sacred teachings. We humbly acknowledge that we are all Treaty people, and we commit to fostering a relationship of respect, collaboration, and stewardship with Indigenous communities in our shared goal of reconciliation and environmental sustainability.

#body.unify div.unify-button-container .unify-apply-now:focus, #body.unify div.unify-button-container .unify-apply-now:hover{color:rgb(0,0,0) !important;}#body.unify div.unify-button-container .unify-apply-now:focus, #body.unify div.unify-button-container .unify-apply-now:hover{background:rgba(41,122,40,1.0) !important;}