Jobillico

Se connecter

Ce recruteur est en ligne!

Voilà ta chance d'être vu en premier!

Postuler maintenant
City of Mississauga

Analytics Developer, IT

City of Mississauga

Mississauga, ON

  • Nombre de poste(s) à combler : 1

  • À discuter

  • Emploi Contrat

  • Date d'entrée en fonction : 1 poste à combler dès que possible

Postuler maintenant

Req ID: 25054
Vacancy Type: Temporary
Contract Duration: Up to 1 year
Number of Positions: 1
Closing Date: 05/09/2024

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

Hourly Rate/Salary: $47.72 - $ 63.63
Hours of Work: 35
Work Location: Civic Centre, Hybrid
Organization Unit: CPS/IT Analytics
Department/Division/Section: CPS/Corporate Services Dept , CPS/IT Division , Enterprise Business Solutions
Non-Union/Union: Non Union

A Criminal Record and Judicial Matters Check (Level 2) will be required of the successful candidate, at their own expense, to verify the absence of a criminal record for which a pardon has not been granted.

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

Exigences

Niveau d'études

non déterminé

Années d'expérience

non déterminé

Langues écrites

non déterminé

Langues parlées

non déterminé

No. référence interne

580375417

Postuler maintenant

Plus d'offres similaires à "Analytics Developer, IT"

Voir plus d'offres similaires

Chercher d'autres emplois

On crée le match parfait

Jobillico te propose instantanément les offres d’emploi qui te correspondent.

Importe ton CV

Plus d'offres

Voir plus >

Envoyer par courriel

Tous les champs sont obligatoires

(Utilisez le point-virgule pour séparer les adresses courriels.)