Intermediate Data Analytical Specialist​/Scientist

We are seeking a highly skilled Intermediate Data Analytical Specialist/Scientist to drive the end-to-end development, modeling, and delivery of advanced Business Intelligence (BI) and analytics solutions. In this role, you will take technical ownership of translating complex business requirements into high-performance semantic data models, interactive dashboards, and automated data integration pipelines. Operating at the intersection of data engineering and quantitative analysis, you will analyze high-volume, structured, and unstructured datasets to surface critical operational trends, establish robust data governance, and produce actionable insights that support evidence-based executive decision-making.

Location:

Toronto, ON (Hybrid)

Duration: 10-month contract.

Advantages
End-to-End Solutions Autonomy:
Command complete, 100% focused ownership over high-visibility data assets and reporting pipelines.

Advanced Modern Stack Footprint:
Maximize your platform profile using premier Microsoft BI suite layers, cloud data warehouses, and modern analytics ecosystems.

High-Impact Evidence-Based Influence:
Turn raw, complex administrative and financial data into visual, data-driven narratives for executive-level audiences.

Cross-Functional Integration Sandbox:
Collaborate directly with technical infrastructure squads, delivery teams, and senior cross-cluster leaders.

Responsibilities
BI Dashboard & Report Engineering:
Design, develop, and deploy interactive enterprise-level Power BI dashboards, scorecards, and high-impact KPI reports tailored to diverse organizational needs.

Advanced Data Transformation & DAX:
Author complex data preparation workflows using Power Query (M language) and develop robust analytical calculations using advanced Data Analysis Expressions (DAX).

Data Modeling & Schema Architecture:
Construct scalable semantic architectures and multi-tier dimensional frameworks featuring optimized fact and dimension tables under standard Star Schema designs.

Advanced Querying & ETL Pipelines:
Write and tune complex SQL statements to extract, stage, and transform data from massive data warehouses, assisting Lead Developers with SSIS package creation and data ingestion streams where necessary.

Data Quality & Governance Administration:
Oversee strict data cleansing, validation, and data quality metrics while configuring secure workspace publishing, automated data refreshes, and Row-Level Security (RLS) guardrails.

Statistical Modeling & Analysis:
Apply rigorous mathematical and statistical techniques to build predictive algorithms, model diverse business scenarios, and isolate data patterns or operational risks.

Stakeholder Consultation & Requirements Clarification:
Partner closely with business groups, functional experts, and Data Architects to elicit complex requirements, facilitate solution design workshops, and manage expectations.

Technical Documentation & Handoff:
Author detailed data dictionaries, KPI metrics catalogs, and source-to-target mapping books while delivering clear end-user operational training and platform documentation.

Qualifications
Core Analytics Seniority: 5+ years of progressive professional experience serving as a Data Analyst, BI Developer, or Data Scientist within large enterprise IT frameworks or complex data warehousing projects.

Power BI & Service Expertise:
Strong, hands-on experience using Power BI Desktop and Power BI Service for report publishing, app workspace management, and configuring data governance controls like Row-Level Security (RLS).

Analytical Querying

Languages:

Advanced proficiency writing complex, optimized SQL statements for data extraction, transformation, and structural validation across large relational or multi-dimensional data stores.

Data Engineering & Modeling Depth:
Demonstrated experience building data pipelines (ETL/ELT) and setting up Star Schema dimensional designs (Fact & Dimension tables) using Power Query (M Language).

Quantitative & Statistical Acumen:
Solid background applying foundational mathematics, statistical modeling, data mining, or programmatic scripts to analyze high-volume, complex structured and unstructured sources.

Interface & Visualization Storytelling

Skills:

Outstanding capability to translate abstract technical constraints into highly communicative dashboards, executive summaries, and user-friendly visual interfaces.

Soft Skills:

Superior consultative relationship management, requirement elicitation, and presentation skills, with a track record of clarifying data dependencies to both technical and non-technical stakeholders.

Nice to Have:
Prior professional experience delivering software or business intelligence solutions that comply with public sector enterprise architecture standards (e.g., GO-ITS standards).

Formal analytical certifications, such as the PL-300:
Microsoft Power BI Data Analyst credential.

Summary
If you're interested in the "Intermediate Data Analytical Specialist/Scientist" role based in Toronto, we encourage you to apply online at  Only…