Lead Data Engineer Technology - Data & Reporting · Nottingham ·

ENSEK Ltd; Nottingham; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading company in the energy sector seeks a Lead Data Engineer to design and manage data assets. This role requires extensive experience in SQL, data warehousing, and ETL processes, along with strong communication skills. You will guide a team in delivering high-quality data solutions and improve engineering processes within an Agile environment.

Qualifications

• Experienced Data Engineer in delivery-focused environment.
• Ability to analyze complex business problems.
• Extensive experience with SQL and data solutions.

Responsibilities

• Design and manage data models, ensuring optimal performance.
• Contribute to technical discussions and decision-making.
• Mentor junior Data Engineers and enhance team collaboration.

Skills

SQL

Data Warehousing

Data Lakes

ETL Processes

Agile Methodologies

Problem Analysis

Communication

Tools

Databricks

Job description

We are a technology business operating in the global energy sector.

ENSEK have become the go-to option for top energy suppliers across the globe. Why? Because our technology is a significant step change away from the legacy systems that have historically dominated the market. It’s also massively cheaper to adopt the ENSEK solution, with no loss in customer service or standards.

But by far the biggest reason why ENSEK is the best choice in energy supplier software, is because of the people who work here and their endless enthusiasm, energy, and the way they support their colleagues. All our clients comment on what great people we have. Our people are our superpower.

That is where you come in.

ROLE SUMMARY

Reporting to the Data Engineering Manager,the Lead Data Engineers are responsible for working together to write clean code and deliver optimal outcomes. As part of the squad be responsible for designing, creating, deploying and managing the organisation's data assets. You will be demonstrating your knowledge and practical experience, following coding standards and contributing to daily scrums, sprint reviews, retrospectives and refinements.

In your lead position you will be responsible for guiding and positively influencing other members of the data engineering squad to follow the appropriate PR, testing, and code review processes with the ultimate goal of writing excellent quality, clean, and performant code.

KEY RESPONSIBILITIES

1. Working with the Data Architects you will review and refine your deliverables to provide confidence in the technical delivery of functionality.
2. Ensure data solutions are designed and maintained for optimal performance, scalability, and reliability.
3. Create, optimise, and maintain logical and physical data models, including data warehouses and data lakes.
4. Design and manage the data integration process, ensuring seamless data flow between systems.
5. Contributing to technical discussions which influence technical decisions for the squad.
6. Providing regular status updates on progress against the technical debt within domain area, escalating any risks or issues.
7. Working with squad members in pair programming or solo to write the software or configure the service that is being delivered in this initiative.
8. Contributing as a member of an agile team; attending team meetings, working closely with the Product Owners in the squad and participating in initiative meetings.
9. Work closely with Data Scientists, Data Engineers, Business Analysts, and other stakeholders to understand data needs and provide effective solutions.
10. Learning and developing your area of knowledge anddomainexpertisewithintheengineeringfunction.
11. Proactively contributing to and suggesting ways of improvingengineering processes at ENSEK.
12. Promoting and maintaining a positive ‘can do’ attitude, building collaborative working relationships with the whole engineering squad and sharing skills and knowledge, which includes mentoring Data Engineers.
13. Adding value to the experience of our clients, colleagues and other relevant stakeholders through practicing and promoting the ENSEK values.

TECHNICAL SKILLS

1. Experienced Data Engineer from within a delivery focused environment
2. Ability to analyse complex business problems and design workable technical solutions is a must
3. Excellent knowledge of the software development life cycle, testing methodologies and implementation of end-to-end delivery within an Agile environment
4. Extensive experience with SQL queries, performance, and investigative processes
5. Experience with data warehousing and data lake solutions
6. Familiarity with ETL processes and tools
7. Databricks experience being advantageous

SOFT SKILLS

1. Strong communication skills, able to clearly articulate status, risks and issues within the squad and with senior stakeholders
2. Values the importance of teamwork and experience of working as part of a remote, multi-disciplined team is advantageous
3. Experience of working in the Energy / Utilities would be advantageous but not essential