Junior SQL Data Engineer London, England
Job description
Are you a capable SQL data engineer who is passionate about the power of data to solve environmental issues? We are looking for an SQL data engineer to shape delivery by collaborating with data architects and modellers to contribute to the acquisition of corporate data requirements, documenting them according to the required standards utilising the prescribed methods and Azure data tools, in order to build our centralised data platform.
This is a permanent role, with responsibility for developing, constructing, testing and maintaining architectures such as data pipelines and large-scale data processing warehouses. They will leverage industry best practice while delivering changes, such as agile backlogs, code repositories, automated builds, testing and releases. They will be responsible for ensuring data scientists can pull relevant data sets for their analyses, and implement data pipelines to connect operational systems, data for analytics and BI systems.
The post holder will provide clean, usable data to the business through the data platform in accordance with governance and execute and evaluate data requirements to support business activities and projects. The post holder will be central in ensuring the delivery of world-class digital products and changing the delivery culture.
It is a not-for-profit charity that runs the global disclosure system for investors, companies, cities, states and regions to manage their environmental impacts.
Key responsibilities include:
- Managing the investigation of corporate data requirements, documenting them according to the required standards utilising the prescribed methods and tools.
- Implementing data flows to connect operational systems, data for analytics and BI systems.
- Ensuring that those using the data structures and associated components have a good understanding and that any queries are dealt with promptly and efficiently.
- In liaison with the information management or IT management functions, contributing to the development and maintenance of corporate data standards.
Required skills and experience:
- 3+ years Strong technical process understanding regardless of technology.
- Core SQL Competencies – SSMS, SSIS, T-SQL, Stored Procedures.
- High attention to detail.
- Strong communication skills.
- Structured problem-solving techniques.
- Performance-tuning skills
- Efficient in building ETL and ELT processes for enterprise solutions
- Strong software delivery methods and knowledge
Desired skills and experience
- Digital delivery – has a track record of working on DevOps delivery
- Exposure in Climate Change data legislation, practices and stakeholders
- Experience in Environmental related industries i.e Water, Energy and Forestry related
- Presentation skills
- Azure skills (i.e. Azure Devops, Azure Data Factory, Azure Data Bricks, Azure SQL)
This is a permanent full-time role, reporting to the Head of Data Engineering.
Salary and benefits: £48,000 - £53,000 per annum, 30 days holiday plus bank holidays. Generous non-contributory pension provision, annual discretionary bonus (depending on company performance), Employee Assistance Program, life assurance, Training and development, Flexible working opportunities and others.
Interested applicants must be eligible to work legally in the United Kingdom. We cannot sponsor this role.
Job Types: Full-time, Permanent
Salary: £48,000.00-£53,000.00 per year
Schedule:
- 8 hour shift
- Monday to Friday
Experience:
- Junior SQL Data Engineer: 3 years (required)
- Core SQL Competencies: 2 years (required)
- Azure Skills: 1 year (required)
Work authorisation:
- United Kingdom (required)
