Location: Toronto, Hybrid (2-3 days per week, near Union Station)
Language: English, strong written and spoken communication required
Duration: 6-month contract, January 4, 2027 to June 30, 2027
About the Opportunity
Join a leading institutional investment organization as a Senior Data Engineer supporting a major Eagle platform upgrade. You’ll play a key role in building automated reconciliation and regression-testing solutions that help ensure critical investment data remains accurate, complete, and reliable throughout the transition.
Working closely with Core Data, Performance, IT teams, and technology partners, you’ll bring strong data engineering expertise to a high-impact transformation. Your work will span positions, transactions, holdings, valuations, cash, reference data, and performance outputs, helping teams confidently validate the upgraded environment and prepare for cutover.
What’s In It for You
• Work on a high-profile data transformation within a sophisticated investment environment
• Gain exposure to complex investment data, enterprise platforms, and upgrade initiatives
• Collaborate with experienced technical and business teams across the organization
• Apply modern Azure data engineering practices while solving meaningful data-quality challenges
Your Responsibilities
• You’ll build reusable reconciliation and regression-testing solutions using Azure Databricks, Python/PySpark, Spark SQL, and Oracle SQL/PLSQL.
• You’ll compare current and upgraded Eagle environments and downstream platforms, investigating variances and root causes.
• You’ll automate validation across positions, transactions, holdings, reference data, valuations, cash, and performance-related outputs.
• You’ll develop configurable comparison logic, tolerance thresholds, exception reporting, logging, monitoring, and clear pass/fail results.
• You’ll support test cycles, defect remediation, retesting, business sign-off, and produce traceable technical evidence and documentation.
• You’ll apply source control and CI/CD practices, preferably using Azure DevOps, while developing repeatable execution processes.
Skills and Qualifications
• 7+ years of hands-on data engineering, data warehousing, data integration, or data-quality engineering experience
• Strong production-level Azure Databricks and Python/PySpark experience, including automated data comparison and testing
• Advanced Oracle SQL/PLSQL skills, including complex queries, performance tuning, and troubleshooting large datasets
• Proven experience developing automated data reconciliation, validation, or regression-testing solutions
• Experience with investment management, asset management, banking, or capital-markets data and business processes
• Strong analytical, problem-solving, documentation, and stakeholder communication skills
• Experience with Eagle PACE, Eagle Data Management, Eagle Accounting, pytest, Azure Data Factory, Airflow, Snowflake, Power BI, or broader Azure data services is an asset
Why Partner with Altis
If you’ve never worked with a staffing agency before, we make it easy. We work with top employers across Canada who have great jobs to fill, each vetted and verified by our team. When you apply for a job with Altis, we get to know you as a candidate and learn what your strengths are. Then, if you’re a solid match, we handle all the logistics, advocating for you as a candidate for the role, providing access to coaching and connecting you directly with the hiring manager. And rest assured, all our services are free of cost for candidates.
We’re an equal opportunities employer committed to increasing diversity and inclusion in today’s workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Minorities, women, LGBTQ candidates, and individuals with disabilities are encouraged to apply. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions.