Senior Database Developer

 
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

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: 

Database Management & Development: 

• 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 

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!