Business Information Management Analyst

Creative Solutions Services, LLC; Toronto; Hybrid; CAD 110,000 - 131,000; Full time

Benefits offered by this job

Hybrid work model

4 days on-site, 1 day WFH

Job summary

Creative Solutions Services, LLC is seeking a Business Information Management Analyst for a 12‑month contract in Toronto, ON. The role focuses on migrating 300 dashboards and related scripts from the current analytical environment to Unity Catalog and migrating Tableau to Power BI, within a hybrid work arrangement.

The contractor will lead technical aspects from inception through deployment, participate in SDLC sessions, and produce design documentation.

Qualifications

• 7–10 years of professional data management and analytics experience.
• Experience with Azure cloud environments (7+ years).
• Proficient in PySpark and SQL; Tableau/Power BI experience.
• Experience migrating dashboards and workloads across systems.
• Strong SDLC/documentation and design specification experience.

Responsibilities

• Lead technical aspects of the data migration project from inception through deployment.
• Participate in analysis and system design specification sessions.
• Produce documentation of design options and solutions per SDLC.
• Analyze large data sets, draw insights and communicate outputs.
• Read data schemas, metadata, ER diagrams, and other technical docs; write documentation.
• Work across PySpark/Databricks and Tableau/Power BI within the same use case.
• Migrate dashboards/workloads from Synapse to Unity Catalog; Tableau to Power BI.
• Contribute to performance measurement targets and migration metrics.

Skills

Azure Cloud

PySpark

SQL

Tableau

Power BI

Databricks

Unity Catalog

Synapse

Data migration

Communication

Python

Education

Undergraduate degree

Tools

Databricks

Unity Catalog

Synapse

Tableau

Power BI

Job description

Business Information Management Analyst

Location: Toronto, ON

Onsite Flexibility: Hybrid — 4 days on-site, 1 day work from home

Contract Details

• Position Type: Contract
• Contract Duration: 12 months (with potential for extension based on performance and business needs)
• Pay Rate: C$80.00–C$95.00 / Hour (CAD)
• Shift / Schedule: Monday–Friday, standard business hours
• Travel Requirements: Not required

Job Summary

This role sits within a data migration project at a leading financial institution, focusing on the technical aspects of migrating dashboards, workloads, and scripts from a current analytical environment. The contractor will be responsible for leading technical aspects of the project from inception through to deployment, participating in analysis and system design specification sessions, and producing documentation of design options and solutions according to System Development Life Cycle (SDLC) methodology. The position is a hybrid technical profile — not a pure data engineer or pure BI developer — requiring the ability to work across both PySpark/Databricks code and Tableau/Power BI dashboards. The current project scope encompasses 300 dashboards plus numerous scripts and use cases, with the primary migration path running from Synapse/current analytical environment to Unity Catalog and from Tableau to Power BI. Migration strategy and tools are already defined; candidates are not expected to design the migration strategy. Initially, the work will be primarily migration; new dashboard development may come later. The contractor will have access to customer data and is expected to interact primarily within an internal-only environment with minimal meeting time (maximum 2.5 hours per week, only if needed).

Key Responsibilities

• Lead technical aspects of the data migration project from inception through to deployment.
• Participate in analysis and system design specification sessions.
• Produce documentation of design options and solutions according to SDLC methodology.
• Analyze large data sets, draw insights and inferences, and communicate outputs.
• Read and comprehend data schemas, metadata, entity relationship diagrams, and other technical documentation, as well as write documentation.
• Work across both PySpark/Databricks code and Tableau/Power BI dashboards within the same use case, rather than simply executing a migration mechanically.
• Migrate dashboards and workloads from Synapse/current analytical environment to Unity Catalog.
• Migrate Tableau and Power BI dashboards as part of the current migration scope.
• Contribute to performance measurement targets including percentage of dashboards/workloads migrated vs. total inventory, query/runtime improvements post-migration, percentage of new reports created, and percentage of Synapse-dependent workloads eliminated.

Required Skills

• 7–10 years of technical knowledge or experience with Cloud environments (MS Azure) as well as experience with Data Management and Analytics.
• 7–10 years of strong technical knowledge and experience with PySpark, SQL, Tableau, and Power BI.
• 7–10 years of experience with analyzing large data sets, drawing insights and inferences, and communicating outputs.
• Experience with reading and comprehending data schemas, metadata, entity relationship diagrams, and other technical documentation, as well as writing documentation.
• 7–10 years of Databricks experience, Unity Catalog experience, and Synapse experience.
• Excellent verbal and written communication with the ability to work collaboratively and effectively in a team environment.
• Strong statistical and analytical skills as well as a passion for analytics.
• Strong hybrid technical profile encompassing both data engineering fundamentals and BI development (Power BI, Tableau).
• Understanding of BI dashboards and underlying code/data pipelines.
• Data migration experience.
• Strong soft skills: curiosity, adaptability to change, enthusiasm, and willingness to learn.
• Strong delivery/results orientation and long-term commitment.

Preferred Skills

• Banking experience.
• Project management experience.
• Experience with Data/Text Mining, Optimization, Algorithm Development, Automation, Data Visualization, Simulation, and developing dashboards.
• Financial services industry background.

Education Requirements

• Undergraduate degree or technical degree preferred; preferred fields include math, physics, engineering, or computer science.

Required Experience

• 7–10 years of overall professional experience is required.
• Demonstrated experience on data migration projects.
• Experience with Azure Cloud environments (7 years).
• Experience analyzing large data sets (7 years).
• Experience using analytical software tools such as Tableau or Power BI.
• Strong Python or PySpark experience (Python may substitute for PySpark for candidates with strong Power BI/Tableau and data engineering exposure).

Nice-to-Have Experience

• Banking or financial services experience (2 years preferred).
• Experience with Data/Text Mining, Optimization, Algorithm Development, and Automation.

Work Environment / Physical Requirements

• Hybrid schedule: 4 days on-site in Toronto, Ontario; 1 day work from home.
• Training period: 2 weeks.
• Meetings capped at a maximum of 2.5 hours per week, only if needed.
• No overtime required.
• No rotation required.
• Contractor will have access to customer data.
• Interview process: 2 rounds; preference is in-person (if the first interview is virtual, a second in-person interview is mandatory); approximately 30–45 minutes each. Candidates must provide at least 24 hours' notice if they cannot attend — last-minute cancellations or rescheduling are viewed very negatively.

About the Client

This client is a top 10 North American bank providing comprehensive retail, commercial, and wealth management solutions across Canada and the United States. With a broad geographic footprint serving millions of customers across North America, the organization employs tens of thousands of professionals spanning banking, finance, technology, data analytics, and business intelligence functions who collaborate across large, dynamic teams.