Calgary Police Service

6 months ago

Calgary, Canada City of Calgary Full time

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.
- As a Business Intelligence Data Analyst, you will work with internal and external clients to implement business intelligence and data solutions. You will be responsible for gathering and evaluating users' requirements; designing and guiding others on data management; data and information modeling; creating, testing, quality assurance, implementing, and supporting data driven solutions. Primary duties include:

- Perform data discovery analyses, produce reports, and provide written and verbal interpretations of data.
- Gather, analyze, and interpret large volumes of raw data from various sources to identify trends, patterns, and insights.
- Convert and transform data within operational data and store into consumable formats for dashboards and reports consumption.
- Refine and automate data processes, data-flows or datasets to ensure information is collected and made available from the centralize data warehouse to the end user accurately, on-time and with mínimal manual intervention.
- Work closely with Data Engineer and other Information Technology teams to ensure data quality, integrity, and accuracy are applied in the centralize data warehouse.
- Identify opportunities, deficiencies, or gaps in data models within the organization and take ownership for the solutions.
- Provide expertise, technical advice, and guidance for clients to define data visualization, reporting, or investigation artifacts. Review feedback with client and provide best practice. Ensure that products meet client needs.
- Identify and implement improvements of data analytics and data management.

**Qualifications**
- A 2-year Diploma in Data Analytics, Software Development, or a related discipline, plus less than 1 year of experience. Recent graduates are encouraged to apply.
- Database languages such as T-SQL or PL/SQL is mandatory.
- Experience in MS Power BI or similar, MS PowerApps and Automate, MS SharePoint are mandatory.
- Working knowledge in DAX, Relational Databases, NoSQL, MS SSIS, MS SSAS, PowerShell, Azure experiences, MS Fabric, M code with modern data manipulation/management patterns such as cloud and on-prem databases, data lake are considered strong assets.
- Scripting languages such as Python, experience with data modeling and advanced features in MS Excel are considered strong assets.
- You must have the following competencies: Coaching and development, communication, efficiency and thoroughness, planning and prioritizing/visionary; relationship building, self-confidence, service orientation.

**Pre-employment Requirements**
- An enhanced security clearance will be conducted.
- Successful applicants must provide proof of qualifications. Education obtained from out of country must have or be able to obtain, an Education Credential Assessment (ECA) for confirmation of equivalent credentials.
- Union: CUPE Local 38
- Business Unit: Calgary Police Service
- Position Type: 1 Permanent
- Location: 5111 - 47 Street N.E.
- Compensation: Pay Grade 09 $37.79 - $50.55 per hour
- Days of Work: This position works a 5 day
work week with 1 day off in a 3 week cycle.
- Hours of work: Standard 35 hour work week
- Audience: Internal/External
- Job ID #: 309672

  • Calgary Police Service

    3 weeks ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    1 month ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    6 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    2 weeks ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    3 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    3 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    6 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    2 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    7 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Police School Facilitator

    6 months ago

    Calgary, Canada YouthLink Calgary: Police Interpretive Centre Full time

    **Title**: YouthLink Police School Facilitator **Position Profile**: Reporting to the YouthLink Calgary Police Service Lead, the Police School Facilitator will be responsible for the delivery of our four-day, grade six Police School program, along side the YouthLink officers. On weeks where Police School programs are not scheduled, they will be responsible...

  • Calgary Police Service

    1 month ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    7 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    6 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    6 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    1 month ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    3 weeks ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    3 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    2 weeks ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    2 months ago

    Calgary, Canada City of Calgary Full time

    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...

  • Calgary Police Service

    6 months ago

    Calgary, Canada City of Calgary Full time

    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...