Analytics Engineer

ParentPay Group

United States

Remote

USD 110,000 - 160,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

ParentPay Group is seeking an Analytics Engineer to design, develop and maintain analytics-ready data models across the data warehouse. You will translate business requirements into reliable warehouse structures and efficient transformation logic, taking ownership from design to deployment.

You will work with BI colleagues to create trusted data assets that streamline reporting and reduce duplicated logic. The role emphasizes robust testing, documentation, and adherence to development standards,

Qualifications

  • Strong SQL Server experience and advanced SQL development.
  • Experience designing data warehouse models for analytics.
  • Understanding of dimensional modelling concepts (facts, dimensions, grain, keys).
  • Ability to investigate complex datasets and establish trusted business logic.

Responsibilities

  • Design and develop analytics-ready data models within the data warehouse.
  • Build and maintain fact and dimension models with clear grain and relationships.
  • Develop complex SQL queries, stored procedures and views for data transformation.
  • Investigate source systems to understand data rules and quality considerations.

Skills

SQL Server
Advanced SQL
Stored procedures
Views
Performance tuning
Dimensional modelling
Data warehouse
Analytical thinking
Stakeholder communication
Power BI

Tools

Power BI

Job description

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Analytics Engineer: Build Scalable Data Models for BI
Analytics Engineer: Build Scalable Data Models for BI

ParentPay Group • United States

Remote
USD 110,000 - 160,000
Senior Data Analyst
Senior Data Analyst

bees • United States

Remote
USD 90,000 - 160,000
Remote work
Bonuses
Pension
+3
Data Engineer
Data Engineer

emerchantpay • United States

Remote
USD 120,000 - 180,000
25 days paid holiday
Fully distributed and remote
Professional development - books,培训, 证
+1
Data Analytics Developer
Data Analytics Developer

Trinity Consultants • Dallas (TX)

On-site
USD 90,000 - 140,000
Junior PowerBi Engineer
Junior PowerBi Engineer

N-iX LTD • United States

Remote
USD 70,000 - 110,000
Flexible working format
Competitive salary
Personalized career growth
+1
Data Analyst (Power BI & Data Modeling)
Data Analyst (Power BI & Data Modeling)

K2 Integrity • United States

Remote
USD 85,000 - 120,000
Senior Data Analyst
Senior Data Analyst

Kake Group • United States

Remote
USD 120,000 - 160,000
Senior Analytics Engineer (Data Modeling & BI)
Senior Analytics Engineer (Data Modeling & BI)

feverup • United States

Hybrid
USD 110,000 - 170,000
Home-office setup
Health insurance
Stock options
+3
Analytics Engineer
Analytics Engineer

The Hagen Ricci Group • New York (NY)

On-site
USD 80,000 - 120,000
Data Scientist Associate
Data Scientist Associate

JP Morgan Chase • Plano (TX)

On-site
USD 110,000 - 150,000