Job Title
Analytics Engineer
School/Organization
KIPP Baltimore Schools
School Level
K-8
Location (County)
Baltimore City
Employment Type
Full-Time
Job Description
The Analytics Engineer will oversee KIPP Baltimore’s analytics infrastructure, building upon the established foundation for automated integration of data systems and effective reporting and analysis of academic and school performance data for KIPP Baltimore schools and its KIPP Forward program. The person in this role will bring a mix of data analysis, data engineering, and visualization skills to ensure school and regional teams have access to the right data at the right time to identify trends, improve practices, and inform critical decision-making. The Analytics Engineer will report to the Executive Director on an interim basis as we look to fill out our data team.
How to apply
TO APPLY: Please submit an online application at our website at http://www.kippbaltimore.org/content/apply/.
Compensation and benefits are competitive and commensurate with qualifications and experience.
Essential DuTies & Responsibilities
KEY RESPONSIBILITIES:
Analytics Engineer responsibilities include, but are not limited to:
Data Management (50%)
Manage and maintain KIPP Baltimore’s cloud-based database instance using Amazon Relational Database Service (Amazon RDS)
Design and develop database objects, tables, views, stored procedures, functions, and triggers to support analytics and operational needs; ensure their stability, reliability, and performance
Create and manage data pipelines that integrate information from multiple sources using APIs, ETL processes, and other methods; ensure their stability, reliability, and performance through ongoing monitoring and failure detection
Collaborate with internal IT staff and external vendors to ensure alignment of KIPP Baltimore’s technology and data infrastructure
Collaborate with internal IT staff and external vendors to ensure KIPP Baltimore complies with all state and federal data privacy and security laws; execute on data privacy and security protocols as they relate to system integration and data access
Develop and update documentation on data collection, integration, storage, and reporting systems and processes (e.g., data catalogs, dictionaries, systems maps, etc)
Data Analysis & Reporting (30%)
Design and implement interactive reporting dashboards and tools to support strategic decisions at the regional and school levels
Lead iterative design processes to gather stakeholder feedback and user needs for new and existing analytics products
Leverage KIPP Baltimore’s internal data website to ensure ease of access to analytics products and resources
Collaborate with teammates to provide training and coaching on analytics tool use
Support Director of Data and Assessment with external reporting to regulatory agencies, the KIPP Foundation, and KIPP Baltimore funders and donor network.
Data Strategy (20%)
Develop deep knowledge of KIPP Baltimore’s existing data and technology stack and identify opportunities for improvement
Create a long-term strategy and vision for KIPP Baltimore’s data warehouse and infrastructure within the Amazon Web Services (AWS) ecosystem, with an immediate focus on:
Consolidating, archiving, and purging existing data warehouse tables
Improving performance of existing queries and stored procedures
Streamlining recurring database jobs and coordinating automations within and downstream from the database (e.g., tables, views, Tableau data source extracts)
Develop and execute against a data systems and analytics product roadmap that aligns with organizational priorities and stakeholder feedback
Collaborate with region and school leaders to implement data entry and data governance best practices org-wide, with a focus on core data systems (e.g. Infinite Campus, Illuminate, DeansList, etc)
Work with the Chief Operating Officer to manage data infrastructure related billing, subscriptions, and licenses and drive infrastructure investments
Serve as a full-time and engaged member of KIPP Baltimore’s staff
Qualifications
A passion for the mission of KIPP Baltimore
A Bachelor’s degree
5+ years of experience in roles focused on data collection, integration, storage, reporting, and/or analysis
Strong quantitative skills with demonstrated proficiency in managing large and/or challenging data sets
Proficiency with SQL/T-SQL, SQL Server, and Visual Studio/SQL Server Data Tools (SSIS, SSAS, and SSRS) and at least one programming language (e.g., Python, R, or similar); Python experience strongly preferred
Experience designing and developing ETL data pipelines using common tools (e.g., Apache Airflow, AWS Glue, FiveTran, or similar)
Experience with common software engineering tools (e.g., Git/GitHub, JIRA, Confluence, or similar)
Experience with data visualization and dashboarding tools (e.g., Tableau, PowerBI, or similar)
Experience working with K-12 educational data and data systems
Experience using tools within KIPP Baltimore’s existing data stack a plus:
Primary Source Systems: Infinite Campus, Illuminate (Postgres), DeansList, Salesforce
Data Integration/ETL: AWS Lambda, AWS Glue
Data Storage: Amazon S3, MSSQL (Amazon RDS)
Data Visualization: Tableau
Version Control: GitHub
Strong project management skills, including managing projects with many components
Experience managing vendor relationships and advocating on behalf of project goals with external stakeholders
Ability to manage the ambiguity and multiple priorities inherent in an entrepreneurial environment
Outstanding organizational skills and high attention to detail
Outstanding written and oral communication skills
Proactive problem solver who demonstrates initiative
Lives the KIPP Baltimore values of:
Affirmation
Optimism
Joyful Excellence
Collective Power
Community
Benefit Information
Full Benefits Package
School/Organization Information
ABOUT KIPP BALTIMORE
KIPP is a non-profit network of college-preparatory, public charter schools serving elementary, middle and high school students. Our schools are part of the free public school system and enrollment is open to all students in Baltimore City. KIPP Baltimore was founded in 2002 with the opening of KIPP Ujima Village Academy middle school. In 2009, KIPP Harmony Academy was launched, and they now collectively serve more than 1,500 kindergarten through eighth grade students each day. Both schools are operated by KIPP Baltimore, whose mission is together with families and communities, we create joyful, academically excellent schools that prepare students with the skills and confidence to pursue the paths they choose—college, career, and beyond—so they can lead fulfilling lives and build a more just world.
In addition to the high-quality academic opportunities that students receive while attending KIPP Harmony Academy and KIPP Ujima Village Academy, KIPP Baltimore also makes a long-term investment in our students both while they are at KIPP schools and beyond through the KIPP Forward program. KIPP Forward supports and guides students to gain admission to college-preparatory high schools and helps them succeed and stay on the path to and through college and careers. Today, our KIPP Forward program serves more than 1,100 KIPP alumni. More than 90 percent of our alumni have graduated from high school within four years and 70 percent have matriculated to college.
KIPP Baltimore is part of the national Knowledge is Power Program (KIPP), a network of free, open-enrollment, college-preparatory public schools in educationally underserved communities throughout the United States. KIPP is a non-profit network of 280 college-preparatory, public charter schools serving nearly 175,000 elementary, middle and high school students.