senior software developer.

We are seeking a highly accomplished Senior Software Developer with master-level expertise in the Microsoft Business Intelligence suite to lead the design, development, and deployment of enterprise-scale data analytics and visualization solutions. In this role, you will take technical ownership of translating complex business requirements into high-performance semantic models, responsive dashboards, and automated ETL pipelines. Operating across both on-premise and cloud environments, you will bridge the gap between technical infrastructure squads and business stakeholders, ensuring that all implementations are secure, optimized, and aligned with enterprise architectural standards and industry best practices.

Location: Toronto, ON (Hybrid)

Duration: 10-month contract.

Advantages
Master-Level Toolchain Autonomy: Direct the technical path, modeling parameters, and layout design for high-visibility corporate business intelligence portfolios.

Cloud-Edge Modernization Footprint: Expand your professional profile by helping steer migrations toward cutting-edge analytics spaces like Microsoft Fabric and Azure Cloud environments.

End-to-End Pipeline Ownership: Command the complete data lifecycle—from raw transactional ingestion and multi-tier ETL transformations to client-facing interactive data stories.

High-Impact Governance Exposure: Lead the enforcement of enterprise data security metrics, data lineage pipelines, and automated continuous delivery release rules.

Responsibilities
Business Intelligence Solution Engineering: Architect, design, and implement scalable BI reporting solutions using Microsoft Power BI across on-premise servers and cloud spaces to satisfy complex business analytics requirements.

Semantic & Advanced Data Modeling: Construct robust data warehouse layouts, semantic models, and multi-tier dimensional frameworks featuring star and snowflake schemas with optimized fact and dimension tables.

Complex Data Transformation: Author advanced data preparation workflows using Power Query (M Language) and write efficient database queries across Oracle and MS-SQL platforms to ingest, stage, and cleanse unstructured or structured records.

Calculated Expression Programming: Write, tune, and optimize complex Data Analysis Expressions (DAX) to deliver deep statistical insights, calculated tables, and programmatic KPIs.

Performance Tuning & Optimization: Conduct proactive dataset diagnostics, identify query processing bottlenecks, and establish data refresh patterns to maximize runtime speeds for enterprise data engines.

Security & Governance Administration: Operationalize granular data protection controls by implementing Row-Level Security (RLS) and setting up role-based access controls (RBAC) via cloud directory services.

CI/CD Release Automation: Orchestrate automated ETL and report delivery streams using continuous integration and deployment pipelines, utilizing version control tools and scripting languages like PowerShell or Python.

Cross-Functional Stakeholder Liaison: Act as the primary technical interface between business units and engineering teams, translating user requirements into precise system designs, organizing requirements workshops, and guiding User Acceptance Testing (UAT).

Technical Artifact Generation: Formulate complete system documentation packages, including logical data flow diagrams, technical source-to-target mapping books, release manifest journals, and corporate data dictionaries.

Qualifications
Core Software Engineering Seniority: 10+ years of progressive professional experience serving as a Software Designer and Developer, with a dedicated focus on building complex, enterprise-level data architectures.

Power BI & DAX Expertise: Advanced, master-level proficiency using Power BI Desktop, Power BI Server (On-Prem), and Power BI Service (Cloud), alongside deep practical expertise writing complex DAX expressions and utilizing Power Query (M Language).

Database & Advanced SQL Skills: Strong practical experience managing and querying enterprise relational database structures across MS SQL Server and Oracle using advanced SQL scripting, data replication strategies, and query tuning.

ETL & Data Warehousing Toolkit: 5+ years of verified hands-on experience designing and implementing ETL/ELT data integration solutions using tools such as SSIS, Azure Data Factory, or Informatica.

Release Pipeline Automation Literacy: Direct professional background automating software deployments and environment promotions through CI/CD pipelines via Azure DevOps, GitHub Actions, or similar configuration engines.

Methodological Fluency: Thorough operational knowledge of structured Systems Development Life Cycle (SDLC) processes across both Agile and Waterfall methodologies, including active experience running backlog refinement and requirements gathering sessions.

Soft Skills: Exceptional analytical problem-solving, stakeholder engagement, and consultative communication skills, with a proven capability to negotiate technical paths and compile rigid reference guides (Release Books) for operational teams.

Nice to Have:
Active industry certifications, such as the PL-300: Microsoft Power BI Data Analyst credential.

Prior technical delivery experience producing applications or BI dashboards that comply with public sector enterprise architecture policies and GO-ITS infrastructure standards.

Foundational understanding of digital accessibility requirements, including AODA regulations and standards.

Summary
If you're interested in the "Senior Software Developer" role based in Toronto, we encourage you to apply online at Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to View email address on randstad.com to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies. show more