Analytics Engineer

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