Technical BSA – Data Migration (Asset Management)
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 (Asset Management) 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.