Senior Technical Analyst, Data Engineering and Business Intelligence
Fidelity Investments Canada ULC7 months ago
Toronto, CanadaSenior
Responsibilities
- Design, develop, and maintain Python data pipelines, automation scripts, transformations, models, workflows, and internal analytics tools.
- Build and optimize Snowflake data models and SQL solutions, including performance optimization.
- Convert spreadsheet-based models and processes into centralized, scalable Python and Snowflake workflows.
- Automate reporting, data validation, back-testing, and analytical workflows.
- Support Product analytics involving competitor analysis, performance reporting, risk ratings, fund comparisons, research, and ETF capital markets.
- Develop, publish, manage, and support Tableau dashboards, reports, data sources, and other BI assets.
- Support BI platform administration for Tableau Cloud, Power BI Service, and SAP Business Objects.
- Maintain data security, access controls, governance standards, logging, version control, modular code design, and unit testing.
- Collaborate with Product, BI, IT, and Engineering teams to deliver reliable internal analytics solutions.
Requirements
- University degree in Computer Science, Engineering, or equivalent practical experience.
- At least 5 years of experience in Data Engineering, BI Analytics, or a closely related role.
- Strong proficiency in Python for data engineering, automation, and analytics.
- Hands-on experience with Snowflake, including data modeling, SQL development, and performance optimization.
- Advanced SQL skills and experience with relational and cloud-based data platforms.
- Experience building internal data pipelines, automation, or analytics tools.
- Experience with Tableau is preferred; Power BI and/or SAP Business Objects experience is acceptable.
- Ability to translate business problems into scalable data and automation solutions.
- Experience modernizing spreadsheet-driven processes into robust data workflows.
- Experience with Git or similar version control systems and understanding of data governance, security, and access management.
- Strong communication skills and ability to work with technical and non-technical stakeholders.
- Experience supporting financial products or capital-markets analytics is a plus.
- Experience with Informatica Cloud, orchestration, scheduling, workflow automation, or cloud platforms such as AWS is a plus.
- Current work authorization for Canada is required.
Benefits
- Flexible working arrangements with 100% remote, hybrid, and in-office options.
- Annual base salary of $120,000 to $150,000 plus a discretionary performance bonus.
- Company RRSP contributions after six months without requiring employee matching.
- Comprehensive health benefits beginning on the first day, including 100% employer-paid premiums and up to $5,000 annually for mental health services and therapy.
- Parental leave top-up to 100% of salary for 25 weeks.
- Up to $650 for home office equipment.
- Generous time off policy, including two paid volunteer days annually.
- Diversity and inclusion programs, employee resource groups, professional development courses, tuition reimbursement, and rewards for completing a required designation.
- The role is based at 483 Bay Street in Toronto until approximately late 2026, then moves to 3 Robert Speck Parkway in Mississauga under Fidelity’s flexible hybrid working arrangement.
About Fidelity Investments Canada ULC
Fidelity Investments Canada ULC offers mutual funds and managed investment solutions for individual investors, advisors, and institutions, and provides trade execution, clearing, custody, and back-office services through Fidelity Clearing Canada. It earns fees from asset management and securities servicing. Founded in 1987 and headquartered in Toronto, it is part of the Fidelity Investments group, a global financial services company.