Job Title

Senior Database Developer

Job Description

So, who are we

Hello, we're IG Group. We are a publicly-traded FTSE250 FinTech company who run mobile, web and desktop platforms that help our clients trade stocks & shares, leveraged products, Futures & Options and Crypto.

We are ambitious. Over 340,000 people already use our platforms. We're global with offices in 18 countries and products in 16 regions. We're hungry to move faster, ship better product for our customers and grow our user base. We believe in high autonomy, and we want people who are looking to do things differently in order to create better experiences for our customers.

We work in cross-functional teams and are laser focused on increasing the number of active clients we serve to drive sustainable growth.

Your Team

Database Management & Development

The Database Development team operates within the Data Platform department and serves as the organization's centre of excellence for all database-related initiatives. The team's core responsibilities encompass:

Design, development, and implementation of database solutions across the enterprise
Management of schema changes, stored procedures, packages, and database objects
Performance tuning and optimization of database queries and processes
Ongoing maintenance and support for production database environments across multiple platforms (Oracle, SQL Server, PostgreSQL, etc.)

Data Engineering & Pipeline Management

Building and maintaining robust data pipelines in cloud environments (AWS, GCP)
Developing ETL/ELT processes to support data warehouse and analytics requirements
Managing data integration workflows between source systems and target platforms
Ensuring data quality, integrity, and governance across all data movement processes

Team Structure & Collaboration

Works closely with Database development, Datawarehouse, Data Engineering, Business Intelligence, and Infrastructure teams
Provides technical consultation and expertise to business stakeholders
Supports regulatory reporting and compliance requirements through reliable data delivery
Participates in incident management and provides 24/7 production support coverage

The team plays a critical role in enabling data-driven decision-making across the organization while maintaining the highest standards of data security, availability, and performance.

Your role in the Team's Success

Role

As a key member of the Database Development team, you will play a pivotal role in driving our data platform capabilities forward. Your contributions will directly impact:

Technical Excellence: Bringing your expertise in database design and development to deliver high-quality, scalable solutions that meet evolving business needs
Innovation & Modernization: Contributing to our cloud migration initiatives and helping adopt modern data engineering practices and technologies
Reliability & Performance: Ensuring critical data systems remain highly available and performant, supporting mission-critical business operations
Knowledge Sharing: Mentoring team members, documenting best practices, and fostering a culture of continuous improvement
Cross-functional Impact: Collaborating with stakeholders across the organization to translate business requirements into robust technical solutions
Operational Excellence: Participating in production support rotations and incident resolution, maintaining the stability and integrity of our data ecosystem

Your technical skills, problem-solving abilities, and collaborative mindset will be essential in helping us achieve our goals of delivering world-class data services while maintaining the highest standards of quality and reliability.

What you'll do

Core Development Responsibilities

Requirements Analysis & Design: Collaborate with Technical Leads and Technical Specialists to analyse technical requirements and translate them into detailed low-level designs and implementation plans
End-to-End Data Development: Create comprehensive source-to-target column mappings, develop business logic transformation rules, and convert requirements into production-ready technical code
Code Development & Quality: Write high-quality, maintainable PLSQL stored procedures, packages, functions, collections, and triggers that meet enterprise coding standards and best practices
Testing & Quality Assurance: Develop robust unit test cases, perform thorough code reviews, and coordinate closely with QA teams throughout all testing phases to ensure defect-free deliveries
Data Pipeline Development: Build and maintain ETL/ELT processes for data extraction, transformation, and loading across multiple source systems and cloud platforms

Performance & Optimization

Query Performance Tuning: Work with the Data Services team to identify and resolve database performance bottlenecks, optimize SQL queries, and improve overall system efficiency
Data Lifecycle Management: Contribute to data archival strategies, partition management, and storage optimization initiatives to maintain optimal database performance
Monitoring & Proactive Maintenance: Implement monitoring solutions and proactive maintenance procedures to prevent issues before they impact production systems

Cloud & Modernization Initiatives

Cloud Migration Support: Participate in ongoing cloud migration projects from on-premises to GCP, helping modernize data infrastructure and adopt cloud-native technologies
Automation Development: Leverage Python scripting to automate repetitive tasks, improve operational efficiency, and reduce manual intervention in data processes
Technology Innovation: Stay current with emerging technologies and contribute ideas for improving development practices, tooling, and architectural patterns

Production Support & Collaboration

Production Support: Provide level 2/3 production support during business hours and participate in on-call rotation for after-hours support when critical issues arise (approximately 20% of role)
Incident Management: Participate in incident response, root cause analysis, and implementation of permanent fixes to prevent recurrence
Cross-Team Collaboration: Work closely with Data Engineering, Business Intelligence, Infrastructure, and business stakeholder teams in a fast-paced, agile environment
Regulatory Compliance Support: Contribute to regulatory reporting initiatives and ensure data solutions meet financial services compliance requirements (MiFID, EMIR, ASIC, etc.)
Continuous Improvement: Collaborate with Technical Specialists to identify process improvements, enhance ways of working, and mentor junior team members

Work Model: This role operates on an 80% development / 20% support split, with occasional out-of-hours support requirements for critical production issues.

What We're Looking For

Required Technical Skills:

Database Expertise: 5+ years of hands-on experience with Oracle Database (11g/12c/19c), including advanced SQL, PLSQL development, performance tuning, and optimization
Programming Proficiency:
Expert-level PLSQL coding skills (stored procedures, packages, functions, collections, triggers, dynamic SQL)
Strong Python scripting capabilities for automation and data processing
Solid Unix/Linux shell scripting experience
SQL Mastery: Advanced SQL query writing and optimization skills, including complex joins, analytical functions, partitioning strategies, and execution plan analysis
Data Warehousing Knowledge: Strong understanding of Data Warehouse architecture, dimensional modelling, star/snowflake schemas, and BI concepts
ETL/ELT Processes: Proven experience designing and implementing ETL/ELT workflows, data transformation logic, and data integration patterns
Development Practices: Strong unit testing skills, code versioning (Git), and adherence to coding standards and best practices

Highly Desirable Skills

Cloud Technologies (GCP): Experience with Google Cloud Platform services including BigQuery, Cloud Storage, Dataflow, Pub/Sub, Cloud Composer, and Looker
Additional Cloud Platforms: Familiarity with AWS services (Redshift, S3, Glue, Lambda) and multi-cloud architectures
BI Tools: OBIEE 11g/12c experience, including RPD development, dashboard creation, and report building
Modern Data Stack: Exposure to streaming technologies (Apache Kafka, Pub/Sub), containerization (Docker), and infrastructure as code (Terraform)
Programming Languages: Core Java knowledge for enterprise application integration
Financial Services Background: Previous experience in banking, trading, or financial services sectors with understanding of regulatory requirements
Agile Methodologies: Practical experience working in Agile/Scrum environments with sprint planning, daily standups, and iterative delivery

Personal Attributes

Self-Starter: Ability to work independently with minimal supervision while delivering high-quality results on time
Problem Solver: Strong analytical and troubleshooting skills with attention to detail
Team Player: Collaborative mindset with excellent communication skills and ability to work effectively in cross-functional teams
Adaptable: Comfortable working in a fast-paced environment with changing priorities and tight deadlines
Continuous Learner: Genuine enthusiasm for learning new technologies, tools, and methodologies
Quality-Focused: Commitment to delivering production-ready, maintainable code that meets enterprise standards
Flexible: Open to working in a development-heavy role (80%) with support responsibilities (20%), including occasional after-hours support for critical production issues

How We Work

We try to take a thoughtful approach to our ways of working as a company. We follow a hybrid working model with 3 days in the office which we think balances the need to collaborate effectively and connect with each other. When it comes to how we deliver, there are 5 things we want everyone to do to drive high performance, better learning and career satisfaction:

Lead and Inspire: Drives trust, alignment, and enthusiasm
Think Big: Focus on the problems that most impact commercial outcomes
Champion the client: Understand and prioritise client's needs
Deliver at pace: Push for fast, sustainable growth;
Raise the bar: Take ownership, be accountable and share feedback

We believe that diversity is vital to success, it fuels creativity, drives innovation and sets us up for global success. We're committed to building teams with a variety of perspectives and skills to help us realise our vision and strategy, that's why we encourage applications from people with diverse backgrounds and experiences to join us on this journey. Learn more about our D&I approach here.

The Perks

Your growth fuels our success! Thrive with tailored development programs, mentoring opportunities with leaders, and clear career progression. Expand your network through committees, sports and social clubs. Enjoy extra time off for volunteering and community work.

Matched giving for your fundraising activity
Flexible working hours and work-from-home opportunities
Performance-related bonuses
Insurance and medical plans
Career-focused technical and leadership training in-class and online, incl. unlimited access to LinkedIn Learning platform
Contribution to gym memberships and more
Free Lunch/Snacks/Fruits
A day off on your birthday
Two days volunteering leave per year.

Learn more about the Perks here!

Join us for this exciting journey.

Apply now!

Number of openings

1

Senior Database Developer

IT Analyst Applications (Database Developer with Administrator experience)

Senior Database Developer

Sr. Database Developer

Senior Database Developer

Sr. SQL Developer & Database Architect (MS SQL Server)