Job Introduction
We are looking for a Data Engineer to design, build and maintain a scalable on-premise data warehouse using modern data engineering practices. You will work with Python, Apache Airflow and DBT in a Unix/Linux environment to develop robust data pipelines, transform data into curated models and support analytics and reporting.
This role requires someone comfortable working in a non-cloud (on-prem) environment, with a strong ownership of infrastructure-aware data solutions.
Main Responsibilities
- Design and build end-to-end ETL/ELT pipelines using Python and SQL.
- Develop and Orchestrate workflows using Apache Airflow.
- Implement transformation logic and data models using dbt (medallionstar where applicable)
- Work in a Unix/Linux environment for scheduling, scripting and deployment.
- Maintain CI/CD pipelines and version control.
- Translate complex business requirements into clear technical specifications.
- Administer, maintain, and provide support for data analytics platforms.
- Build and maintain solutions across the Microsoft BI stack (SSRS, SSIS, SSAS, T-SQL).
- Perform unit testing and resolve issues through effective troubleshooting.
- Collaborate with cross-functional teams to ensure seamless system integration.
- Deliver insightful visualisations and reports to support business projects.
- Create, maintain, and update comprehensive technical documentation.
- Operates in line with the Bank's Risk Management framework (including sub-frameworks) and relevant risk and compliance policies and procedures, ensuring appropriate and timely escalation of any concerns to their line manager.
- Actively promotes and ensures adherence to the Bank's Risk Management framework (including sub-frameworks) and relevant risk and compliance policies and procedures, ensuring timely and appropriate escalation of concerns to relevant senior stakeholders.
Ideal Candidate
Research (by Harvard University) shows that women are particularly likely to second guess themselves and not apply - so if you are worried you don't meet all the criteria, get in touch anyhow and let us do the worrying…
- Strong Programming skills in Python (Data pipelines, API’s and scripting)
- Hands-on experience with Apache Airflow.
- Experience configuring, maintaining, and optimizing DAGs.
- Strong experience with dbt (models, macros, tests and documentation)
- Exposure to containerisation (Docker)
- Knowledge and Experience of ETL/ELT, data warehousing, BI and Cloud.
- Advanced SQL (T-SQL or PL/SQL).
- Good understanding of Linux/Unix systems.
- Design, develop, and maintain solutions using Microsoft BI stack (SSRS, SSIS, SSAS, T-SQL).
- Experience with agile delivery, test automation and CI/CD.
- Skilled at developing dashboards and data visualisations in tools such as PowerBI, Tableau, Qlik etc
Company Information
Handelsbanken is a relationship bank with a decentralised way of working, a strong local presence thanks to a nationwide network of branches, and a long-term approach to customer relations. Each Handelsbanken branch operates as a local business enabling it to make decisions at a local level and provide a bespoke service. The focus is always on the need of the individual customer and not on the sale of specific products.
We are embarking on an exciting Business Transformation journey. This transformation will significantly enhance our technology system systems, processes and services, bringing evolution to our ways of working. Join us in this transformative journey, where your dedication, adaptability and commitment will play a crucial role in shaping the future of banking for our valued customers.
The Bank is deeply committed to embedding good equality and diversity practice into all of our activities. This is so that we are an inclusive, welcoming and inspiring place to work that encourages everyone to apply, regardless of socio-economic background, age, disability, pregnancy and/or parental status, race (including colour, nationality, and ethnic or national origin), veteran status, marital and civil partnership status, religion or belief, sex, gender reassignment or sexual orientation.
Check our Handelsbanken website for further information
At Handelsbanken, we deeply value our unique culture and values including trust in and respect for each individual. We take pride in nurturing a work environment where people flourish, and where they are empowered to take decisions in their areas of expertise. We take a long term perspective in everything we do and want each employee who joins us to build a long terms successful career with the Bank.
Application next steps
Your journey with us begins once you have submitted your application. One of our Handelsbanken recruiters will be reviewing your details and will later organise a phone conversation if you match the role requirements. If there is a mutual fit, we will extend an invitation for you to participate in an interview.
How can we support you to be your best self? Our Talent Acquisition team will be happy to provide support e.g. if you need additional time to prepare for an interview or you have any requirements for any part of the interview/hiring process – just let us know by email uk_talent@careers.handelsbanken.co.uk.
This advert will be live for a minimum of two weeks. However, please note that after the two weeks, the closing date could change at any time depending on the number of responses received.
#LI-BH1 #LI-Hybrid