Analytics Engineer

Job not on LinkedIn

🔥 5 minutes ago

🇬🇧 United Kingdom – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Analytics Engineer

🇬🇧 UK Skilled Worker Visa Sponsor

This company has sponsored UK Skilled Worker visas in the past.

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

ParentPay

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2002

💳 Fintech

📚 Education

🤝 B2B

💰 Private Equity Round on 2020-12

Fintech • Education • B2B

ParentPay is a digital payment platform tailored for schools that streamlines payment processes for parents and guardians. It offers various services including cashless payments for meals, school trips, and clubs, as well as tools for school administration such as meal management and parental engagement. Founded to enhance communication and financial reporting within the education sector, ParentPay now supports over 11k schools and 4 million parents in the UK.

📋 Description

• Design and develop well-structured, reusable and analytics-ready data models within the data warehouse. • Build and maintain fact and dimension models with clear grain, keys, relationships, business definitions and historical data handling. • Develop complex SQL queries, stored procedures and views to transform and combine data from multiple sources. • Investigate unfamiliar or poorly documented source systems to understand relationships, business rules and data-quality considerations. • Design efficient and maintainable data transformation and loading processes, including incremental load or refresh approaches where appropriate. • Reconcile source data with warehouse outputs, identifying and resolving data-quality or logic issues. • Work with BI colleagues to understand reporting, semantic model and Power BI requirements, ensuring warehouse models are practical for downstream use. • Document data models, transformation logic, assumptions and known limitations clearly and consistently. • Apply testing, source control and development standards to ensure solutions are robust, maintainable and scalable. • Manage priorities, dependencies and delivery risks, communicating progress and raising blockers early.

🎯 Requirements

• Strong SQL Server experience, including advanced SQL development, stored procedures, views and performance-aware query design. • Experience designing and developing data warehouse models for reporting and analytics. • Good understanding of dimensional modelling concepts, including facts, dimensions, grain, keys and relationships. • Experience transforming, combining and reconciling data from multiple source systems. • Ability to investigate complex or poorly documented datasets and establish trusted business logic. • Understanding of data quality, testing, documentation and maintainable engineering practices. • Experience working with BI teams, reporting requirements and downstream analytical or semantic models. • Ability to take ownership of work, manage priorities and deliver to agreed timescales. • Clear communication skills, with the ability to explain technical concepts to both technical and non-technical stakeholders. • Desirable: Experience supporting Power BI reporting, semantic models or other BI and analytics platforms. • Desirable: Experience working in a SaaS, EdTech, payments or education-focused environment. • Desirable: Knowledge of source control, deployment processes and data engineering development standards. • Desirable: Experience improving existing data warehouse logic, reducing duplication and increasing model reusability.