St. Clair Catholic District School Board
Officer-Data Analysis
đź“Ť
Wallaceburg, Ontario, Canada
🧪
Entry level
Hiring the Position of Officer-Data Analysis
Position: Officer-Data Analysis
Union/Association: Administrative Services Group (ASG)
Posting #: 3908717
Date Posted: November 1, 2024
Closing Date: November 8, 2024 4:00 p.m.
Employment Status: Permanent, Full-Time
Work Hours Schedule: 35 hours per week
Location: Catholic Education Centre, Wallaceburg
Annual Salary Range: $66,135.62 - $82,312.29
Start Date: Immediate
If Interested
Send resume quoting posting number (3908717) through Apply To Education - https://sccdsb.simplication.com/
Summary
The Data Analysis Officer will design, develop and maintain the organization’s Business Intelligence solutions. They will use data analytics platforms, reporting tools and visualization techniques to turn raw data into meaningful insights to support decision-making.
Responsibilities
Reporting to the Planning and Reporting Coordinator, the Data Analysis Officer will:
Develop, implement and optimize SQL queries, Power BI Reports and dashboards.
Create DAX measures and Power Query M scripts to support data analysis.
Apply data management best practices to maintain data integrity and provide solutions to stakeholders.
Review and interpret business reporting requirements.
Document and communicate technical issues, processes, and solutions.
Operate with CD/CI procedures; including high standards in process and code commenting to ensure all solutions developed can be easily maintained by future staff.
Qualifications And Skills
Post-secondary education in computer science, information technology, or related field.
4 years of related experience.
Experience using reporting and analytics frameworks, particularly Power BI.
Experience with database and SQL, particularly Microsoft SQL Server and T-SQL.
Experience with SSRS/Power BI Reporting Service, DAX and Power Query.
Advanced knowledge of Microsoft Office applications; Power Apps knowledge a plus.
Microsoft Certification in Power BI preferred.
Preferred experience with Laserfiche, Student Information Systems (Follett Aspen) and Jasper Reports.
Excellent interpersonal and communication skills.
Solid technical knowledge of data analysis, statistics and modeling.
Expertise in information visualization techniques and strategies.
Effective trainer of end users with developed solutions.
Familiarity with data warehousing concepts, data management best practices, data audit.
Ability to work independently and as a member of a cross functional team.
Strong analytical, organizational and problem-solving skills.
Continuous improvement and customer centric mindset.
Strong written, verbal and presentation skills.
Attention to detail and accuracy.
Accommodation
The St. Clair Catholic District School Board is an equal opportunity employer committed to inclusive, barrier-free recruitment and selection processes and work environment. We will accommodate the needs of the applicants under the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act (AODA) throughout all stages of the recruitment and selection process; see Accessibility Standards for Customer Service Policy (http://www.st-clair.net/policies.aspx).
Please advise the Human Resource Services Department to ensure your accessibility needs are accommodated throughout this process. Information received relating to accommodation measures will be addressed confidentially.
Thank You
We thank all applicants for their interest; however, only those selected for an interview will be contacted. The successful candidate will be required to provide a satisfactory Criminal Background Check as a condition of employment.
Director of Education Chair of the Board 420 Creek Street
Scott Johnson John Van Heck Wallaceburg, ON N8A 4C4
Telephone: 519-627-6762
Fax: 519-627-8230
Website: www.st-clair.net
Position: Officer-Data Analysis
Union/Association: Administrative Services Group (ASG)
Posting #: 3908717
Date Posted: November 1, 2024
Closing Date: November 8, 2024 4:00 p.m.
Employment Status: Permanent, Full-Time
Work Hours Schedule: 35 hours per week
Location: Catholic Education Centre, Wallaceburg
Annual Salary Range: $66,135.62 - $82,312.29
Start Date: Immediate
If Interested
Send resume quoting posting number (3908717) through Apply To Education - https://sccdsb.simplication.com/
Summary
The Data Analysis Officer will design, develop and maintain the organization’s Business Intelligence solutions. They will use data analytics platforms, reporting tools and visualization techniques to turn raw data into meaningful insights to support decision-making.
Responsibilities
Reporting to the Planning and Reporting Coordinator, the Data Analysis Officer will:
Develop, implement and optimize SQL queries, Power BI Reports and dashboards.
Create DAX measures and Power Query M scripts to support data analysis.
Apply data management best practices to maintain data integrity and provide solutions to stakeholders.
Review and interpret business reporting requirements.
Document and communicate technical issues, processes, and solutions.
Operate with CD/CI procedures; including high standards in process and code commenting to ensure all solutions developed can be easily maintained by future staff.
Qualifications And Skills
Post-secondary education in computer science, information technology, or related field.
4 years of related experience.
Experience using reporting and analytics frameworks, particularly Power BI.
Experience with database and SQL, particularly Microsoft SQL Server and T-SQL.
Experience with SSRS/Power BI Reporting Service, DAX and Power Query.
Advanced knowledge of Microsoft Office applications; Power Apps knowledge a plus.
Microsoft Certification in Power BI preferred.
Preferred experience with Laserfiche, Student Information Systems (Follett Aspen) and Jasper Reports.
Excellent interpersonal and communication skills.
Solid technical knowledge of data analysis, statistics and modeling.
Expertise in information visualization techniques and strategies.
Effective trainer of end users with developed solutions.
Familiarity with data warehousing concepts, data management best practices, data audit.
Ability to work independently and as a member of a cross functional team.
Strong analytical, organizational and problem-solving skills.
Continuous improvement and customer centric mindset.
Strong written, verbal and presentation skills.
Attention to detail and accuracy.
Accommodation
The St. Clair Catholic District School Board is an equal opportunity employer committed to inclusive, barrier-free recruitment and selection processes and work environment. We will accommodate the needs of the applicants under the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act (AODA) throughout all stages of the recruitment and selection process; see Accessibility Standards for Customer Service Policy (http://www.st-clair.net/policies.aspx).
Please advise the Human Resource Services Department to ensure your accessibility needs are accommodated throughout this process. Information received relating to accommodation measures will be addressed confidentially.
Thank You
We thank all applicants for their interest; however, only those selected for an interview will be contacted. The successful candidate will be required to provide a satisfactory Criminal Background Check as a condition of employment.
Director of Education Chair of the Board 420 Creek Street
Scott Johnson John Van Heck Wallaceburg, ON N8A 4C4
Telephone: 519-627-6762
Fax: 519-627-8230
Website: www.st-clair.net