Sr. Data Engineer – Data Modeler

Job Title

Sr. Data Engineer – Data Modeler

Job Description

IG Group opportunity

Role title: Sr. Data Engineer – Data Modeler

So who are we?

Hello, we’re IG Group. A leading FinTech who provides trading services to clients across 18 countries!

LEADING THE FIELD THINKING BIGGER

We’re a global FTSE 250-listed company made up of a collection of progressive fintech brands in the world of online trading and investing. The best part? We’ve snapped up many awards for our top-class platforms, forward-thinking products, and incredible employee experiences.

We believe in financial freedom. And our purpose is to help ambitious people achieve it. Around 400,000 people use our groundbreaking technology and forward-thinking platforms to trade the financial products they know and love.

Did we mention we have offices in 18 countries? Yes, when you join IG Group, you'll have the chance to work across multiple brands with people all over the world. We work in cross-functional teams, focused on delivering at pace to improve the experience of traders on our platforms. Join us for an exciting future and let’s innovate together!

What you’ll do

• The broad scope of responsibility of this role requires a solid experience and understanding of data models, data analysis, data management, and programming languages to develop, analyse, and maintain data models. This role involves working closely with data architects, business analysts, and data consumers to ensure that data models meet business requirements and are aligned with industry best practices. You will:

• Create and implement logical and physical data models that support structured and unstructured data across RDBMS and big data platforms.

• Design and implement semantic data models that optimise data accessibility, performance, and usability for Business Intelligence (BI) and analytics.

• Create and maintain documentation of data models, including entity-relationship diagrams (ERDs), data flow diagrams (DFDs), and data dictionaries to ensure clarity and alignment across teams.

• Develop and maintain metadata repositories and data lineage documentation to track data transformations and dependencies.

• Work closely with business analysts, data engineers, and data consumers to gather requirements and translate business needs into data models.

• Own the Model governance for any changes to the model from users.

• Partner with data architects to ensure data models conform to the data strategy and best practices in data management and integration. Work with Architecture teams to expand the existing models.

• Conduct regular data model reviews to incorporate changes in data platforms, evolving business requirements, and performance optimisations.

• Ensure all data models comply with data quality, security, and governance standards.

• Analyse data lineage from source systems to the final semantic layer, identifying transformation rules and their impact on the physical data model.

• Create data models that support migrations, conversions, and transformations as data platforms evolve and new standards are defined.

Who we’re looking for?

While there are many profiles of people who work at IG – across all roles, we’re looking for a few common traits:

•  You are curious about our product and the technology that sits behind it;

•  You care about our clients, and you are hungry to improve their user experience;

•   You are impatient about driving change and willing to deliver at pace;

•   You are not afraid of the complexity of financial regulation and want to learn & grow your expertise; and

•  You are a creative problem solver capable of innovating and thinking big.

We don’t fit the corporate stereotype. If you want to work for a traditional, suit-and-tie corporate, we might not be for you. But, if you have that IG Group energy and you can stand behind what we believe in, join us in raising the bar for our customers and across the trading industry.

What you’ll need for this role

• 7 -10 years of experience as a Data Modeler or in a similar role, with expertise in data modelling principles (conceptual, logical, and physical).

• 5+ years of hands-on experience in data modelling, databases, and data analysis.

• Strong understanding of data modelling concepts, including normalization, denormalization, dimensional modelling, and Data Vault 2.0 methodology (certification or hands-on experience preferred).

• Proficiency in data modelling tools such as ER/Studio, ERwin, SQLDBMS, or Sparx Systems.

• Hands-on experience with relational databases (RDBMS) such as PostgreSQL, Oracle, SQL Server, MySQL and data warehousing solutions.

• Knowledge of data integration, ETL/ELT workflows, and data migration.

• Experience in Semantic Data Modelling, including Business Intelligence layer data modelling and familiarity with data visualization tools.

• Strong understanding of database management systems (DBMS), SQL, and query optimisation.

• Familiarity with programming languages like SQL, Python, and a strong understanding of data warehousing and ETL techniques.

• Experience in metadata management, data privacy standards, and compliance.

• Expert knowledge of cloud-based data platforms (AWS, Azure, or GCP) and data Lakehouse architectures (Medallion architecture, Delta Lake, Snowflake, or Databricks).

How you’ll grow

When you join IG Group, we want you to have more than a job – we want you to have a career. And you can. If you spot an opportunity, we want you to chase it. Stretch yourself, challenge your self-beliefs and go for the things you dream of. With internal and external learning opportunities, and the tools to help you skyrocket to success, we’ll support you all the way.

And these opportunities truly are endless because we have some bold targets. We plan to expand our global presence, increase revenue growth, and ultimately deliver the world’s best trading experience. We’d love to have you along for the ride.

The perks

It really is more than a job. We’ll recognize your talent and make sure that you can still have a life – at work, and outside of it. Networks, committees, awards, sports and social clubs, mentorships, volunteering opportunities, extra time off… the list goes on.

• Competitive salary & benefits plan

• 1 additional day off to celebrate your Birthday 😊   

• 2 additional days off a year for voluntary work

• Share Plans for Employees

• LinkedIn Learning platform free access

• Option to participate and create ESG initiatives based on IG Brighter Future Fund

• Employee Assistance Program

• We work in hybrid working model

How you’ll work

We follow a hybrid working model; we reckon it’s the best of both worlds.  This model also feeds into our secret ingredients for innovation: diversity, flexibility, and close connection. Plus, you’ll be welcomed into a diverse and inclusive workforce with a lot of creative energy.

Ask our employees what their favorite thing is about working at IG, and you’ll hear an echo of ‘our culture’! That’s because you can come to work as your authentic self. The things that make you, you – like your ethnicity, sexual orientation, faith, age, gender identity/expression or physical capacity – can bring a fresh perspective or new skill to our business.

That’s why we welcome people from various walks of life; and anyone who wants to help us realize our vision and strategy by delivering at pace and championing the client in everything we do.

We also think hard about our ways of working as a company. At IG Group, we’ve set out five behaviours that we expect everyone to strive to achieve in all that we do:

• Lead & Inspire: Leading teams in a way that drives trust, alignment, and enthusiasm;

• Think Big: We focus on the problems that most move the needle of commercial outcomes;

• Champion the client: We always keep the client's needs front of mind and deliver as much value for them in all that we do;

• Deliver at pace: We work to ensure nothing stands in the way of fast delivery of sustainable growth for our business; and

• Raise the bar: We raise the bar by taking ownership of outcomes and being accountable for making things better all across IG.

Number of openings

1