Data Engineer II

Pearson • United States,

9h • $90,000 - $110,000 • Remote

About The Position

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. 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.

Requirements

• 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)
• Proven ability to independently deliver end-to-end reporting solutions
• Strong troubleshooting skills across data, performance, and visualization issues
• Experience improving data quality, reliability, and usability
• Strong communication skills that deliver exceptional value to internal and external customers
• Ability to translate complex technical concepts into clear, actionable insights
• Experience working cross-functionally with engineering, analytics, and business teams
• Strong documentation and knowledge-sharing practices
• 5+ years of experience in Power BI development, business intelligence, or analytics engineering
• Demonstrated experience delivering production-grade reporting solutions used for operational or strategic decision-making
• Experience working in data-driven environments with evolving data architecture and governance practices

Nice To Haves

• Experience in education, EdTech, or multi-tenant data environments
• Familiarity with Azure ecosystem (Synapse, Fabric, Data Factory, or similar)
• Exposure to data governance, lineage, and semantic layer standardization
• Experience supporting self-service analytics at scale

Responsibilities

• 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
• 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
• 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
• 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
• 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

Benefits

• annual incentive program
• information on benefits offered is here [https://nam02.safelinks.protection.outlook.com/?url=https://pearsonbenefitsus.com/&data=04|01|[email protected]|2c256513c79f4679be7c08d9e7287ebb|8cc434d797d047d3b5c514fe0e33e34b|0|0|637794983376381246|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0=|3000&sdata=t1YQPUL7BgoclUd7yE2i86QAirLf4z3z8OEWgr42q7c=&reserved=0]

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed