Data Specialist 1

Job ID: 55371

Job Category: Engineering & Technical

Division & Section: Parks, Forestry & Recreation, PFR Bus & Technology Transformation

Work Location: Metro Hall, 55 John Street (Hybrid)

Job Type & Duration: Temporary, Full-Time, 12 month vacancy

Salary: $93,734.00 - $123,449.00

Shift Information: Monday to Friday, 35 hours per week

Affiliation: Non-Union

Qualified List will be established to fill permanent and temporary positions.

Number of Positions Open: 1

Posting Period: 04-Apr-2024 to 22-Apr-2024

Job Summary

Reporting to the Program Manager, Capital Projects Parks & Recreation, this position will help to guide policies/procedures regarding program-specific requirements, with a heavy focus on asset data as PF&R transitions to a new asset management system. The successful candidates will help to consolidate data sets, improve data quality, enhance data analysis, optimize business processes and guide innovative and strategic planning. They will bring creative and innovative approaches and techniques to large-scale divisional datasets, making recommendations and implementing improvements to the system, supporting data pipelines, ETLs/ELTs, and statistical and inferential analysis. Through collaboration with corporate partners, you will ensure high performance of large amounts of ETL as well as ELT tasks, report building, analytics, and data visualization support. The role will give PF&R the ability to harness the power of data for strategic decision-making, operational efficiency, and improved service value. 

Major Responsibilities:

Data Management & Technical Responsibilities

• Leads tasks related to modeling, analysis, and interpretation of datasets.
• Designs and builds complex models for analytics problems.
• Conducts peer and literature reviews on data modeling techniques.
• Develops processes for ingesting, transforming, and analyzing large datasets.
• Prepares, cleans, and standardizes data to ensure it meets data quality and formatting requirements; manages data accuracy, eliminates duplication, and ensures consistency.
• Implements ETL/ELT processes for data integration.
• Documents data processes, models, and code, including creating detailed run-books or as-built documents.
• Transforms and cleanses data for compatibility with Maximo's data structure.
• Develops and maintains asset hierarchy and data models to support asset lifecycle management.
• Creates and implements data migration plans and establishes data quality rules to ensure data integrity during transitions; performs data validation and testing to ensure accuracy and reliability of data.
• Leads data accuracy validation before and after migration, confirming the transfer of data is successful; works with stakeholders to verify data relevance and accuracy based on asset management requirements.

Data Governance & Compliance

• Establishes and maintains data governance policies and standards to ensure compliance with organizational and regulatory requirements; oversees data governance policies and compliance documentation.
• Ensures data handling meets regulatory standards, business standards, and project requirements.
• Manages data access permissions and roles, ensuring data security and confidentiality.
• Ensures compliance with data retention policies and procedures.
• Addresses data discrepancies and inconsistencies by working closely with data owners and stakeholders.

Project Management & Change Management Skills

• Develops and evaluates work plans for data projects.
• Ensures conformance to data governance standards.
• Implements Enterprise Asset Management system with project teams and stakeholders.
• Monitors and evaluates application functionality.

Stakeholder Engagement & Communication

• Collects and analyzes data with internal and external partners.
• Prepares reports, dashboards, and submissions; sets up reports, dashboards, and analytics tools to support the business with asset management insights.
• Provides training and support to staff on data usage.
• Maintains effective working relationships and networks.

Data Tools & Technologies

• Utilizes data management and analytics tools (e.g., SQL, PowerBI, Tableau, Python).
• Configures data-related features in software.
• Evaluates new data management tools and technologies.

Key Qualifications:
 

1. Post-secondary education in Civil Engineering, Computer Science, Mathematics, or a related quantitative field, or an equivalent combination of education and experience.
2. Extensive experience in data management principles and practices, including data governance, data quality assurance, data integration, and data analysis.
3. Proficiency with data management tools and technologies, including analytics and visualization tools (SQL, Python, Power BI, Tableau). Familiarity with ETL/ELT processes for data integration.
4. Experience in developing and maintaining asset hierarchy and data models to support asset lifecycle management.
5. Experience in creating and implementing data migration plans and establishing data quality rules to ensure data integrity during transitions.
6. Experience in performing data validation and testing to ensure accuracy and reliability of data.
7. Experience in documenting data processes, models, and code, including creating detailed run-books or as-built documents.
8. Experience developing data governance frameworks to ensure compliance with organizational and regulatory requirements.
9. Experience designing, developing, and implementing taxonomies, metadata structures, and/or data dictionaries.
10. Strong analytical skills with the ability to assess complex data requirements and develop solutions, troubleshooting and resolving issues related to Enterprise Asset Management systems data and functionality.
11. Highly developed written and oral communication skills, including writing reports, briefing notes, and delivering presentations.
12. Knowledge of data privacy regulations and compliance for data management, data retention, and data access permissions.
13. Familiarity with current and emerging technologies in data management and analytics.
14. Ability to travel to various locations within the City of Toronto, including parks and parks yards, as required.
15. Knowledge of Toronto Public Service values and ability to support an ethical, supportive, and respectful workplace culture that champions equity, diversity, and inclusion.
16. Must be familiar with safety and security matters under Occupational Health & Safety legislation and Divisional safety and security policies.

Equity, Diversity and Inclusion

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity.

Accommodation

The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request. Learn more about the City’s Hiring Policies and Accommodation Process.