Data Engineer

Summary

Join Methods Analytics as a Data Engineer to contribute to the Public Sector Business unit, working on innovative projects, transforming raw data into powerful insights that shape strategic decisions and drive business transformation.

Requirements

• Proficiency in SQL and Python
• Understanding of Data Lakehouse Architecture
• Hands-On Experience with Spark-Based Solutions
• Expertise in Building ETL and ELT Pipelines
• Efficiency in Query Writing
• Experience in Power BI Dashboard Development
• Proficiency in Dimensional Modelling
• CI/CD Mindset
• Business Requirements Translation
• Strong Communication Skills
• Continuous Learning and Development

Responsibilities

• Work closely with cross-functional teams, translating complex technical concepts into clear, accessible language for non-technical audiences and aligning data solutions with business needs
• Collaborate with a dynamic delivery team on innovative projects, transforming raw data into powerful insights that shape strategic decisions and drive business transformation
• Utilise platforms and tools such as Microsoft Fabric, Azure Data Factory, Azure Synapse, Databricks, and PowerBI to build robust, scalable, and future-proof end-to-end data solutions
• Design and implement efficient ETL and ELT pipelines, ensuring seamless integration and transformation of data from various sources to deliver clean, reliable data
• Develop and maintain sophisticated data models, employing dimensional modelling techniques to support comprehensive data analysis and reporting
• Implement and uphold best practices in data governance, security, and compliance, using tools like Azure Purview, Unity Catalog, and Apache Atlas to maintain data integrity and trust
• Ensure data quality and integrity through meticulous attention to detail and rigorous QA processes, continually refining and optimising data queries for performance and cost-efficiency
• Develop intuitive and visually compelling Power BI dashboards that provide actionable insights to stakeholders across the organisation
• Monitor and tune solution performance, identifying opportunities for optimisation to enhance the reliability, speed, and functionality of data systems
• Stay ahead of industry trends and advancements, continuously enhancing your skills and incorporating the latest Data Engineering tools, languages, and methodologies into your work

Benefits

• Autonomy to develop and grow your skills and experience
• Be part of exciting project work that is making a difference in society
• Strong, inspiring and thought-provoking leadership
• A supportive and collaborative environment
• Development access to LinkedIn Learning, a management development programme and training
• Wellness 24/7 Confidential employee assistance programme
• Social – Breakfast Tuesdays, Thirsty Thursdays and Pizza on the last Thursday of each month as well as commitment to charitable causes
• Time off 25 days a year
• Pension Salary Exchange Scheme with 4% employer contribution and 5% employee contribution
• Discretionary Company Bonus based on company and individual performance
• Life Assurance of 4 times base salary
• Private Medical Insurance which is non-contributory (spouse and dependants included)
• Worldwide Travel Insurance which is non-contributory (spouse and dependants included)