Data Engineer II at Pearson PlcWestminster

, , United States -

Full Time

Start Date

Immediate

Expiry Date

24 Aug, 26

Salary

110000.0

Posted On

26 May, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, DAX, Power Query, SQL, Semantic Modeling, Star Schema, ETL, Azure Data Factory, Data Visualization, Row Level Security, Tabular Editor 3, DAX Studio, ALM Toolkit, Data Warehousing, Analytics Engineering, Business Intelligence

Industry

Education

Description

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 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 Why Join Us * 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 Success in This Role Looks Like * Trusted, high-performing Power BI reports used consistently by stakeholders * Scalable semantic models enabling self-service analytics * Reduced data discrepancies and improved reporting reliability * Strong partnership across engineering, analytics, and business teams * 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 [https://nam02.safelinks.protection.outlook.com/?url=https://pearsonbenefitsus.com/&data=04|01|tasha.scott@pearson.com|2c256513c79f4679be7c08d9e7287ebb|8cc434d797d047d3b5c514fe0e33e34b|0|0|637794983376381246|Unknown|TWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0=|3000&sdata=t1YQPUL7BgoclUd7yE2i86QAirLf4z3z8OEWgr42q7c=&reserved=0].

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

Design and deliver high-quality Power BI dashboards, semantic models, and ETL solutions to support school operations and student outcomes. Partner with stakeholders and engineers to transform complex data into scalable, governed reporting experiences.