Data Analyst

KIPP Texas Public Schools is a free, public charter school network with more than 45 Pre-K - 12 schools across Austin, Dallas-Fort Worth, Houston, and San Antonio. With over 30 years in Texas, we work together with our families and communities to prepare students for college, career, and beyond. Our schools provide a high-quality, well-rounded education built on academic success and personal growth, where all students learn and thrive in a productive, safe, and joyful way. As one of the earliest charter networks in Texas—founded in Houston in 1994 and operating as KIPP Texas since 2018—we hire dynamic, collaborative, and dedicated individuals with an unyielding belief that every child will succeed.

About the role

The Data Analyst is critical to KIPP Texas achieving its commitment to using data to drive academic, financial, instructional, operational, and talent improvement and decision-making. 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. The team’s existing BI tool is Tableau, with a transition to Power BI planned by January 2027. This position reports to the Senior Director, Analytics, Research & Evaluation and follows a hybrid schedule (3 days in the Houston office, 2 days remote). Travel to other regions/sites is expected at 5%-10% annually.

Responsibilities

• 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 migration of current reporting assets from Tableau to Power BI, including data source verification, report recreation, and establishing data validation protocols.
• Work directly with school administration and organizational leadership across all regions (Austin, Dallas-Fort Worth, Houston, and San Antonio) to ensure Power BI tools and processes meet end-user needs.
• 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 internal team’s knowledge management systems, documentation practices, and code review processes to ensure sustainable infrastructure.
• 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.
• Transform large, complex, and disparate data sources into clear, actionable analysis and insights that drive strategic priorities.
• Lead assessment reporting to major stakeholders including the 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.
• 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.

Requirements

• Minimum Bachelor’s degree.
• At least 2-4 years of analytics experience, with a preference for candidates who have worked in the public sector or similar mission-driven environments.

Skills

• Advanced proficiency in Microsoft Power BI, including expertise in report design, data modeling (star schema), and development of complex calculated measures using DAX and Power Query (M).
• Mastery of SQL for complex querying, data extraction, and deep understanding of relational databases and data warehousing concepts (e.g., normalization, schema design).
• Experience working within the Azure Data Ecosystem and an understanding of ETL/ELT processes to move and transform data for analytics.
• Proficiency with Tableau is preferred due to the ongoing transition/migration project.
• Strong background in statistical analysis required, with proficiency in Python or R.
• Mastery of Microsoft Excel.
• Superior quantitative and technical skills.
• Proven ability to work with large, disparate datasets, ensuring rigorous and efficient data cleaning, validation, and manipulation.
• Strong written and oral communication skills, specifically the ability to translate complex data findings and technical requirements into actionable insights for non-technical stakeholders.
• Passion for being part of a team-oriented, mission-driven culture and a commitment to the students we educate.
• Experience working with a team and collaborating effectively with cross-functional stakeholders (e.g., Finance, Academics, School Leaders).

Physical Requirements

• The person in this position needs to be able to move about inside and outside the school throughout the workday.
• Expected to attend conferences, meetings, and training sessions both virtually and in person within the Region.
• Reliable transportation is needed for travel between campuses.
• Ability to maintain emotional control under stress.

Work Environment

• Hybrid work schedule: reports to the central office or schools three days a week, with two days remote.
• Work with frequent interruptions.
• Minimal travel: may travel to other school sites or regional offices for professional learning, meetings, and other work-related activities.

Benefits

• Comprehensive medical, dental, and vision plans with coverage options for employees and their families.
• Competitive vacation and flexible paid time off (PTO) policies.
• Paid family leave.
• Flexible spending account or high-yield HSA.
• Employee assistance programs.
• Employee-paid benefits: legal plans, LifeLock identity protection, life insurance, and disability insurance.