Python Developer

Sumitomo Group; Dublin; Hybrid; EUR 65,000 - 121,000; Full time

Benefits offered by this job

Hybrid working

Private medical insurance

Learning and development opportunities

Pension provision

Job summary

SMBC Group in Ireland seeks a hands-on VP Data Warehouse Python Developer to enhance and modernise its Enterprise Data Warehouse. You will work with Azure Databricks, Microsoft Fabric, SQL Server and Python, moving from on-premise SQL DWH to a cloud-native Lakehouse architecture.

You will collaborate with stakeholders, analysts, and engineers to deliver scalable data platforms, participate in Agile deliveries, and own operational excellence.

Qualifications

• 10+ years of Data Warehouse development experience.
• Proven track record with SQL Server and data models.
• Hands-on Python development for data engineering.
• Experience migrating on-prem to cloud Lakehouse.
• Strong communication and stakeholder management.

Responsibilities

• Design, develop, and support enterprise data solutions with Azure Databricks and Fabric.
• Build and optimize cloud ETL/ELT pipelines and data integration.
• Develop and maintain SQL Server databases and procedures.
• Create Python-based data engineering, automation, and monitoring solutions.
• Drive modernisation of Data Warehouse to a cloud-native Lakehouse.
• Implement Medallion data models (Bronze-Silver-Gold).
• Manage AutoSys job schedules and orchestrations.
• Provide production support and resolve incidents.

Skills

Analytical thinking

Problem solving

Communication

Stakeholder management

Teamwork

Ownership

Agile delivery

Education

Bachelor's degree in Computer Science

Postgraduate qualification in a related tech

Tools

Azure Databricks

Microsoft Fabric

SQL Server

Python

Power BI

Azure Data Factory

AutoSys

Job description

Select how often (in days) to receive an alert:

United by a sense of purpose towards our customers – to be a trusted partner for the long-term – and our universal banking platform in EMEA, SMBC Group has an international growth agenda and award-winning products, meaning we provide exciting opportunities to work on a diverse range of projects and initiatives. We deliver a full suite of corporate finance products and solutions to our customers as well as investment banking and advisory services, and a range of innovative solutions in global capital markets. Read on to find out how you could enhance your skills and gain valuable experience, by joining us to support our clients transition to a sustainable future.

Role Summary

The role is for a hands-on VP Data Warehouse Python Developer within the Data Warehouse team.
The individual will be responsible for the enhancement, optimisation, support, and modernisation of the Enterprise Data Warehouse platform. The role will focus on designing and delivering cloud-based data solutions using Azure Databricks, Microsoft Fabric, SQL Server, and Python while supporting the migration of the existing on-premise SQL DWH to a modern cloud-based Lakehouse architecture.
The role includes responsibility for production support, operational stability, automation, and continuous improvement of business-critical data platforms.

The Enterprise Data Warehouse supports critical regulatory, finance, risk, operational, and management reporting requirements across the organisation.

The successful candidate will work closely with business stakeholders, business analysts, developers, infrastructure teams, and support teams to deliver scalable and reliable data solutions. The individual will be expected to actively participate in Agile delivery activities, production support, modernisation initiatives, and cloud transformation programmes.

The role requires a strong technical background combined with the ability to understand business requirements and translate them into robust technical solutions.

Key interfaces will include:

Data Warehouse Development Team

Business Stakeholders

Business Analysts

Infrastructure and Cloud Engineering Teams

Production Support Teams

DBA Teams

Architecture and Security Teams

Risk, Finance, Operations, and Regulatory Reporting Functions

The role supports enterprise-wide data platforms and services that are critical to business operations and regulatory reporting

The successful candidate will:

Design, develop, and support enterprise data solutions using Azure Databricks and Microsoft Fabric.

Build, enhance, and optimise cloud-based ETL/ELT pipelines and data integration processes.

Develop and maintain SQL Server databases, stored procedures, views, and performance-tuned solutions.

Develop Python-based solutions for data engineering, automation, monitoring, orchestration, and data quality management.

Drive the modernisation of the Enterprise Data Warehouse from traditional SQL Server-based architecture to a cloud-native Lakehouse architecture.

Implement and support Medallion (Bronze, Silver, Gold) data models and best practices.

Design, maintain, and support AutoSys job schedules, JIL scripting, workflow orchestration, and automation solutions.

Participate in production support and on-call support activities for business-critical systems.

Investigate, troubleshoot, and resolve production incidents and performance issues.

Continuously improve operational processes, automation, monitoring, and platform performance.

Collaborate with business users and technical teams to deliver scalable, resilient, and secure data solutions.

Ensure adherence to data governance, security, audit, and operational standards.

Contribute to architectural decisions and strategic cloud transformation initiatives.

The anticipated salary range for this role is €65,000.00 – €121,000.00, with the final offer determined based on the candidate’s skills, experience, role scope, location, and relevant market factors. In addition to base salary, the role may be eligible for a discretionary incentive award and a competitive benefits package, including core benefits such as pension provision.

Experience

Education

Preferable degree educated in Computer Science, Software Engineering, Information Systems, Data Science, or a related technical discipline.

Postgraduate qualification in a relevant technology discipline is desirable.

Experience

Minimum 10 years' experience in Data Warehouse development and SQL Server development.

Proven track record delivering enterprise-scale Data Warehouse and data engineering solutions.

Extensive hands-on experience as a Data Warehouse Developer and Python Developer.

Experience supporting large-scale production environments and business-critical systems.

Demonstrable experience delivering Data Warehouse modernisation and cloud migration initiatives.

Technical Skills

Strong hands-on experience with Azure Databricks.

Strong experience designing and implementing solutions using Microsoft Fabric.

Advanced SQL Server and T-SQL development skills.

Strong Python programming and automation skills.

Strong cloud data engineering and data warehousing experience.

Experience designing and implementing Lakehouse architectures.

Experience with Medallion (Bronze, Silver, Gold) data models.

Experience with AutoSys workload automation, JIL scripting, job scheduling, and dependency management.

Strong experience in ETL/ELT design and development.

Strong data modelling and database design skills.

Experience troubleshooting and tuning complex SQL and data processing workloads.

Knowledge of CI/CD, DevOps, and automation best practices.

Experience within Financial Services, Banking, or Capital Markets.

Experience with Power BI and enterprise analytics platforms.

Experience with Azure Data Factory.

Microsoft Fabric, Azure, Databricks, or related cloud certifications.

Personal Skills

Strong analytical and problem-solving skills.

Excellent communication and stakeholder management skills.

Strong teamwork and collaboration skills.

Ability to work independently and take ownership of technical delivery.

Ability to balance project delivery, production support, and strategic initiatives.

The role requires balancing strategic cloud modernisation initiatives, project delivery, BAU development, production support, and operational improvements within a highly demanding and business-critical environment.

The individual must be capable of supporting legacy technologies while simultaneously driving the organisation's transition towards a modern cloud-based Data Warehouse and Lakehouse platform.

Customer Focus

Driving Change

Driving Results

Judgement and Decision Making

Strategic and Visionary

Trust and Integrity

What we offer

For all the expertise and experience you bring to help us make a difference, it’s only sustainable if we support you to build your career and be your best self so we offer competitive company benefits, centred around promoting positive well-bring and work-life balance. We also believe in fostering a diverse and inclusive work environment, where all team members perspectives and contributions are valued. Initiatives in place which promote a diverse and inclusive culture and healthy work life balance include hybrid working, Sport & Social Clubs and Diversity and Inclusion networks.

As an employee of SMBC you have access to a host of both useful and exciting benefit offerings. See below some of the benefits on offer to you:

• Hybrid and flexible working
• Competitive paid leave days
• Benefits to support your physical wellbeing, including private medical insurance and life and invalidity insurance
• Various policies to support your mental wellbeing, including a robust behavioural health network with counselling and coaching services
• Access a wide range of learning and development opportunities and career progression opportunities

About SMBC

A trusted partner for the long term
United by a sense of purpose towards our customers - to be a trusted partner for the long-term - and our universal banking platform in EMEA, we deliver a full suite of corporate finance products and solutions to our customers, including corporate, structured and trade finance, leveraged finance, loan market and treasury products. We can also provide investment banking and advisory services and a range of innovative solutions in global capital markets.
Find out more about what we do and who we are at https://www.smbcgroup.com/emea/careers