City Of Calgary banner

Senior Data Strategist

City Of Calgary

The Role

Overview

Lead workforce analytics, data integration, and Power BI visualizations

Key Responsibilities

  • correlation analysis
  • data collection
  • data modeling
  • power bi
  • dashboard development
  • project management

Tasks

-Perform advanced correlation studies to understand trends and relationships within workforce data. -Support the development of a corporate-wide employee listening strategy to strengthen The City's ability to generate actionable employee insights over time. -Provide consultation and support in the assessment and implementation of technology solutions to sustain the employee listening program. -Design, implement and optimize data management processes and systems. -Leverage data collection methods, applications, and automation to collect, store and integrate complex workforce datasets, ensuring data is mined, cleansed, analyzed and reportable. -Develop and maintain dashboards, reports, and data visualizations using tools such as Power BI to support strategic initiatives. -Manage data collection; analyze and interpret complex datasets of workforce metrics. -Apply a project management approach to substantive pieces of work, ensuring work is delivered on time and meets customer expectations. -Champion best practices in Power BI dashboard design and data visualization to enhance workforce analytics and decision-making. -Develop conceptual, logical and physical data models, maintain data catalogs, and document data lineage.

Requirements

  • power bi
  • sql
  • python
  • data warehousing
  • data modeling
  • problem solving

What You Bring

-Experience with workforce-related analytics and insights is required. -A degree in Computer Science, Data Science, Software Engineering, Data Engineering or related area and at least 8 years of experience including experience in data warehousing, business intelligence, data modeling, data architecture and data integration. -Demonstrated experience leading data-driven projects and initiatives using a project management framework. -The ability to translate business strategies into actionable data solutions and drive business improvement. -Experience must include a combination of developing, implementing, and monitoring data architecture, data integration, master data management, data analysis, and continuous improvement of data. -Successful applicants must provide proof of qualifications. -Success in this position requires strong problem-solving skills, analytical thinking, attention to detail and exceptional communication skills to present data insights. -At least 2 years of experience creating complex DAX (Data Analysis Expressions) calculations and implementing advanced data modeling within Power BI. -Advanced proficiency in Power BI with at least 4 years of experience in data visualization and reporting, including the ability to design interactive dashboards and optimize performance for large, complex datasets. -Previous experience with employee listening campaigns will be considered an asset. -Experience with SQL, ETL, Python (or similar); Java Business Intelligence (BI) or Business Objects tools.

Benefits

Working Conditions: This position may be eligible to work from home as one of several flexible work options available to City employees. Such arrangements are based on the operational requirements of the position and employee suitability and are subject to change based on operational needs and corporate direction. If you are committed to public service, enjoy collaborating with others, share our values and have a desire to learn and grow, join The City of Calgary. City employees deliver the services, run the programs and operate the facilities which make a difference in our community. We support work-life balance, promote physical and psychological safety, and offer competitive wages, pensions, and benefits. Together we make Calgary a great place to make a living, a great place to make a life.

The Company

About City Of Calgary

-A municipal government role in urban planning, public safety, and economic development. -Commitment to high living standards through public services like transportation and utilities. -Projects including transportation systems, water treatment facilities, and urban development. -High-tech initiatives aimed at enhancing public services and citizen engagement. -Balancing infrastructure growth with environmental sustainability. -A proactive approach to long-term urban planning for a vibrant, future-ready city.

Sector Specialisms

Affordable Housing

Arts & Culture

Building Safety

Business Licensing

Bylaw Education

Community Standards

Audit and Investigations

Burial Services

Land-use Planning

Climate and Environmental Management

Sidewalks and Pathways

Community Services

Specialized Transportation

Stormwater Management

Marketing and Communications

Roads and Streets Maintenance

Driver and Vehicle Regulation

Urban Forestry

Wastewater Treatment

Procurement and Warehousing