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
Telus Telus Mobility is a Canadian wireless network operator and a division of Telus Communications which sells wireless services in...
Apply For This JobThis is a remote position where you can work from anywhere. Who We Are Looking For We are looking for...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Job details Location: London 15 Canada Square Capability: Consulting Experience Level: Junior Professional Type: Full...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Graduate Software Development Engineer Cisco is redefining the future of collaboration. We are creating a...
Apply For This JobJob Description Duties : Strong front end development experience Some back end experience Test driven development GCP w / DevOps...
Apply For This Jobbr{display:none;}.css-58vpdc ul > li{margin-left:0;}.css-58vpdc li{padding:0;}]]> Description: Your next role Are you looking for an opportunity to grow and enhance your...
Apply For This JobNotifications