Specialist, Analytics & Automation
Department:
Job Summary
Job Title: Specialist Analytics & Automation
Role Overview
We are seeking an Analytics Engineer to design build and operate our analytics and automations. This role is responsible for delivering high-quality Power BI reporting establishing and maintaining Microsoft Fabric and building business automations and applications using Python Power Automate and Power Apps.
You will be part of the Cloud & Service Management organization helping to evolve our self-service analytics scalable data architecture and automationswhile ensuring security performance and governance across the platform.
This is a hands-on role with ownership of both solution delivery and platform best practices.
Key Responsibilities
Analytics & Reporting
- Design develop and maintain reports and dashboards
- Build and optimize semantic models using strong dimensional modeling (star schema)
- Write and tune DAX measures with a focus on performance and usability
- Implement Power BI deployment pipelines and promote content across environments
Microsoft Fabric Platform
- Establish and maintain Microsoft Fabric architecture including:
- Lakehouse and/or Warehouse
- Dataflows Gen2
- OneLake data organization
- Manage Fabric capacities workspaces and permissions
- Monitor performance cost and reliability of Fabric workloads
- Develop and maintain Python-based data transformations and notebooks within Fabric
- Use Python for data preparation enrichment validation and advanced analytics
- Define and enforce data modeling and medallion architecture standards
Automation & Applications
- Build and maintain automation flows for business processes approvals and integrations
- Develop Apps to support business workflows
- Work with Dataverse connectors and security roles
- Implement error handling logging and operational support patterns
Platform Governance & Operations
- Define Dev/Test/Prod environment strategy for reporting and automation platform
- Implement Application Life best practices (solutions pipelines source control where applicable)
- Establish governance standards to prevent platform sprawl
- Partner with security and IT teams on access control and compliance
- Provide guidance and enablement to analysts and citizen developers
Collaboration & Leadership
- Translate business requirements into scalable technical solutions
- Act as a subject matter expert for Fabric and Power Platform
- Mentor junior team members and promote best practices
- Contribute to platform roadmap and continuous improvement efforts
Required Qualifications
- 5 years of experience in analytics BI or data engineering roles
- 3 years of hands-on Power BI development experience
- Strong experience with Microsoft Fabric (Lakehouse Warehouse Dataflows)
- Proficient in DAX SQL and data modeling
- Hands-on experience with:
- Power Automate (cloud flows approvals integrations)
- Power Apps (Canvas apps)
- Dataverse
- Python
- Experience managing environments security and deployments
- Strong understanding of data governance and analytics best practices
- Candidates must be willing to work UK or US hours
Preferred Qualifications
- Experience designing enterprise-scale analytics platforms
- Familiarity with Azure services (Azure SQL Data Factory Synapse)
- Experience with CI/CD concepts for Power Platform and Power BI
- Power Platform or Microsoft analytics certifications
- Experience working in a Center of Excellence (CoE) model
Required Experience:
IC
Key Skills
About Company
Pearson is an Equal Opportunity Employer and a member of E-Verify. Employment decisions are based on qualifications, merit and business need. Qualified applicants will receive consideration for employment without regard to race, ethnicity, color, religion, sex, sexual orientation, gen ... View more