Analytics Engineer

KIPP Baltimore Schools - Baltimore, Maryland - Full time


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


  • 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

Apply for this job

Apply for this job



Experience Level

Mid Level

KIPP Baltimore Schools

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.
Share this job
Get our email newsletterSign me up
Keep up to date with our email newsletterSign me up