Data Engineer II

Pearson Virtual Schools is committed to expanding access to high-quality education through innovative digital learning solutions. They are seeking a Senior Power BI Developer to design, build, and deliver high-quality analytics and ETL solutions that empower decision-making across the organization.

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

Requirements:

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