Senior Data & Reporting Engineer
2 days ago
Manchester
POWWR are looking for a Senior Data & Reporting Engineer to join our UK engineering team and help advance POWWR’s modern data and analytics platform (MDP). In this role, you’ll design and deliver high-quality data pipelines, models, software, and reporting solutions that power product features and insights across our SaaS business. Who is POWWR? POWWR provides advanced platforms and simple solutions for over 65 energy suppliers and more than 1,400 brokers across the United States and the United Kingdom, empowering them to grow their businesses and create a transparent, connected energy journey. Formerly known as UD Group in the UK, POWWR continues to revolutionize the global energy marketplace. Our engineering culture is rooted in collaboration, continuous improvement, and a passion for solving complex problems through elegant, data-driven solutions. What will you be doing? You’ll operate within an Agile DevOps-focused environment where automation, observability, and agile delivery are expected. Working closely with product managers, analysts, engineers, architects, and BI teams, you will build modern data and reporting features and solutions as well as improve the robustness, scalability, and security of our Azure-based SaaS data platform. Data Platform Engineering: • Design, build, and orchestrate modular, declarative data pipelines using dbt, Dagster, and dlt within a Kubernetes-hosted environment., • Develop and optimize Delta Lake models in Databricks/Synapse and Azure Data Lake Gen2, ensuring scalability and ACID compliance., • Maintain and enhance existing data pipelines (SQL Server, Azure Data Factory) to support ongoing migration and integration activities., • Implement data quality validation and automated testing through dbt and Dagster frameworks., • Embed CI/CD and automation practices for reliable, repeatable pipeline deployments., • Build and monitor data observability using Dagster and Grafana to ensure reliability through logging, monitoring, and alerting., • Collaborate with the Data Stewardship Guild to maintain lineage, cataloguing, and governance via OpenMetadata., • Drive cost optimization, performance tuning, and standardization across both legacy and modern data pipelines., • Ensure compliance with ISO 27001, GDPR, and POWWR’s data governance standards. Reporting & Business Intelligence: • Design, build, and maintain data pipelines and ETL/ELT workflows for analytics and reporting., • Develop and optimize data models and dashboards in reporting platforms (Power BI and Tableau)., • Deliver high-quality, analytics-ready datasets consumed by Power BI and Tableau., • Implement data quality validation and automated testing within transformation processes., • Embed automation, version control, and CI/CD practices across analytics and reporting workflows., • Enhance data observability through logging, monitoring, and alerting for key data jobs and pipelines., • Work closely with BI and Product teams to deliver actionable insights and reporting solutions. What we’re looking for • Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field (or equivalent experience)., • 6+ years of experience in data engineering and business intelligence, ideally spanning both traditional and modern data platforms., • Strong understanding of both relational (e.g., MSSQL, PostgreSQL) and non-relational database technologies (e.g., NoSQL, MongoDB)., • Hands-on experience with large-scale Azure data services (Synapse, Databricks, Azure Data Factory or similar)., • Experience delivering reporting solutions for platforms like Power BI or Tableau, including data modeling and performance optimization., • Advanced SQL skills, data modeling, and proficiency with dbt Core for modular SQL transformations and testing., • Experience orchestrating pipelines with Dagster, Airflow, or similar tools., • Familiarity with Python for data manipulation, orchestration, and automation., • Experience deploying and managing data workloads on Kubernetes (AKS preferred)., • Experience working within a DevOps or agile engineering culture, leveraging CI/CD and observability practices., • Strong collaboration, problem-solving, and communication skills, with the ability to bridge between engineering, BI, and architecture teams as well as business stakeholders. Bonus Skills • Knowledge of data governance and lineage tools (e.g., OpenMetadata, DataHub)., • Use of table formats such as Delta Lake or Iceberg., • Experience with data quality frameworks (e.g., dbt, Elementary, Great Expectations)., • Understanding of event-driven architectures and real-time data streaming (Kafka, Event Hubs)., • Familiarity with AI-driven analytics or machine learning pipelines., • Experience with data warehouses such as Snowflake or Redshift. In return, we offer: • Competitive salary, • 25 days holiday plus bank holidays, • Cashplan & 24/7 GP service, • Flexible working from home, • Death in Service cover, • Blended learning culture with individual development plans, • Annual company bonus scheme for high contribution, • Annual company conferences & team events POWWR promotes an environment where everyone can bring their true, authentic self to work and deliver their best work. We believe in equal opportunities and welcome applicants from all backgrounds, regardless of gender, marital status, race, nationality, ethnicity, religion, neurodiversity, sexual orientation, or age.