Job Type: Permanent
Work Model: Hybrid
Reference code: 130562
Primary Location: Toronto, ON
All Available Locations: Toronto, ON
Our PurposeAt 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 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 a