Data Engineer II

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

• 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 data quality, reliability, and usability

Collaboration & Communication

• 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

Qualifications

• 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

Preferred Experience

• 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

• Consistent delivery of reporting projects meeting and exceeding requirements and timeframes

Applications will be accepted through June 1. This window may be extended depending on business needs.

Compensation at Pearson is influenced by a wide array of factors including but not limited to skill set, level of experience, and specific location. As required by the California, Colorado, Hawaii, Illinois, Maryland, Minnesota, New Jersey, New York State, New York City, Vermont, Washington State, and Washington DC laws, the pay range for this position is as follows:

The full-time salary range is between $90,000 - $110,000

This position is eligible to participate in an annual incentive program, and information on benefits offered is here .

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** ., + Lead impactful analytics work that supports **students, educators, and school systems nationwide** + Be part of a **growing Data Product organization** shaping the future of analytics at PVS + Work in a collaborative environment that values **innovation, ownership, and continuous improvement** + Become part of the Pearson Virtual Schools mission where we are helping people achieve success through lifelong learning, At Pearson, our purpose is simple: to help people realize the life they imagine through learning. We believe that every learning opportunity is a chance for a personal breakthrough. We are the world's lifelong learning company. For us, learning isn't just what we do. It's who we are. To learn more: We are Pearson.