Chief Data Warehousing & BI Architect

Office of Technology; Charlotte (NC); On-site; USD 120,000 - 170,000; Full time

Job summary

Charlotte-Mecklenburg Schools is seeking an Executive Director of Data Warehousing to oversee the design, development, and implementation of data, BI platforms, both on premises and cloud-based, to support district initiatives under the Assistant Technology Officer.

This senior role requires a strong background in data architecture, governance, ETL, and leadership of programs and staff, with a minimum of ten years in data-related roles and a bachelor's in CS or related field; a master's is

Qualifications

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

Responsibilities

• 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

Skills

Data governance

BI reporting

SQL proficiency

Data modeling

Budget management

Team leadership

Data analytics

Communication to non-technical

Education

Bachelor’s degree in Computer Science or related area

Master’s degree preferred

Equivalent combination of experience and education

Tools

Power BI

Data warehousing tools

Job description

Charlotte-Mecklenburg Schools is seeking an Executive Director of Data Warehousing to oversee the design, development, and implementation of data, BI platforms, both on premises and cloud-based, to support district initiatives under the Assistant Technology Officer.

This senior role requires a strong background in data architecture, governance, ETL, and leadership of programs and staff, with a minimum of ten years in data-related roles and a bachelor's in CS or related field; a master's is