Government of Saskatchewan Hiring for Senior Data/Report Analyst at Regina, SK Full Time

Employment Type: Permanent Full-time

Location(s): SK-Rgna-Regina

Ministry: 073 Corrections Policing and Public Safety

Salary Range: $42.519-$51.735 Hourly

Salary Supplement: included in hourly salary range (in-scope)

Grade: SGEU.11.

The Strategic System and Innovation Branch of Integrated Justice Services is looking for one Senior Reporting role. Working under the Manager of Business Intelligence and Data Analytics you will be responsible for data analytics, report generation, advanced querying techniques, providing data extractions and reporting solutions. In addition, you will also be responsible for gathering, communicating and documenting requirements with a broad spectrum of internal and external stakeholders. Other responsibilities will include trouble shooting and resolving incidents for various existing production reporting/data solutions and assisting with planning and technology changes or upgrades in a complex integrated environment.

The ideal candidate must offer the following skills:
Extensive experience in developing and building reports using IBM Cognos, Framework Manager and its components.

Extensive experience with dimensional/cube reporting development and relational reporting.

Extensive knowledge of relational and multi-dimensional data design and development techniques including star schema, snowflake schema, and Database Data Modeling.

Experience in performing advanced data analysis, data mining and integrating tools such as ETL, Slow Changing Dimensions (SCD), Fact and Cube development etc.

Experience utilizing multiple database tools, including Microsoft SQL Server, DB2 and Oracle.

Preferred experience with Cognos Administration, Architecture and scheduling.

You will have technical knowledge of database concepts, theories, and disparate data sources systems using various computer platforms and demonstrated proven experience on report creation and data extraction, preferably in IBM Cognos, SPSS, SQL, Data integration (ETL) tools.

Proven knowledge in all stages of the software development life cycle (especially Data Warehousing).

Justice domain experience will be considered an asset.

You must be able to develop Cognos reports and framework models that are flexible, scalable, and with best practices and adhere to standards. The successful candidates will possess exceptional written and verbal communication skills, self-starter and thrive in a dynamic, technology driven environment. Proven experience and skills in effective communication, problem solving, data analysis, documentation standards, a rigor for process and change management protocols, Software Development Life Cycle (SDLC), waterfall and Agile methodology, balancing multiple priorities simultaneously with the ability to adapt to the changing needs of the business while meeting deadlines and quality control are also required.

Typically, our ideal candidate would have gained the knowledge and skills required for this position through the completion of a degree in computer science, mathematics, or a related discipline, supplemented by several years of increasing responsibility and experience within a complex, integrated IT environment especially in Analytics, Data Warehousing and Reporting.

Candidates must demonstrate in their cover letter or resume how or where they have gained the knowledge and skills required for this position. Screening of applications will be based on information provided.

Individuals who applied to the previous competition of CON0002244-Senior Data/Report Analyst need not to re-apply.

We are committed to workplace diversity.

Hours of Work: A – SGEU Office 36 – one day off every two weeks

Number of Openings: 1

Closing Date: May 24, 2022, 12:59:00 AM