Data and Analytics Specialist (Temporary, Approx. 12 months)

at  The City of Guelph

Why Guelph:
When you join the City of Guelph, you join a team of over 2000 employees who deliver services the community relies on every day. Together, we are bringing to life Guelph’s vision of an inclusive, connected, and prosperous city where we look after each other and our environment. As a single tier municipality, we offer a variety of occupations and career specialities within our organization. Guided by the goals and objectives of the Future Guelph: Strategic Plan and committed to the Corporate Values of integrity, service, inclusion, wellness and learning, the candidate will aid in the achievement of the Community Vision for an inclusive, connected, prosperous city.

QUALIFICATIONS AND REQUIREMENTS

• Experience related to the duties listed above normally acquired through post-secondary education in computer science, computer programming or closely related field.
• Considerable experience in the design and construction of Data Integration Architectures, ETL/ELT pipelines, preferably with Informatica and Azure Data Technologies.
• Experience working with Data Governance working groups and committees.
• Extensive experience with Power BI and/or other data visualization and analytics tools.
• Progressive experience in the design and deployment of Metadata and Master Data systems for domains like Asset, Customer or Location Master.
• Knowledge of data integration architectures.
• Comprehensive Data Lake and Data Warehouse analysis and design experience, with SQL Server/Oracle databases, ESRI GeoDatabase and NoSQL Databases.
• Proficiency in using .NET technologies, JavaScript frameworks and libraries for data collection, visualization and interaction with SharePoint Online.
• Ability to analyze business and technical requirements for data lifecycle management and build full stack web applications.
• Ability to lead projects and team members under limited supervision.
• Superior organizational and project management skills.
• Experience working with different SDLC methods including Agile, Scrum, Kanban.
• Time management skills in a dynamic delivery environment.
• Candidates with an equivalent combination of education and experience may be considered.

• Work closely with clients and other resources to effectively communicate, design, plan, and implement capabilities that provide value to both internal and external customers.
• Design and build data architectures to leverage data as an organizational asset.
• Design comprehensive data solutions that enable clients to appropriately capture, make sense of and action data.
• Ensure delivered solutions fit within overall project plan and schedule.
• Provide feedback to departments and creates structured documentation, including specifications and weekly status reports.
• Advise departments on configuration and implementation options based on best practices.
• Participate in the business requirements gathering process for customizations.
• Lead/support Process Automation initiatives, for interfacing data structures.
• Act as a subject matter expert in data integration technologies.
• Ensure that all implementation methodology deliverables are complete and on time.
• Perform other tasks related to Data Governance, Master Data Management, Open Data and Database Administration, as required.
• Troubleshoot reporting, analytics and BI tools, systems and software and performance tune these applications, as necessary.
• Act as project manager for data projects including generating project status, time, and expense reports as requested by the management.
• Other relevant duties as required.