Analytics Developer, IT Full-time Job

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
• A minimum of 3 years of experience with database design, data modeling techniques and ETL processes
• A minimum of 3 years of experience in gathering detailed business requirements
• A minimum of 3 years of experience in developing functional and analytics designs that leverages the latest features and capabilities in Power BI
• A 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