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 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.
- 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.
- 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.
- 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
- Strong problem-solving and analytical skills
- Experience with data analysis and visualization
- Proficiency in Microsoft Power BI, including Power Query (M) and DAX
- Ability to design and maintain scalable data models and interactive dashboards
- Experience with SQL and other query languages for executing complex ad-hoc data requests
- Collaboration and partnership skills to work effectively with cross-functional teams and leadership
- Experience ensuring data quality, governance, testing, validation, and performance tuning of reports and data models
- Knowledge of security implementation in Power BI Service, including Row-Level Security (RLS) and user access management
- Ability to scope end-user requirements and project plan for data visualizations
- Commitment to knowledge management, documentation, and code review practices
- Experience transforming large, complex, and disparate data sources into actionable insights
- Willingness to travel to other regions and/or sites 5%-10% of the year
Nice to Have
- Experience migrating reporting assets from Tableau to Power BI
- Background in education or nonprofit sector
- Familiarity with data warehouse architecture and ETL/ELT processes
Work Arrangement
Hybrid — Houston
Additional Information
- Expected to travel to other regions and/or sites 5%-10% of the year
- Hybrid schedule: come to the SSP office in Houston 3 days a week, work from home 2 days a week
- Team’s existing BI tool is Tableau; transitioning to Power BI by January 2027
