Low Carbon Contracts Company
Data Engineer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Department: Tech Hub
Employment Type: Full Time
Location: London, England, United Kingdom
Description
Contract type: Permanent
Hours: 37.5
Salary: circa £62,000 depending on experience
Location: Canary Wharf
WFH policy: Employees are required to attend the office 2 days/week
Flexible working: Variety of flexible work patterns subject to line manager discretion e.g. Compressed 9-day fortnight.
Reports to: Engineering Manager
Deadline Note: We reserve the right to close the advert before the advertised deadline if there are a high volume of applications.
Role Summary
The Data engineer role will have a specific focus on data and integration, ensuring that they drive a single version of the truth by developing and maintaining reliable solutions to store and manage key data.
The role will source, model, and provide data in a form which is ready for report/dashboard building. They support the data team and participate in the design, development, and maintenance activities for LCCCs databases and data warehouse, as well as ensure following the defined data systems standards that conform to the data architecture.
They will also build and maintain key data governance and management artefacts.
Key Responsibilities
- Participate in designing, developing and maintaining activities for LCCC DataWarehouse ensuring reliable data across the organisation
- Source, model and provide reliable data in a form that is ready for report/dashboard building
- Follow the data governance standards
- Build and maintain key data governance and management artefacts e.g., Flow Diagram, Data Dictionary.
- Identify patterns, anomalies, and structure of data in preparation for Extract Load and Transformation.
- Perform data validation, quality checks, and reconciliation across source and target systems.
- Define the low-level design of a data warehouse to ensure robustness e.g., restorability, traceability, ease to support, etc.
- Help design and maintain the modern DataWarehouse architecture, implementation, administration, and support
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Skills, Knowledge and Expertise
- Considerable experience in developing data structures using highly scalable database systems
- Experience developing, maintaining, and supporting data pipelines and data engineering solutions using Python (preferably PySpark) and SQL.
- Experience optimising SQL queries, Python code, and data processing workloads to improve performance, scalability, and reliability.
- Experience with Azure and/or AWS and/or GCP
- Able to work with large datasets and extrapolate conclusions
- Strong analytical and critical thinking abilities
- Experience working with stakeholders to gather business requirements and translate them into effective data engineering solutions.
- Experience building and maintaining reliable, scalable ETL/ELT solutions on big data platforms and working with a variety of data infrastructure technologies.
- Data Engineering experience within the Microsoft technology stack (e.g. Azure Data Factory, Synapse, Databricks, ADLS)
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Employee Benefits
Benefits
As if contributing to and supporting work that makes life better for millions wasn’t rewarding enough, we offer a full range of benefits too. Key benefits that may be available depending on the role include:
- Annual performance based bonus, up to 10%
- 25 days annual leave, plus eight bank holidays
- Up to 8% pension contribution
- Financial support and time off for study relevant to your role, plus a professional membership subscription
- Employee referral scheme (up to £1500), and colleague recognition scheme
- Family friendly policies, including enhanced maternity leave and shared parental leave
- Free, confidential employee assistance, including financial management, family care, mental health, and on-call GP service
- Three paid volunteering days a year
- Season ticket loan and cycle to work schemes
- Family savings on days out and English Heritage, gym discounts, cash back and discounts at selected retailers
- Employee resource groups
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location