Business Transformation Consultant (Data Modeling)

Job ID: 53650

Job Category: Information & Technology

Division & Section: Technology Services, Technology Standardization Delivery

Work Location: Metro Hall, 55 John St, Toronto

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

Salary: $94,905.00 - $128,386.00

Shift Information: Monday to Friday, 35 hours per week

Affiliation: Non-Union

Number of Positions Open: 1

Posting Period: 29-Apr-2025 to 13-May-2025

Job Description:

Are you passionate about driving business transformation through effective data modeling?

Join us at an exciting time as we establish a foundation for how the City of Toronto designs and implements its Enterprise Data Platform. You’ll be a part of our Data Integration and Access team within the newly formed Enterprise Data and Artificial Intelligence unit of the Technology Services Division.

With a focus of supporting the delivery of data analytics projects through effective data modeling, in this role you will also be enhancing the capabilities of the City of Toronto’s Enterprise Data Platform. You will join a growing team that includes data engineers, cloud engineers, data science and visualization specialists, service designers, business transformation leads, and other data modelers who are all driving the modernization and vision for Toronto’s world class Enterprise Data Platform.

We are seeking a dynamic individual with a specialization in data modeling to join our team. In this role you’ll support our work defining and establishing data analytics projects for various teams across the City, with a primary focus on data the City creates and oversees as part of initiatives to support new housing. Through this work you will also be expanding the utility of the City’s data through the establishment of a data mesh within the Enterprise Data Platform. This comprehensive data view across analytics projects will empower the City to ask broader questions and enable insights through analysis across traditionally siloed data. Data modeling plays an essential role in achieving this vision.

Your responsibilities are not limited to but will include: analyzing data sources; reviewing business processes to discover useful data attributes and KPIs; creating master data models; defining conceptual, logical, and physical data models; reviewing, documenting, and establishing analytical data pipelines and analytics products; and developing guides and templates for effective data modeling practices.

In this emerging team you'll also have the opportunity to cross-train in the shared disciplines of other team members and expand your experience working in the cloud. We are currently establishing and templating the team's approach to deliver cloud data analytics tooling that will support various data analytics, data visualization, and dashboarding projects. You’ll be an active member cross-skilling in establishing end-to-end data analytics projects; so a strong desire and capability to learn (or enhance existing skills) in data ingestion using cloud tooling (like AWS Glue), establishing data pipelines, spinning up cloud infrastructure, and utilizing DevOps practices is highly valuable.   

Major Responsibilities:

• Develops & implements detailed plans and recommends policies/procedures regarding program specific requirements.
• Conducts research into assigned area ensuring that such research takes into account developments within the field, corporate policies and practices, legislation and initiatives by other levels of government.
• Provides input into and administers assigned budget, ensuring that expenditures are controlled and maintained within approved budget limitations.
• Prepares business cases, project charters, concept documentation, project plans and related materials that contribute to City initiatives and the effective use of Technology assets and services that will lead to service efficiencies and optimization of resources.
• Documents and analyzes business processes, business requirements, input costs and output levels and conducts workflow analysis and data modelling.
• Provides documentation, including but not limited to requirements definitions, master data models, conceptual data models, logical data models, physical data models, environmental scans, process models and technology roadmaps in support of all stages (Concept, Definition, Planning, Execution, and Closing) of a project or initiative.
• Conducts analyses to measure the effectiveness of technology solutions and service delivery methods and processes.
• Make recommendations to stakeholders on changes in methods and processes.
• Evaluates and makes recommendations on alternative methods of delivering technology solutions.
• Designs or modifies technology solutions for administering the delivery of service and tracking the cost and effectiveness of service delivery.
• Prepares reports to management supporting recommendations on changes in technology solutions, business methods and business processes including appropriate staffing levels and resource allocation.
• Documents or contributes to product visions, user cases, user case models and supplementary specifications including screen mock-ups, report mock-ups and business rules.
• Conducts studies on the feasibility of integrating technology and processes to deliver a range of support services.
• Identifies, analyzes, rationalizes and optimizes business processes, inputs and outputs at a detailed level in regards to data analytics initiatives by interviewing, documenting and facilitating process review/re-engineering sessions with stakeholders.
• Initiates and conducts, in coordination with divisional business representatives, research and analysis on opportunities to employ emerging technologies and/or process redesign to effectively deliver City services.
• Identifies potential technology business integration opportunities through knowledge of industry trends and related divisional technology projects.
• Document or contribute to service visions, use cases, use case models and supplementary specifications including screen mock-ups, report mock-ups and business rules.
• Organizes, participates and conducts proof-of-concept initiatives with client stakeholders that will assist in the determination of adopting new technologies and processes.
• Provides support, in collaboration with the client community and with key inputs from all Technology sections, to a central library of concepts that will streamline capital business case creation and contribute to the overall Technology Portfolio.
• Contributes and builds a Data Modeling Centre of Excellence through ongoing interaction and sharing of best practices and standards with Data Modelers, Data Engineers, and other staff across all divisions.
• Liaises and communicates with other members of Architecture and Portfolio Delivery and Technology service providers to ensure optimization of efforts and increased cross-collaboration.
• Contributes to the creation of unit work plans.
• Any other assignments as required by the Portfolio Manager.

Key Qualifications:

Your application for the role should describe your qualifications as they relate to:

1. Post-secondary education in Business, Information Science, Data Science, Computer Sciences, or in a discipline pertinent to the job function or an equivalent combination of education and/or experience.
2. Considerable experience developing and maintaining conceptual, logical, and physical data models to support various business needs and applications
3. Experience with Python programming language and libraries
4. Experience with a range of data formats (Including CSV, XLS, XML, JSON or GeoJSON) in a variety of contexts (web-services, databases and files) 
5. Experience analyzing and selecting data modeling tools that align with organizational needs (such as Erwin, Toad, IBM Data Architect, or equivalent)
6. Experience with public cloud platforms (e.g. AWS, Azure, GPC) and implementing, configuring and utilizing data analytics tools such as: Redshift (AWS), BigQuery (GCP), or Synapse Analytics (Azure); AWS Glue, Google Cloud Dataflow, Azure Data Factory; AWS Lambda, Google Cloud Functions, or Azure Functions; and Amazon QuickSights, Google Data Studio, or Microsoft Power BI.
7. Experience with DevOps practices, including continuous integration and continuous deployment (CI/CD) pipelines, infrastructure as code (IaC), and automated testing and monitoring, to ensure efficient and reliable data model deployment and maintenance.
8. Ability collaborating with stakeholders to understand data requirements and translate them into effective data models.
9. Ability to identify areas where effective conceptual, logical, and physical data modeling activities provide the greatest positive impact on the development of IT processes and systems and successfully working with stakeholders to implement them.
10. Possession of one or more industry-standard data modeling certifications such as Certified Data Management Professional (CDMP) would be an asset.
11. Ability to understand and implement relational and dimensional data modeling concepts
12. Knowledge with databases and data warehousing including organizing, compiling, manipulating, analyzing, and summarizing large datasets.
13. Excellent interpersonal and leadership skills with the ability to work cooperatively and professionally with City staff to gain an in-depth understanding of their individual business subject matter and translate their needs into actionable insights and products.
14. Excellent communication, presentation and interpersonal skills, to interact effectively with technical staff, business unit staff, and senior management; and communicate information in a manner that is understandable to a wide range of individuals.

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.