Analytics Developer, IT

City of Mississauga; Mississauga; Hybrid; Full time

Job summary

The City of Mississauga seeks a dedicated individual to join its team as an analytics professional. In this role, you will enhance service delivery through innovative analytics solutions, working with data modeling and Power BI to improve outcomes for the community. Your expertise in data visualization and collaboration will help drive excellence in public service.

Qualifications

• Minimum 3 years of experience in data modeling and SQL.
• Experience in developing and implementing Power BI analytics.
• Strong analytical and problem-solving skills.

Responsibilities

• Gather and document analytics business requirements.
• Develop functional and technical specifications.
• Implement Microsoft Power BI solutions.

Skills

Data Modeling

DAX

SQL Queries

Power BI

ETL Processes

Problem Solving

Data Visualization

Communication

Education

Post-secondary education in computer science or related discipline

Tools

Microsoft Power BI

Microsoft SQL Server

Oracle

Job description

Req ID:26707
Vacancy Type: Temporary
Contract Duration: up to 2 years
Number of Positions:1
Closing Date:06/20/2025

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.

Duties and Responsibilities

Under the direction of the Program Manager, Analytics, the successful candidate will:

• Gather and document analytics business requirements
• Develop functional and technical specifications based on business requirements
• Perform data modelling and design, develop, test and implement Microsoft SQL data marts
• Design, develop, test and implement ETL processes
• Design, develop, test and implement front end reporting and dashboard solutions using Microsoft Power BI
• Optimize Microsoft PowerBI analytics for performance, scalability, and user experience
• Implement advanced Microsoft PowerBI features such as custom visuals, DAX calculations, and data transformations
• Analyze application databases (Microsoft SQLServer, Oracle) and develop SQL scripts/queries for data extraction
• Perform data quality analysis and implement solutions to ensure accurate data quality
• Conduct data validation with clients and other IT resources in support of end-user testing/acceptance and sign-off
• Provide end user training and support
• Prepare various types of documentation including functional designs, technical specifications, test plans/scripts, software code, user guides, backup and recovery procedures, etc.
• Identify continuous improvement opportunities through prototyping, documenting and recommending possible solutions
• Troubleshoot and resolve Analytics Help Desk support tickets
• Perform other 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 developing functional and analytics designs that leverages the latest features and capabilities in Power BI
• Minimum of 2 years of experience in developing and implementing Microsoft Power BI analytics
• Demonstrated experience in DAX, M-language, and Power Query for data modeling and transformation
• Demonstrated experience in implementing data visualization principles and best practices
• Demonstrated experience in analyzing and developing SQL queries and views on Microsoft SQLServer and Oracle databases
• Solid technical, analytical, problem-solving, and troubleshooting skills
• Strong communication (written and oral) and presentation skills
• Strong initiative, organizational skills and ability to adapt and handle multiple tasks
• Commitment to service excellence and total quality
• Certifications in Microsoft Power Platform or Data Analytics is an asset
• 3+ years of experience in Agile Development methodology is an asset

Hourly Rate/Salary:$ 49.16 - $ 65.54
Hours of Work:35
Work Location:Civic Centre, hybrid
Organization Unit:CPS/IT Division
Department/Division/Section:CPS/Corporate Services Dept,CPS/IT Division, IT Division
Non-Union/Union: Non Union

We thank all who apply, however, only those candidates selected for an interview will be contacted. You can alsocheck 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 Equity, Diversity and Inclusion.

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 inform Human Resources of the nature of anyaccommodation(s) that you may require in respect of any materials or processes used to ensure your equal participation.