Data Engineer II

Business Intelligence Developer (Power BI) Pearson Virtual Schools (PVS) – Enabling Technology Location: Remote (U.S.-based) About Pearson Virtual Schools At Pearson Virtual Schools (PVS), we are committed to expanding access to high-quality education through innovative digital learning solutions. PVS is a division within Pearson, a global leader in the education industry. Our PVS Enabling Technology team plays a critical role in this mission by building scalable, trusted data products that empower school leaders, educators, and operational teams to make informed decisions that improve student outcomes. As we evolve toward a Data Product–driven organization , we are investing in modern analytics capabilities that combine trusted data pipelines, semantic models, and self-service reporting experiences . Role Overview We are seeking a Senior Power BI Developer to design, build, and deliver high-quality analytics and ETL (extract, transform & load) solutions that power decision-making across Pearson Virtual Schools. This role will operate at the intersection of data engineering and business intelligence , transforming complex data into intuitive, scalable reporting experiences. You will partner closely with data engineers, analysts, and business stakeholders to develop semantic models, dashboards, and reporting experiences that align with defined data products and organizational standards. This is a hands-on individual contributor role with strong ownership expectations across the full lifecycle of analytics delivery—from requirements through deployment and optimization. What You’ll Do Data Visualization & Reporting Design and develop Power BI dashboards and reports that support school operations, student outcomes analysis, and enterprise reporting Translate business needs into intuitive, actionable visualizations aligned with PVS reporting standards Optimize report performance, usability, and accessibility for diverse end users (school leaders, analysts, executives) Implement and maintain data security policies within reporting tools in adherence with PVS data security policies, governance and best practices Semantic Modeling Build and maintain Power BI semantic models (datasets) that serve as governed, reusable data foundations Implement data modeling best practices (star schema, DAX optimization, row-level security) Partner with engineering to ensure alignment between data pipelines and reporting layer Data Quality & Reliability Validate data outputs and ensure consistency between reports and source systems Troubleshoot data discrepancies, refresh failures, and performance issues Contribute to monitoring, testing, and documentation of reporting solutions Implement and validate Row Level Security in a multi-tenant environment Collaboration & Delivery Work closely with business stakeholders to refine requirements and prioritize features Participate in design discussions, backlog refinement, and peer reviews Communicate technical tradeoffs, risks, and timelines clearly to both technical and non-technical audiences Scalability & Data Product Enablement Contribute to the development of scalable, reusable reporting assets that align with PVS data product strategy Support self-service analytics by enabling well-documented datasets and consistent definitions Drive improvements in deployment practices, governance, and lifecycle management What You Bring Technical Expertise Advanced experience with Power BI (report development, visualizations, DAX, Power Query, semantic modeling, Tabular Editor 3 , DAX Studio , or ALM Toolkit) Strong understanding of data modeling concepts (star schema, fact/dimension design) Experience with SQL and working with structured datasets in data warehouses/lakehouses Familiarity with data pipelines and integration concepts (e.g., Azure Data Factory, ETL/ELT patterns) Problem Solving & Ownership Proven ability to independently deliver end-to-end reporting solutions Strong troubleshooting skills across data, performance, and visualization issues Experience improving