Data Engineer

Niagara Region

Niagara Region is committed to enhancing the prosperity of a diverse urban and rural population of over 475,000. Collaborating with municipalities and community partners, they provide a range of services that enrich the well-being of its residents and visitors. Situated between Lakes Erie and Ontario, the area is renowned for its fertile landscapes, cultural richness, and recreational opportunities, making it a hub for tourism and relocation. Niagara Region values diversity and strives for an inclusive workforce that mirrors its community.

In this role you can expect to have the responsibilities:

• Provide expertise in data cleansing, mining, and storage.
• Serve as a technical consultant for stakeholders.
• Support application, reporting, and analytics projects with data architecture.
• Ensure compliance with privacy laws in data solutions.
• Develop and maintain data models and data integration solutions.
• Facilitate data transformation and workload management processes.

This role comes with the following benefits:

• Diverse, inclusive work environment
• Opportunities for personal and professional growth

This role requires you to have:

• Enterprise data architecture experience
• Strong data modeling skills
• Proficiency with Microsoft SQL Server, SSIS, SSAS, SSRS
• T-SQL query development and optimization
• Experience with ETL processes
• Script development using Python, PowerShell, VB, C#

You would benefit from having:

• Familiarity with Azure platform
• Experience in municipal organizations
• Understanding of privacy and access laws

The role emphasizes diversity and seeks applicants from varied backgrounds. Compliance with collective agreements is noted for unionized roles. Travel requirements and criminal record checks are necessary.