Executive Director of Data Warehousing

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.

Skillset

• Bachelor’s degree in Computer Science or related area required.
• 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.
• Possess and maintain a valid driver’s license or ability to provide own transportation.
• Travel to school district buildings and professional meetings.