Software Developer – Senior

Job Title: Software Developer - Senior
Location: Toronto, Ontario
Work Model: Onsite
Submission Deadline: 2026-07-02, 12:00 p.m. EST

Description / Responsibilities / Skills

Must Have

• Strong Power BI Developer - 10+ years
• Strong expertise in Power BI Desktop and Power BI Service
• Advanced knowledge of DAX (Data Analysis Expressions)
• Proficiency in Power Query (M Language) for data transformation
• Strong SQL skills for querying and managing data
• Experience in data modeling (Star Schema, Fact & Dimension tables)
• Ability to create interactive dashboards and reports
• Knowledge of ETL processes and data integration
• Experience connecting to multiple data sources (databases, APIs, cloud platforms)
• Understanding of performance optimization for reports and datasets
• Implementation of Row-Level Security (RLS) and data governance
• Familiarity with Microsoft Fabric, Azure, and cloud analytics platforms
• Strong analytical and problem-solving skills
• Ability to translate business requirements into actionable insights
• Excellent data visualization and storytelling capabilities
• Good stakeholder communication and documentation skills
• Experience with report deployment, sharing, and workspace management
• Knowledge of data warehousing and BI best practices
• Relevant certifications such as PL-300 Power BI Data Analyst

Description

Project Description

• The Community Services I&IT Cluster (CSC) supports ministries by providing information management tools that help enable public policy decision making, business and strategic planning, and program support and improvement.
• This role will provide the necessary support for project activities for the Early Years Integration Analytics (EYIA).
• This position will be responsible for performing business transformations to the information management tools, as well as implement change requests for business enhancements and incremental new functionality releases.

Responsibilities

• Ensure seamless integration of new and existing systems, applications, and platforms
• Evaluate and recommend technology stacks, platforms, and tools to support business goals
• Design systems with a focus on security, compliance, and data privacy standards
• Work closely with stakeholders such as business units, development teams, IT infrastructure teams
• Ensure solutions are scalable, reliable, and optimized for future growth
• Provide technical support and participate in development, package creation, code merge, testing and release activities
• Act as primary interface between technical teams and business stakeholders for requirements clarification and UAT
• Develop and manage solutions using Power BI, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools

Skills

Experience and Skill Set Requirements

Technical Experience - 50%

• 10+ years of experience as a Software Designer & Developer
• Required Skills: Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
• Preferred Skills: Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control
• Extensive experience designing and implementing BI solutions for on-premise and cloud environments
• Over 5+ years of hands-on experience in ETL development and data warehousing
• Deep knowledge of Microsoft technology stack including Azure Data Factory, SSIS, SSAS, SSRS, Power BI
• Experience with data governance and role-based access control using Azure AD

Power BI Expertise

• Experience with Power BI Server and Power BI Service
• Designing dashboards, reports, and visualizations
• Implemented row-level security, automated refresh scheduling, and performance optimization
• Integration with MS BI tools and Azure services

Data Modeling & ETL

• Expertise in semantic models, dimensional models, and data warehouse architectures
• ETL development using SSIS and Azure Data Factory
• Data ingestion, staging, cleansing, and integration
• Experience with PowerDesigner and Erwin Data Modeler

Release Pipeline Automation & Scripting

• Automating ETL and Power BI deployments using CI/CD pipelines
• Scripting using PowerShell, Python, or command-line tools
• Automated testing, validation, and rollback mechanisms
• Version control integration

Core Skills - 25%

• Ability to define technical roadmap and provide recommendations
• Knowledge of systems design and development
• Analytical and problem-solving skills
• Ability to guide architecture leveraging Azure cloud services
• Knowledge of technology, data, databases, and networking tools

Project Experience and Techniques 10%

• Experience with technology upgrade/migration projects
• Experience leading stakeholder discussions and requirement gathering
• Experience with SDLC processes, Agile and Waterfall methodologies

Communication Skills - 10%

• Analytical problem solving and decision making
• Negotiation and communication skills
• Stakeholder engagement and consensus building

Public Sector Experience - 5%

• Previous public sector experience
• Experience designing and developing applications that comply with GOITS standards