VP-level Data Warehouse Python Developer at SMBC Bank in Dublin: enhancing, supporting, and modernising the Enterprise Data Warehouse that powers regulatory, finance, and risk reporting — building cloud ETL/ELT with Azure Databricks, Microsoft Fabric, SQL Server, and Python while migrating from on-prem SQL DWH to a Lakehouse, plus production support and on-call.
Compensation
€65K–€121K / yr
Location
Dublin, Ireland
Work setup
Hybrid
Seniority
Not specified
Employment
Not specified
Experience
Not specified
Category
Software engineering
Posted
Skills
agile
analytics
automation
azure
azure-data-factory
ci-cd
cloud
cloud-native
data-engineering
data-governance
data-modeling
data-quality
data-science
data-warehousing
databricks
devops
elt
etl
lakehouse
microsoft-fabric
powerbi
python
sql
sql-server
stakeholder-management
workflow-orchestration
Must have
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
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
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
Nice to have
Experience with Power BI and enterprise analytics platforms
Experience with Azure Data Factory
Microsoft Fabric, Azure, Databricks, or related cloud certifications
Degree educated in Computer Science, Software Engineering, Information Systems, Data Science, or related technical discipline
Postgraduate qualification in a relevant technology discipline
Full 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:
Python Developer at Sumitomo Group (Dublin, Ireland) — aijobsearch
Ability to balance project delivery, production support, and strategic initiatives
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