Position Title: | Manager, Data Integration and Analytics | | | Supervisor: | Executive Director, Information Technology |
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.
|