Overview

POSITION TITLE (Oracle title)

DIRECTOR

WORKING TITLE

Director-Business Intelligence and Analytics

SCHOOL/DEPARTMENT

Technology Services

LOCATION

Crossroads II, Cary, NC

PAY GRADE

Director Band 2

FLSA STATUS

Exempt

ELIGIBILITY FOR EMPLOYMENT CONTRACT

No

WORK WEEK SCHEDULE

Monday-Friday (occasional evenings and weekends) Position is available for a Hybrid Telework workweek. 

POSITION PURPOSE:

Leads, manages, and maintains enterprise-wide reporting solutions for Wake County Public School System (WCPSS). Focuses on strategic development and operations of Business Intelligence and Analytical practices, including staffing management, process optimization, and technology enhancement. Manages a high-availability reporting platform. Collaborates with business executives and stakeholders across departments to identify, recommend, develop, implement, and support analytic solutions that deliver essential information to meet their needs.

MINIMUM QUALIFICATIONS:  

KNOWLEDGE, SKILLS, AND ABILITIES (KSAs)

• Extensive knowledge of SQL and data manipulation languages;

• Comprehensive knowledge of technical data management systems, data warehousing methodology, data quality, data modeling, data governance, analytics, and predictive modeling;

• Comprehensive knowledge and understanding of the organization’s goals and objectives;

• Considerable knowledge of Microsoft Office, specifically Word, Excel, and PowerPoint; Google Apps;

• Considerable knowledge of human resource management principles, practices, and procedures;

• In-depth knowledge of current data management trends;

• Knowledge in BI/data warehousing planning and development;

• Ability to be self-motivated and self-directed;

• Ability to provide exceptional customer service orientation;

• Ability to build and manage virtual teams;

• Ability to present ideas in business-friendly and user-friendly language;

• Ability to effectively prioritize and execute tasks in a high-pressure environment;

• Ability to communicate clearly and concisely both in oral and written form using a variety of communication techniques and tools to ensure the appropriate flow of information, collaborative efforts, and feedback;

• Ability to establish and maintain effective working relationships with administrators, teachers, support staff, parents, and community members.

EDUCATION, TRAINING, AND EXPERIENCE

• Bachelor’s degree from an accredited college or university; AND

• Five years of experience in Business Intelligence and Analytics management or related field. 

• Proven experience in leading and managing BI and analytics teams, including experience in hiring, training, and mentoring staff;

• Experience in developing and implementing BI strategies, including data governance and data quality initiatives;

• Experience in working with senior leadership and cross-functional teams to drive data-driven decision-making;

• Proven track record of delivering actionable insights that have positively impacted business outcomes;

• Experience using project management tools to execute large-scale global projects, with a strong understanding of project management principles;

• Proven experience in developing business cases and departmental budgets;

• Extensive experience working in a team-oriented, collaborative environment.

An equivalent combination of relevant education, training, and experience which provides the knowledge, skills, and abilities necessary to successfully meet the essential duties may be considered.

CERTIFICATION AND LICENSE REQUIREMENTS

• Must hold and maintain a valid motor vehicle operator’s license according to the State of NC requirements.

PREFERRED QUALIFICATIONS:

• Experience with Oracle ERP, Cloud or hosted solutions, and experience working with Student Information Systems; 

• Proficiency in data warehousing, data modeling, and ETL processes;

• Advanced knowledge of BI tools and platforms such as Tableau, Power BI, QlikView, Looker, or similar;

• Strong skills in SQL and experience with databases such as MySQL, SQL Server, Oracle, or others;

• Familiarity with big data technologies like Hadoop, Spark, or similar platforms;

• Experience with programming languages commonly used in data analysis, such as Python, R, or SAS;

• Understanding of cloud platforms (e.g., AWS, Azure, Google Cloud, OCI or similar) and their analytics offering.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

WORK ENVIRONMENT/PHYSICAL REQUIREMENTS

This job operates in a professional office environment and has a noise level of mostly low to moderate. This role routinely uses standard office equipment such as computers, scanners, and copiers. The position, at times, must be able to come into direct contact with school system staff, external agencies, vendors, and contractors. Work is considered light physical work, requiring the exertion of up to ten pounds of force. The work requires driving automotive equipment.

EFFECTIVE DATE:  8/2024

DISCLAIMER:  The above statements are intended to describe the general purpose and responsibilities assigned to this position.  They are not intended to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and skills required by the employees assigned to this position.  This description may be revised by HR and approved at any time.