Data Steward Advisor

Jobtailor

Ottawa

On-site

CAD 90,000 - 130,000

Full time

4 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Jobtailor in Ottawa is seeking a senior Data Architect/Reporting lead to manage the full data lifecycle: collection, validation, cleaning, storage, governance, and presentation. You will develop standards, processes, and tools to support program analysis and reporting.

You will design Power BI dashboards, integrate reporting into GMF and FCM portals, advise teams on data methods, coordinate external consultants, and ensure privacy and compliance.

Qualifications

Post-secondary education in a related field such as public or business administration, economics, data science, or project management
Advanced data manipulation and visualization skills using Microsoft Excel and Power BI
Experience with MS Office, including PowerPoint
Experience with customer-relationship management software and database management
Experience conducting data collection for urban forestry initiatives
Experience implementing urban forestry tools, including the i-Tree suite
Experience launching programs and establishing new data collection systems
Proven experience as a Data Architect, Reporting Architect, or similar role
Strong understanding of data modeling, data integration, data warehousing, machine learning, and reporting concepts
Familiarity with AWS, Azure, or Google Cloud
Familiarity with Spark or other distributed computing frameworks
Proficiency with SQL, Python, TextBlob, scikit-learn, and DAX
Experience with storytelling and visualization using Excel, Power BI, Microsoft CRM, and other tools
Strong attention to detail and accuracy
Excellent research and project coordination skills
Strong verbal and written communication skills and experience documenting processes
Exceptional organization, initiative, judgment, adaptability, and ability to manage multiple tasks and deadlines
Must live within 80 km of downtown Ottawa, unless otherwise specified
Must be authorized to work in Canada

Responsibilities

Lead and manage the full data lifecycle across collection, validation, cleaning, documentation, storage, analysis, governance, and presentation
Establish and document standards for project data, definitions, sources, usage, and supporting documentation
Develop and manage data collection processes, databases, standardized SOPs, and analysis tools
Lead automated reporting initiatives in collaboration with Information Systems
Design and develop Power BI dashboards and visual representations of program results
Integrate GCCC reporting into existing GMF systems and dashboards and import data collection tools into the FCM portal
Conduct quantitative and qualitative analysis of program data and funded initiatives
Lead data architecture, data integration, data flow, data integrity, and results presentation
Identify and implement data-management best practices and continuous-improvement processes
Advise coordinators, managers, and teams on data collection, management, visualization, and reporting methodologies
Coordinate external consultants, including terms of reference, deliverable oversight, and quality assurance
Ensure compliance with reporting schedules, contribution agreements, data privacy obligations, and data-sharing agreements
Provide high-level advice and support to the Manager, Impact and Performance

Skills

Data lifecycle management

Power BI

SQL

Python

DAX

Data modeling

Data integration

Data warehousing

Machine learning

TextBlob

Scikit-learn

Excel

Microsoft CRM

Cloud platforms

i-Tree Suite

Distributed computing

Education

Post-secondary education in related field (public/business administration, economics, data science, or project management)

Tools

Power BI

Excel

Microsoft CRM

AWS

Azure

Google Cloud

i-Tree Suite

MS Office

Spark

Distributed computing frameworks

Data collection tools

Job description

Lead and manage the full GCCC data lifecycle, including collection, validation, cleaning, documentation, storage, analysis, governance, and presentation
Establish and document standards for project data, definitions, sources, usage, and supporting documentation
Develop and manage data collection processes, databases, standardized SOPs, and analysis tools
Lead automated reporting initiatives in collaboration with Information Systems
Design and develop Power BI dashboards and visual representations of program results
Integrate GCCC reporting into existing GMF systems and dashboards and import data collection tools into the FCM portal
Conduct quantitative and qualitative analysis of program data and funded initiatives
Lead data architecture, data integration, data flow, data integrity, and results presentation
Identify and implement data-management best practices and continuous-improvement processes
Advise coordinators, managers, and teams on data collection, management, visualization, and reporting methodologies
Coordinate external consultants, including terms of reference, deliverable oversight, and quality assurance
Ensure compliance with reporting schedules, contribution agreements, data privacy obligations, and data-sharing agreements
Provide high-level advice and support to the Manager, Impact and Performance

Requirements

Post-secondary education in a related field such as public or business administration, economics, data science, or project management
Strong knowledge of business support processes and tools
Advanced data manipulation and visualization skills using Microsoft Excel and Power BI
Experience with MS Office, including Microsoft PowerPoint
Experience with customer-relationship management software and database management
Experience conducting data collection for urban forestry initiatives
Experience implementing urban forestry tools, including the i-Tree suite
Experience launching programs and establishing new data collection systems
Proven experience as a Data Architect, Reporting Architect, or similar role
Strong understanding of data modeling, data integration, data warehousing, machine learning, and reporting concepts
Familiarity with AWS, Azure, or Google Cloud
Familiarity with Spark or other distributed computing frameworks
Proficiency with SQL, Python, TextBlob, scikit-learn, and DAX
Experience with storytelling and visualization using Excel, Power BI, Microsoft CRM, and other tools
Strong attention to detail and accuracy
Excellent research and project coordination skills
Strong verbal and written communication skills and experience documenting processes
Exceptional organization, initiative, judgment, adaptability, and ability to manage multiple tasks and deadlines
Must live within 80 km of downtown Ottawa, unless otherwise specified
Must be authorized to work in Canada

Core Competencies

Demonstrates expertise in data lifecycle management, including data collection, validation, analysis, and visualization using tools like Power BI and Excel. Proficient in data architecture, integration, and compliance with data privacy obligations while providing strategic insights and support to management.

Highest-signal resume keywords