Business Intelligence Data Analyst

@ Calgary Police Service

About Calgary Police Service

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.

Role Overview: Business Intelligence Data Analyst

In this role, you will work with internal and external clients to implement business intelligence and data solutions. You will be responsible for gathering and evaluating user requirements, designing data management systems, performing data discovery analyses, and creating, testing, and supporting data-driven solutions.

Primary Duties

• Perform data discovery analyses, produce reports, and provide interpretations.
• Develop applications for data collection and querying.
• Gather, analyze, and interpret large volumes of raw data.
• Convert and transform data for dashboards and report consumption.
• Refine and automate data processes from centralized data warehouse.
• Collaborate with Data Engineers and IT teams to ensure data quality.
• Identify and remedy gaps in existing data models.
• Provide technical advice for data visualization and reporting.
• Implement improvements in data analytics and management.

Qualifications

A 2-year Diploma in Data Analytics, Software Development, or a related discipline is required along with less than 1 year experience in Data Analysis and BI product development. Must have experience with Power BI (PBI), DAX, and M-Code, as well as a strong working knowledge of Microsoft Power Apps, Power Automate, and Power BI Paginated Reports. Proficiency in Power BI Data Models, cloud and on-prem databases, and T-SQL is mandatory. Experience with Power BI Service Administration and Microsoft Fabric, and knowledge in Python, MS SharePoint, Machine Learning, Artificial Intelligence, ArcGIS, GIS services, or FME is preferred.

Competencies

Required competencies include coaching and development, communication, efficiency, planning and prioritizing, relationship building, self-confidence, and service orientation.

Pre-employment Requirements

An enhanced security clearance will be conducted. Successful applicants must provide proof of qualifications. International credentials must be assessed for equivalence.

Additional Information

Union: CUPE Local 38Business Unit: Calgary Police ServicePosition Type: 1 PermanentLocation: 5111 - 47 Street N.E., CalgaryCompensation: Pay Grade 9 at $40.18 - 53.76 per hourDays of Work: Typically 5 days per week with 1 day off every 3 weeksHours: Standard 35 hour work weekApply by: October 22, 2025Job ID #: 312683

Key skills/competency

• Data Analysis
• Business Intelligence
• Power BI
• DAX
• M-Code
• T-SQL
• Data Modeling
• Data Automation
• Reporting
• Data Quality