Analytics Engineer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Analytics Engineer building reusable SQL Server data warehouse models for ParentPay Group’s education technology platform. Supporting BI, Power BI reporting, and trusted business decision-making.
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.
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.
Similar Jobs
Analytics Engineer
Analytics Engineer building reliable, governed data models for Quartile’s AI-powered retail media optimization platform. Supporting e-commerce analytics, data quality, governance, and business decisions.
Analytics Engineer
Analytics Engineer building dbt models, semantic layers, and BI datasets for Niche’s school-search platform. Improving data quality and analytics capabilities for schools and families.
Senior Analytics Engineer
Senior Analytics Engineer building trusted analytical models for Jellyfish’s AI-integrated engineering intelligence platform. Improving data quality, metric consistency, and developer access to engineering insights.
Analytics Engineer – Supply Data Solutions
Analytics Engineer building reliable, governed supply datasets for ABOUT YOU’s fashion e-commerce platform. Developing Python/GCP pipelines and reusable analytics marts for pricing, planning, and inventory.
Analytics Engineer
Analytics Engineer improving Supply Chain data collection, workflows, Power BI dashboards, and management reporting. Supporting Körber’s intelligent manufacturing and supply chain technology solutions.
Lead Analytics Engineer
Lead Analytics Engineer building Snowflake pipelines, models, and BI for ComputerCare’s IT hardware services. Automating operational reporting and establishing trusted metrics across the business.
Senior Analytics Engineer
Senior Analytics Engineer governing product usage, customer health, retention, and expansion metrics. Building analytics models and AI-enabled data tools for Eve’s AI legal technology platform.
Analytics Engineer
Analytics Engineer building Smile Partners USA’s healthcare data infrastructure, pipelines, and models. Supporting trusted analytics and enterprise decision-making through scalable, governed data solutions.
Data & Analytics Engineer
Data & Analytics Engineer building reliable SQL pipelines, ETL processes, and Power BI insights. Supporting Satellite Office’s global-brand offshore teams in the Philippines.
Senior Analytics Engineer
Senior Analytics Engineer leading enterprise data modeling and semantic architecture at Prenuvo, a proactive healthcare company. Establishing governed data products, quality standards, and analytics engineering practices.
SAP Business Intelligence, Data Analytics Specialist
SAP BI and data analytics specialist developing SAP reporting, dashboards, and data models for Körber Pharma. Building process-mining solutions to improve organizational processes and decision-making.
Data Analyst / Analytics Engineer
Data Analyst/Analytics Engineer migrating dashboards from Metabase to Omni. Supporting an asset-based lending platform processing over $18 billion in annual transactions.
Senior Software Developer – Analytics
Senior Software Developer building cloud analytics products from automotive and consumer data at J.D. Power. Leading architecture, production AI integration, and engineering mentorship.
Intermediate Analytics Developer
Analytics Developer building BigQuery data models, pipelines, and reports for an AI-powered workforce SaaS platform. Delivering proactive insights and intelligent data applications for customer and internal decisions.
Senior Analytics Engineer
Senior Analytics Engineer building scalable data transformations for Aleph's AI-native FP&A platform. Improving data integrity, pipelines, and models across diverse financial and operational sources.
Senior Analytics Engineer
Senior Analytics Engineer owning operations data models and metrics at Finom, a fintech company. Improving reporting, data quality, self-service, and operational tooling.
ETL Developer
ETL Developer building Azure data pipelines and high-volume ETL systems for First American’s title insurance, settlement, and mortgage technology solutions.
Analytics Engineer 5 – Promotional Media
Analytics Engineer building analytics tools, dashboards, and observability for Netflix promotional media and marketing systems. Improving asset recommendations, campaign performance, and subscriber growth.
Analytics Engineer II
Analytics Engineer II building trusted marketing data models and pipelines for Instacart’s grocery delivery platform. Supporting attribution, paid marketing, SEO, and retailer marketing analytics.
Analytics Engineer
Analytics Engineer building scalable dbt and SQL models for Qonto’s European SME finance workspace. Partnering with Product, Growth, and Ops Finance analytics teams while migrating to Omni.