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 c