Job Description

POSITION OVERVIEW:

THE DATABASE ADMINISTRATOR IS A KEY MEMBER OF THE KIPP DC INFORMATION TEAM THAT SUPPORTS THE DEVELOPMENT AND MAINTENANCE OF OUR DATA ARCHITECTURE AND DATA SOURCES. THIS WORK ENABLES THE ORGANIZATION TO PERFORM DATA ANALYSES AND PROVIDES QUALITY ASSURANCE TO STAKEHOLDERS WHO USE AND ACCESS OUR DATA. THIS ROLE IS ESSENTIAL IN BUILDING AND MAINTAINING SUSTAINABLE DATA PIPELINES THAT PROVIDE STAKEHOLDERS WITH TIMELY, ACCURATE DATA ACROSS THE ORGANIZATION. THE DATABASE ADMINISTRATOR IS AN EXEMPT POSITION AND REPORTS TO THE DIRECTOR OF DATA STRATEGY.

KEY RESPONSIBILITIES:

• In collaboration with stakeholders, determine what data needs to be included in our data warehouse (SQL server) and find the best ways to organize and store this information

  • Work with our systems and data engineers to troubleshoot ELT (extract, load, transform) scripts that process student data systems including PowerSchool, Deanslist, and Edulastic

  • Proactively monitor data for completeness and accuracy and communicate with impacted stakeholders when issues are identified

  • Build data quality tools that help with the early identification and quick resolution of data errors and inconsistencies

• MANAGE KIPP DC’S STUDENT DATA WAREHOUSE AND REPORTING PLATFORM

  • Develop, test, and maintain sustainable data architecture solutions to ensure data integrity standards are met

  • Maintain thorough documentation via KIPP DC’s data dictionary, which describes the contents, format, and structure of the data warehouse, Tableau data sources, and the relationship between its elements

  • Support Director of Data Strategy in long-term strategy efforts to expand the data domains held in the warehouse to other departments (i.e. Operations, HR, Finance, etc.)

  • Perform maintenance and support tasks on the reporting platform, Tableau Server

• WORK WITH DATA TEAM TO INCREASE CAPACITY FOR DATA ANALYSIS

  • Respond to requests from data team to resolve any issues related to integration failures or errors

  • Assist data analysts in developing SQL queries for reporting and analysis

  • Support in identifying, designing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Qualifications

REQUIREMENTS

• Bachelor’s degree in Information Science, Information Technology (incl. Applied Information Technology), Computer Science or a related field

• 1-3 years of relevant experience is required

• Demonstrated expertise in SQL query development is required

• Experience with data reporting and dashboarding tools such as Tableau

• Experience in database design and data architecture

• Experience with Python or one other scripting language (R, Javascript, etc.) is a plus

• Experience with the above in an educational context is a plus

OTHER SKILLS

• Ability to perform a variety of professional activities involved in the research, collection, organization, analysis, processing, interpretation, and reporting of academic and operational data

• Outstanding project management and organizational skills, and extraordinary attention to detail

• Works effectively with others to achieve shared goals through cooperation, sharing knowledge, joint problem-solving, and celebrating success

• Excellent communication and presentation skills in sharing recommendations with colleagues 

• Creative problem-solving skills and critical thinking

• Ability to continually develop and improve one’s skill and knowledge to perform effectively and adapt to change in the workplace and external landscape

• Familiarity with the K-12 education field in Washington, DC is a plus

• Unquestioned integrity and commitment to KIPP DC’s mission, including both racial and educational equity

• Supports building an organization that reflects the community that KIPP DC serves and holds self and others on team accountable for centering equity in all aspects of work

• Flexibility, tenacity, high quality work, resourcefulness, teamwork, and a sense of humor.

Additional Information

HOW TO APPLY: All interested applicants should visit online at http://www.kippdc.org/careers/apply-now/ and the job posting located under “Leadership and Support Staff” section.  If you have any questions, please contact the Recruitment Team via e-mail at careers@kippdc.org. 

EQUAL OPPORTUNITY EMPLOYER

KIPP DC Public Schools does not discriminate against, or tolerate discrimination against, employees or applicants for employment on any legally-recognized basis or protected class including, but not limited to, actual or perceived race, color, national origin, immigration status (except as necessary to comply with federal, DC, state, or local law), religion, sex (including pregnancy, childbirth, lactation and related medical conditions), age, physical or mental disability, medical condition, sexual orientation, gender (including gender identity or expression), marital status (including domestic partnership status), genetic information, political affiliation, pregnancy, family responsibilities, personal appearance, veteran status, uniform service member status, status of being unemployed, status of victim a survivor of domestic violence, sexual offense or stalking, matriculation or any other protected class under federal, state, DC, or local law. 

Click here or here to review KIPP DC’s non-discrimination policy and KIPP DC’s Title IX Coordinator’s contact information.

KIPP DC REQUIRES ALL STAFF TO PROVIDE PROOF OF FULL VACCINATION AGAINST COVID-19 OR OBTAIN AN APPROVAL FOR EXEMPTION DUE TO MEDICAL OR RELIGIOUS REASONS BY NOVEMBER 1, 2021 OR START OF EMPLOYMENT, WHICHEVER IS LATER.