Director of Data Warehousing Position Available In Mecklenburg, North Carolina

Director of Data Warehousing
Office of Technology
P.O. Box 30035
Charlotte , NC 28230
Non Instructional/Support Services – Position – Other
Job Number 4600312457
Start Date Open Date 06/12/2025
Closing Date 06/20/2025 General Definition of Work The Director of Data Warehousing, under minimal supervision, performs senior level work with considerable decision-making discretion supporting the design, development, and implementation of on premise and cloud-based data, architectural structures, data analytics, and Business Intelligence (BI) platforms. This position is responsible for requirement gathering, analysis, and ETL development for integrating external data sources to support district initiatives aligned with system-wide strategic goals. Employee performs advanced work to carry out Board of Education policies and procedures 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. Salary/Status Pay Grade 10/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
Evaluate and support existing BI and data warehousing systems and assist in the development and implementation of future migrations to cloud-based databases and BI solutions
Perform complex data analysis, data architecture, and data reporting tasks
Determine database and reporting requirements by analyzing business operations, applications, and programming; review business objectives and evaluate current systems
Collaborate to develop 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
Support efforts in data management, data quality techniques, data governance, master data management, and design methods
Support 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
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
Perform related work as assigned or required Knowledge, Skills, Abilities Thorough 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
Skilled in data 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 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 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 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
Minimum of five (5) years’ related experience required
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
# of Jobs 1.00

Salary:

From 76669.00
Teacher Scale N
Minimum Educational Requirements Bachelors
Term 12 Month
Additional Job Information 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 Job Attachment View Attachment 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.