Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
SQL
Power BI
SQL Server
Where the posting names them
- 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.
Skills, Knowledge and Expertise
- 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.
- 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.
Desirable Skills and Experience
- Experience supporting Power BI reporting, semantic models or other BI and analytics platforms.
- Experience working in a SaaS, EdTech, payments or education-focused environment.
As an Analytics Engineer within the Data Warehouse team, you will design, develop and maintain reusable, analytics-ready data models that support reporting, business intelligence and decision-making across ParentPay Group. You will work with complex and sometimes imperfectly documented source systems, translating business requirements into reliable warehouse structures and efficient transformation logic.
You will take ownership of data engineering work from investigation and design through development, testing, deployment and documentation. Working closely with BI colleagues and stakeholders, you will help create trusted, consistent and scalable data assets that reduce duplicated logic and make reporting development easier, faster and more reliable.
Key Responsibilities
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.
Skills, Knowledge and Expertise
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 Skills and Experience
Experience supporting Power BI reporting, semantic models or other BI and analytics platforms.
Experience working in a SaaS, EdTech, payments or education-focused environment.
Knowledge of source control, deployment processes and data engineering development standards.
Experience improving existing data warehouse logic, reducing duplication and increasing model reusability.
Employment type
Permanent - Full Time
Demand for Analytics Engineer roles
New Analytics Engineer postings at the employers we follow are down 21% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Analytics Engineer, by the work the posting describes.
Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.
Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.
A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.
US government figures for database architects
Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs
The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.