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.