Job Description

Req ID: 27554
Vacancy Type: Permanent
Number of Positions: 1
Closing Date: 01/14/2026
Job Summary
Working for the City means you are part of something big, something special! You will be part of a team of engaging, enthusiastic and dedicated people that are committed to collaborating with one another to deliver on our commitment to the residents, visitors and businesses of Mississauga. This position is responsible for delivering analytics solutions to internal stakeholders that will enhance service delivery to our residents, visitors and businesses in Mississauga. The role includes designing data models, ETL processes, and interactive dashboards, as well as supporting data quality, documentation, and user adoption.?
Duties and Responsibilities

• Gather, analyze, and document analytics and reporting requirements from business stakeholders.
• Design, develop, test, and deploy reports and dashboards using Microsoft Power BI and MS Fabric.
• Build and optimize data models and ETL processes to support reporting and analytics needs.
• Implement advanced Power BI features (DAX, Power Query/M, custom visuals, data transformations) to deliver robust solutions.
• Analyze source systems (e.g., Microsoft SQL Server, Oracle) and develop SQL queries/views for data extraction and integration.
• Conduct data validation and support user acceptance testing with clients and IT partners.
• Provide end user training, coaching, and ongoing support for analytics solutions.
• Prepare clear documentation (functional and technical specs, test cases, user guides, backup and recovery procedures).
• Identify and prototype continuous improvement opportunities for analytics solutions and processes.
• Respond to and resolve Analytics Help Desk tickets in a timely manner.
• Develop training materials and user guides that promote data governance and information management standards.
• Recommend and help implement process improvements, tools, and technologies to increase efficiency and data integrity.
• Perform other related duties as assigned.

Skills and Qualifications

• Post-secondary education in computer science or related discipline
• Minimum of 3 years of experience with database design, data modeling techniques and ETL processes
• Minimum of 3 years of experience in gathering detailed business requirements
• Minimum of 3 years of experience in data visualization, business intelligence tools, data preparation, and statistical and spatial tool sets (MS Fabric, Power BI, SSRS , ArcGIS, Excel, etc.).
• Strong hands-on experience with DAX, Power Query/M, and Power BI data modeling.
• Experience writing and tuning SQL queries and views on Microsoft SQL Server and Oracle databases.
• Understanding of quality management, performance measurement, and analytical techniques (quantitative and qualitative).
• Strong technical, analytical, problem solving, and troubleshooting skills.
• Strong written and verbal communication skills, including the ability to explain technical concepts to non technical audiences.
• Strong organization, initiative, and ability to manage multiple tasks and priorities.
• Commitment to service excellence and total quality
• Certifications in Microsoft Power BI, MS Fabric or Data Analytics is an asset.
• Experience with programming languages and analytics tools (e.g., SQL, Python, R, SAS) is an asset.
• Experience with Azure ML, Azure Foundry is an asset

Hourly Rate/Salary: $ 89,464.00 - $ 119,286.00
Hours of Work: 7
Work Location: Civic Centre
Department/Division/Section: CPS/Corporate Services Dept , CPS/IT Division , Data Flow Insights
Non-Union/Union: Non Union
The City of Mississauga may use artificial intelligence (AI) technology in sourcing candidates for some positions, however, it is not being used for screening, assessing, or selecting candidates.
We thank all who apply, however, only those candidates selected for an interview will be contacted. You can also check your application status in your candidate profile online.
All personal information is collected under the authority of the Municipal Act.
Equity, Diversity and Inclusion
The City of Mississauga is committed to creating a respectful and supportive workplace that fosters a culture of equity, diversity and inclusion which broadly reflects the communities and residents we serve. Throughout the employee life cycle, the City is working to include an EDI lens to attract, retain and support the growth of diverse talent.
Learn more about the City's commitment to .
Accommodations
The City of Mississauga is an Equal Opportunity Employer and is committed to removing barriers in our selection process for people with visible and invisible disabilities. In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, the City of Mississauga will provide accommodations throughout the recruitment, selection and/or assessment process to applicants with disabilities.
If selected to participate in the recruitment, selection and/or assessment process, please complete the following and have it emailed to citing the Job ID and Job Title. This will inform Human Resources of the nature of any accommodation(s) that you may require in respect of any materials or processes used to ensure your equal participation.

Skills Required