Data Analyst

JOB DESCRIPTION: 

KIPP Texas is currently seeking a smart, motivated and experienced data analyst to bring strong problem-solving and analytical skills to a leading charter management organization. KIPP Texas is committed to using data to drive academic, financial, instructional, operational and talent improvement and decision-making. The Data Analyst is critical to KIPP Texas achieving this work. This individual must be as much a people person as a numbers person - collaboration and building strong cross-functional partnerships are necessary to be successful in this role. Note: The team’s existing BI tool is Tableau and we will be transitioning to Power BI by January 2027. This position reports to the Senior Director, Analytics, Research & Evaluation and follows a hybrid schedule (coming to our SSP office in Houston 3 days a week; and work from home 2 days a week). This role is expected to travel to other regions and/or sites 5%-10% of the year.

ROLE RESPONSIBILITIES: 

Data Analysis & Visualization

• Design, develop, and maintain scalable data models and interactive dashboards within Microsoft Power BI, utilizing advanced features like Power Query (M) and DAX for transformation and complex calculations.

• Support the successful migration of current reporting assets from Tableau to the Power BI platform, including data source verification, report recreation, and establishing data validation protocols.

• Work directly with school administration and organizational leadership across all of our regions (Austin, Dallas-Fort Worth, Houston, and San Antonio) to ensure Power BI tools and processes meet the needs of our end-users.

• Ensure data quality and governance by rigorously testing, validating, and performance-tuning Power BI reports and underlying data models for accuracy and optimal load times.

• Implement and manage security within the Power BI Service, including configuring Row-Level Security (RLS) and managing user access and deployment across workspaces.

• Scope end-user requirements and project plan for advanced interactive and dynamic data visualizations in partnership with organizational stakeholders to meet functional needs.

• Contribute to our internal team’s knowledge management systems, documentation practices, and code review process to ensure that we build and maintain infrastructure sustainably.

Data Reporting

• Execute complex ad-hoc data requests using SQL and other query languages to provide timely insights.

• Develop, and provide training to leadership and key stakeholders on the use, manipulation, and analysis of interactive data visualizations in Power BI.

• Support leadership by transforming large, complex, and disparate data sources into clear, actionable analysis and insights that drive strategic priorities.

Data Strategy

• Lead assessment reporting to major stakeholders including our Academics Department, Chiefs Team, and School Management Team (Regional Superintendents, Heads of Schools, etc.).

• Partner with departments and school staff to plan and prioritize short-term and long-term analytics needs.

• Collaborate with the Data Systems Team to refine data warehouse architecture and ETL/ELT processes to ensure data integrity and optimize data ingestion for BI consumption.

Team Alignment & Professional Development)

• Contribute to team growth and data literacy by participating in peer knowledge sharing, supporting internal documentation, and providing ad-hoc training sessions to colleagues.

• Proactively engage in professional development to maintain expertise in Microsoft Power BI and related data technologies, including new releases and features.

• Support high-priority, cross-functional strategic projects as directed by the Senior Director, Analytics, Research & Evaluation.