Will you turn complex data into clear reporting-ready models as an Intermediate BSA? Apply Now!
Working with one of our top financial clients, this role calls for a Technical BSA – Data Migration/Data Modelling who will support a data-focused analytics and reporting initiative, including a Synapse to Databricks migration for global asset management technology.
Pay rate range (CAD): $55.00/hr – $65.00/hr
Responsibilities
Gather, analyse, and translate business and reporting requirements into data solutions
Define business/reporting layer data models, including facts, dimensions, and table structures
Design reporting-layer structures that support large-scale analytics and accurate reporting
Collaborate with Data Engineers and Developers to optimise data architecture and reduce redundancy
Map, reconcile, and validate data coming from multiple source systems
Create detailed user stories and acceptance criteria for delivery teams
Partner with development teams to refine data models throughout the build and integration phases
Support data migration needs by clarifying requirements, dependencies, and acceptance expectations in an Agile environment
Desired Skill-Set
Strong experience as a Technical BSA on data-centric projects
Experience working with large-scale datasets and data warehouses
Strong understanding of dimensional modelling (facts and dimensions)
Ability to define business/reporting layer data models and table structures
Ability to collaborate closely with Data Engineers and Developers on data architecture and design
Hands-on experience with Databricks
Understanding of Medallion Architecture (Bronze, Silver, Gold layers)
Ability to map and reconcile data from multiple source systems
Strong experience gathering, analysing, and translating business/reporting requirements into data solutions
Strong experience writing user stories and acceptance criteria
Excellent communication and stakeholder management skills
Experience working in Agile environments
Self-sufficient professional who can ramp up quickly with minimal supervision
Nice to Have
Experience with Azure Synapse
Experience with data migration projects, particularly Synapse to Databricks migrations
Financial services experience, preferably in asset management, wealth management, mutual funds, or GICs
BeachHead is an equal opportunity agency and employer. We advocate for our candidates and welcome applicants regardless of race, color, religion, national origin, sex, age, or physical or mental disability. BeachHead or our clients may use technology-enabled tools, including automation and artificial intelligence (AI), to support parts of the recruitment process such as resume screening, application management, and candidate matching. These tools assist our recruiters and our clients, and do not replace human decision-making. This job posting represents a current or anticipated vacancy. The position may be filled at any time, and the posting may be removed without notice once the role has been filled.
Privacy Policy

Technical BSA – Data Migration/Data Modelling

Similar Other Jobs

Associate Director of HR Technology - HR Data Platform

Senior Clinical Data Manager

Implementation Financial Data Manager - Nationwide, US

EMR Architect - Data

AI Architect

Data Center Development Manager