Manager, Data Integration and Analytics

Sooke School District 62

Position Title:                    Manager, Data Integration and Analytics

Affiliation:                          Excluded

Supervisor:                        Executive Director, Information Technology

Date of Revision:             December 12, 2022

Position Summary

Sooke School District is the fastest-growing School District in British Columbia.  Located in Langford, BC at the School Board Office, the Manager, Data Integration & Analytics will support the continuous improvement cycle and decision-making process by leading the delivery of key insights through the transformation of data into accessible information. This includes developing new insights and understanding of the District’s performance using operational data, statistical and quantitative analysis, and explanatory and predictive modeling.  This role works closely with leaders across the District to support and implement high-quality, data-driven decisions.  Ensuring data accuracy and consistent reporting by designing and creating optimal processes and procedures for users to follow.  Use advanced data modeling, predictive modeling, and analytical techniques to interpret key findings for the District’s data and leverage these insights into initiatives that will support the District’s outcomes. 

Duties and Responsibilities

• Oversees the design and delivery of insights analyzing data, operations, and performance metrics crossing across HR, Finance, IT, Student Data, and Executive functions
• Coordinates data quality, and submission of standard reports including 1701, class size organization, SADE, TRAX, FESL, inventory audit, survey data and analysis, 1701 PEN differences
• Enhances and optimizes internal Microsoft Power BI dashboards that support student success metrics, board reporting, district initiatives, Ministry reporting, and departments analytics projects
• Builds and maintains a data warehouse that integrates and maintains historical data and data feeds from internal data sources
• Establishes data governance and data quality process and discipline
• Assists the Chief Information Officer with the project management and reporting of Digital, Data, and IT Initiatives
• Leads cross-functional projects using advanced data modelling and analysis techniques to discover insights that will guide strategic decisions and uncover optimization opportunities
• Builds, develop and maintain data models, reporting systems, data automation systems, dashboards, and performance metrics that support key District decisions
• Trains, develops and supervises analyst-level employees
• Ensures the accuracy of data and deliverables with comprehensive policies and processes
• Manages and optimizes processes for data intake and validation
• Examines, interprets, and reports results of analytical initiatives
• Establishes and oversees the data/report requests process: tracking requests submitted, prioritization, and approval
• Develops and implements quality controls and standards to ensure quality, organizational expectations, and regulatory requirements
• Communicates results and impacts of insight initiatives to all relevant stakeholders
• Develops KPI / KRI and related dashboards
• Works with primary District partners to identify information needs and translates business requirements into user-friendly analytic models for reporting
• Leads and supports strategic change impacting strategic deliverables
• Oversees complex projects and drives them through to completion

Education and Experience

• A University Degree in a related discipline such as Information Technology, Computer Science, Mathematics, Statistics, or general Science and/or equivalent combination of education and specialized post-secondary training
• Minimum of four (4) years of recent and progressive leadership experience; preferably in a unionized and/or public sector environment
• Minimum of seven (7) years of experience working on all aspects of a managed project; design, implementation, and support
• Minimum of five (5) years of recently technical experience in a position:
  • monitoring, managing, manipulating, and drawing insights from data
  • reporting operational application design and development; and completing lifecycle data development projects
  • conducting predictive analytics, mapping, and collecting data from multiple data systems using analytical concepts and statistical techniques including hypothesis development, designing tests/experiments, analyzing data, drawing conclusions, and developing actionable recommendations

Technical Skills:

• Well-rounded and hands-on BI design and development skills, data integration, data modeling, and data analysis skills using BI tools such as Power BI, Tableau, or other Visualization and Reporting tools
• Strong programming skills with querying languages: Power Query, SQL, SAS, etc. to perform effective querying involving multiple tables and subqueries, extract, transform, and loading data
• Integration Tools – SSIS, SSRS, Web Services, SOAP, XML
• Experience with testing tools
• Experience with Baragar software, Excel, Word, and PowerPoint
• Experience working with and creating databases and dashboards using all relevant data to inform decisions. Also has p-to-date knowledge of data warehouse and database technologies that are applicable to activities in System and Database Development

Competencies

• Strives for Personal Excellence
• Practices a Growth Mindset
• Thinks Critically and Creatively
• Effectively Communicates and Collaborates
• Builds Relationships
• Fosters Interconnectedness
• Models Leadership
• Encourages Employee Growth
• Uses Systems Thinking Approach
• Provides a Strategic Direction
• Cultivates Community

To apply to this job posting, please visit Make a Future at http://bit.ly/3HtFtzX.