Executive Director of Data Warehousing

Esd113; Charlotte (NC); On-site; USD 110,000 - 170,000; Full time

Job summary

Charlotte-Mecklenburg Schools seeks an Executive Director of Data Warehousing to oversee design, development, and implementation of on-premise and cloud BI platforms and data architectures. The role requires senior leadership, extensive decision-making, and collaboration with the Assistant Technology Officer of Data Warehouses.

The position emphasizes data governance, advanced analytics, and scalable data structures for district-wide initiatives, with a focus on cloud migrations and enterprise

Qualifications

• Strong knowledge of data warehousing and BI concepts.
• Experience leading data architecture and analytics initiatives.
• Ability to communicate complex data concepts to non-technical audiences.

Responsibilities

• Adhere to all laws, policies, and procedures in district technology.
• Lead, supervise, and evaluate data programs and staff.
• Collaborate on strategic plans with Superintendent and Board.
• Evaluate BI and data warehousing systems and migrate to cloud-based solutions.
• Perform advanced data analysis, architecture, and reporting.
• Design data structures for data warehouses and marts.
• Lead data governance, master data management, and quality techniques.
• Develop new or improved data warehouse ecosystems and reporting systems.
• Manage data warehouse, data models, and source code.
• Design ETL/ELT dataflows and support data access for stakeholders.

Skills

SQL proficiency

Power BI proficiency

Data governance

Data modeling

BI and data warehousing theory

Education

Bachelor's degree in Computer Science or related area

Master's degree in Computer Science or related area preferred

Minimum of ten (10) years' experience in data architecture preferred

Tools

Power BI

SQL

Job description

The Executive Director of Data Warehousing, under minimal supervision, performs senior-level work with extensive decision-making discretion overseeing the design, development, and implementation of on premise and cloud-based data, architectural structures, data analytics, and Business Intelligence (BI) platforms, and integration with external data sources to support various district initiatives that align with system-wide strategic goals. Employee performs advanced and supervisory work to carry out Board of Education policies and procedures related to business requirements and IT Solutions under the direction of the Assistant Technology Officer of Data Warehouses.

Qualifications

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Pay Grade 11/Non-Certified Staff Market Structure/Full-time, 12 months

Reports To

Assistant Technology Officer of Data Warehouses

Place of Work

The normal place of work is on the premises used by Charlotte-Mecklenburg Schools. Charlotte- Mecklenburg Schools reserves the right to require you to work at such other place(s) as it may reasonably require from time to time.

Essential Functions

• Adhere to all state, federal, and local laws, policies, and procedures
• Lead, manage, supervise, and evaluate assigned programs/staff in the district
• Collaborate in the development of strategic plans to meet the objectives set forth by the Superintendent and the Board of Education
• Evaluate and support existing BI and data warehousing systems and assist in leading efforts in the development and implementation of future migrations to cloud-based databases and BI solutions
• Perform highly complex data analysis, data architecture, and data reporting tasks
• Determine database and reporting requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems
• Perform architectural guidance, technical recommendations and implementation strategies that support the development of data and information products and analytics systems using programming languages and tools
• Collaborate to develop and establish standards for data quality, data modeling, database object creation and maintenance, and data reporting, distribution, and presentation
• Develop and implement data structures for data warehouses and data mart projects; and support current and future data analytics and business intelligence systems
• Lead efforts in data management, data quality techniques, data governance, master data management, and design methods
• Lead the development of new, or improvement of, existing data warehouse ecosystems and data related reporting systems
• Manage data warehouse, data models, and source code
• Design, develop, and implement dataflows and ETL/ELT solutions to consume data from various internal and external sources
• Provide support in accessing and querying data via the data warehouse and analyzing and reporting on data to support customer requests or project requirements
• Monitor and participate in the development and administration of the department budget
• Complete local, state, or federal surveys and reports accurately and promptly
• Participate in professional development workshops and leadership training
• Create an inclusive environment with positive communication/public relations
• Facilitate the development of the department's improvement plan
• Perform related work as assigned or required

Knowledge, Skills, Abilities

• Comprehensive in-depth knowledge and understanding of the principles, practices, and procedures of public school system technology requirements
• Knowledge of quantitative research methodology, statistics, data analysis, and business intelligence reporting
• Knowledge of business intelligence and data warehousing theory and concepts
• Strong skills and experience in data-related roles, including analytics, data governance, and communicating about data to non-technical audiences
• Skilled in software used in querying, analyzing, and reporting on enterprise data (SQL proficiency required)
• Skilled in business intelligence tools, from connecting to source data through deploying reports (Power BI proficiency required)
• Skilled in working with large data sets from a variety of data systems
• Ability to construct database management systems (DBMS) Specific Models or Physical Data Models working with the development team and database administrators (DBAs)
• Ability to build the validated, agreed to, and approved data structures
• Ability to identify opportunities for development and implementation of new products
• Ability to maintain professional and emotional control under stress
• Ability to reflect appropriate response to situations, while maintaining a professional and personal demeanor
• Ability to learn and use specialized tools, equipment or software related to business needs
• Ability to develop, monitor, and implement a fiscally sound budget
• Ability to direct and evaluate the work of others
• Ability to implement local, state, and federal rules, guidelines, and procedures into daily business operations
• Ability to communicate effectively
• Ability to reason, make judgments, and maintain effective working relationships
• Ability to employ positive communication skills in all settings/mediums
• Ability to problem-solve utilizing sound judgment
• Ability to maintain confidentiality regarding school system business
• Ability to develop related charts, graphs, reports, and records pertaining to school planning and strategy
• Ability to take initiative, work independently, and exercise sound judgement
• Ability to conceptualize, initiate, monitor, and evaluate new and/or current programs
• Demonstrated ability to perform detailed work, planning, risk assessments, and associated risk mitigation actions
• Demonstrated ability to work effectively in a deadline-driven, rapidly changing team environment

Education and Experience

• Bachelor's degree in Computer Science or related area required
• Master's degree in Computer Science or related area preferred
• Minimum of ten (10) years' experience in data architecture preferred
• Equivalent combination of experience and education

Special Requirements

• Possess and maintain a valid driver's license or ability to provide own transportation
• Travel to school district buildings and professional meetings

Physical Requirements/Working Conditions

• Work requires the occasional exertion of up to ten pounds of force
• Work regularly requires the exchange of accurate and detailed information through oral and written communication
• Constantly operates a computer and other office business equipment
• Ability to remain in stationary position for required meetings/work
• Ability to move to other work locations
• Visual acuity requires preparing and analyzing written or computer data, determining the accuracy and thoroughness of work, and observing general surroundings and activities
• Hearing is required to perceive information at normal spoken word levels, and to receive detailed information through oral communications
• Work requires preparing and analyzing written or computer data, operating standard office equipment, and use of advanced technology
• Work occasionally requires exposure to outdoor weather conditions
• Work is generally in a moderately noisy location (e.g., business office, light traffic)
• Requires the ability to deal with people beyond giving and receiving instructions
• Must be adaptable to performing under mild to high levels of stress

In compliance with Federal Law, Charlotte - Mecklenburg Schools administers all education programs, employment activities and admissions without discrimination against any person on the basis of gender, race, color, religion, national origin, age or disability.