Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

Provide technical support and assist in data cleaning, manipulation, analysis, and visualization to deliver insights and contribute to evidence-informed decision-making and solutions.

Responsibilities

• Provide technical support and assist with performing data cleaning, manipulation, analysis, and visualization to support data migration, implementation, evidence-informed decision-making, and issue resolution.
• Contribute to the development of data models, dashboards, and databases.
• Set up data queries, build Extract, Transform, Load (ETL) processes, data preparation workflows, and reusable scripts to support data migration from legacy systems and manual spreadsheet-based sources into IBM Maximo and related enterprise applications.
• Provide technical expertise using data analysis, migration, transformation, mapping, validation, and reconciliation techniques to support data-driven implementation decision-making.
• Formulate data-related recommendations to support data migration, data quality improvement, implementation readiness, and issue resolution.
• Connect a variety of business data such as asset location, spatial facility condition, and business data, and analyze data to support migration readiness, implementation decisions, and operational insights.
• Ensure data quality, identify errors, and perform data cleanses, validate, standardize, and reconcile datasets, including identifying completeness, consistency, duplication, formatting, taxonomy, referential integrity, and other data quality issues.
• Build data visualizations, reports, and briefing materials to inform decision-making and contribute to implementation updates and briefing decks.
• Guide stakeholders in understanding data findings, validation results, dashboards, and reporting tools used to support decision-making.
• Produce data visualizations and reports using structured, spreadsheet-based, database, spatial, and geospatial data sources.
• Track and maintain KPIs, data quality indicators, migration progress measures, and business impacts related to a major technology and process transformation.
• Troubleshoot and take actions to resolve issues associated with data quality, data migration, interpretation, reporting, testing, and post-load validation.
• Communicate analysis results, data quality findings, assumptions, transformation decisions, defects, and implementation issues to internal and external stakeholders.
• Compile data, reconciliation, validation, and statistical reports based on data analysis, including formatting for clarity, structure, and decision-making.
• Maintain data, documentation, and records in accordance with information management, privacy, ethical analytics, and data governance best practices and guidelines.
• Develop, foster, and maintain effective working relationships with internal and external stakeholders.
• Build relationships with key business users and decision-makers to understand business requirements, confirm data definitions, validation rules, taxonomy decisions, and acceptable data quality thresholds.
• Support knowledge transfer to team members and stakeholders on data definitions, validation rules, data quality findings, dashboards, reports, and data processes.

Requirements

• Post-secondary education in Data Analytics/Science, Statistics, Geographic Information System/Geomatics, Computer Science, Mathematics, Building Systems/Science, Asset Management, Facilities Management, or an equivalent combination of education and relevant experience.
• Experience supporting data migration, conversion, or system implementation, including preparing, transforming, validating, reconciling, and documenting data from legacy systems or manual sources into enterprise applications.
• Experience with source-to-target data mapping, including field relationships, transformation rules, business rules, exceptions, and unresolved mapping issues.
• Experience profiling, cleansing, validating, standardizing, and reconciling complex datasets, including data quality issues related to completeness, consistency, duplication, formatting, taxonomy, and referential integrity.
• Experience using databases, query languages, scripting, or data preparation tools to extract, analyze, transform, automate, test, and validate data, including Structured Query Language (SQL), Oracle or similar databases, Python, Tableau Prep, or comparable tools.
• Familiarity with data dictionaries, data lineage, taxonomy, controlled vocabularies, business glossaries, or related metadata documentation.
• Familiarity with Geographic Information System (GIS) tools, spatial data, or location-based asset data.
• A willingness to learn about enterprise asset management, work management, facility management, and maintenance management systems.

Skills

• Data cleaning
• Data manipulation
• Data analysis
• Data visualization
• Data migration
• ETL processes
• Data modeling
• Dashboard development
• Database management
• SQL
• Oracle
• Python
• Tableau Prep
• GIS tools
• Spatial data analysis

Location

• Metro Hall, 55 John St, Toronto, ON M5V 0C4

Work Type

• Temporary
• Full-time

Experience Level

• 12 months experience

Education Level

• Post-secondary education in Data Analytics/Science, Statistics, Geographic Information System/Geomatics, Computer Science, Mathematics, Building Systems/Science, Asset Management, Facilities Management, or equivalent combination of education and relevant experience.

Salary/Compensations

• $44.64 - $48.88 per hour

About the Company

• The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve.
• 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.

Equal Opportunity

• 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.
• 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.