Senior Data Analytics Strategist

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 City is committed to fostering a respectful, inclusive and equitable workplace which is representative of the community we serve. We welcome those who have demonstrated a commitment to upholding the values of equity, diversity, inclusion, anti-racism and reconciliation. Applications are encouraged from members of groups that are historically disadvantaged and underrepresented. Accommodations are available during the hiring process, upon request.

The Senior Data Analytics Strategist position leads the translation of business strategies and requirements into specific data solutions, taking overall responsibility for all aspects of solution delivery, from inception through design and implementation. The role oversees and coordinates daily operations support activities including troubleshooting, maintaining, enhancing, and monitoring analytics and business intelligence solutions. Primary Duties include: 

• Build data pipelines to bring together information from different source systems and transforms them into a format that can be easily analyzed.
• Build data warehousing and data integration solutions and develop, maintain, and test infrastructures for data generation long with overseeing architecting solutions that integrate, consolidate, cleanse, and structure data for use in analytics and dashboard applications.
• Design, develop, document, and perform data quality checks across the data assets under the Data & Analytics domain and maintain data quality assurance throughout the data repositories to ensure the quality of data delivered to internal partners and the public from our various products.
• Work with clients to enhance delivered solutions through needs assessment , business requirements and adapting solutions to meet current business practices or requirements by liaising with other groups to provide data insights and the story behind them.
• Provide subject matter expertise to business units in implementing approved initiatives regarding dashboarding and reporting ensuring projects are delivered on time, within budget, adheres to high quality standards, and meets customer expectations.
• Document the data structures of all systems involved in data integration as the source, target, or staging. Include business and technical definitions (structure, format, size).
• Be part of the group as point of contact for data governance and planning around how the data is structured, collected, and used for the purposes of creating an overall better online experience across all City digital services.
• Support business areas and corporate functions in understanding and realizing the benefits of governing and managing their data with expanding the Corporate Data & Analytics strategy as a foundation for them.
• Support deployment and utilization of technology and data governance tools enhancing data maturity and compliance e.g. business data glossary, data catalog, master data management and data lineage.
• Assist in enhancement of the strategy and collaborative plan to address the data needs, how data can be used and collected, risks and opportunities identified enhancing overall experiences across digital services helping in identifying gaps in data.
• Proven effectiveness in achieving consensus across a broad array of partners; Ability to apply and coach the principles of data excellence, including development of problem statements and best practice action plans.

Qualifications 

• A degree in computer science, software engineering, data engineering or related. 
• At least 8 years of related professional experience including at least 4 years of applied experience in: 
  • Data warehousing, business intelligence, data modelling, data mining, data architecture, and data integration and databases, SQL, ETL, BI (Business Intelligence) tools, SAP Universe Design tool, Information Design Tool, Business Objects, or equivalencies; and business analysis, technology project management, product delivery, customer liaison, or business strategy. 
• Success in this position requires strong problem solving and analytical skills, excellent attention to detail and communication skills. 

Pre-employment Requirements 

• Successful applicants must provide proof of qualifications. 
• Applicants will be tested for appropriate skills. 

Workstyle: This position may be eligible to work from home for at least part of the time as one of several flexible work options available to City employees. These arrangements depend on the operational requirements of the role, employee suitability, and are subject to change based on operational needs and corporate direction.