Data Engineer

Department: Software Development

Reports to: Head of Data Engineering

Fairstone Group Limited

We are a full-service wealth management house, delivering integration-led growth to emerge as a new

leader in the UK. We are a company embarking on an exciting journey of growth and transformation.

Technology is a key component of the business strategy, whose foundations are based on growth, digital

transformation, and providing a first-class service for both clients and colleagues.

Having recently relocated to a brand-new Head Office in Doxford International Business Park, we are

delighted to be able to collocate our technology and business teams under one modern roof. We are

passionate about people and collaboration; therefore, this role is office based with ad hoc flexibility as

required.

Job Description

We are looking for a passionate and innovative Data Engineer to join our new data team and play a key role

in transforming how data flows through our organisation. In this role, you will take the lead on all data

migrations from planning, designing, execution and data quality checks.

As a Data Engineer, you’ll collaborate with our M&A team, business leaders, and other technical experts to

ensure that every data migration is accurate, consistent, secure, and efficient. Your work will directly

contribute to the success of our business, helping us harness the power of data to fuel future decisions

and strategies.

This position offers the perfect opportunity for someone who thrives on solving complex data challenges

and has a passion for building high-performance, scalable data systems. If you’re looking to make an impact

while honing your expertise in cutting-edge data engineering practices, this is the role for you!

Key Responsibilities and Accountabilities

As an experienced Data Engineer, you’ll have the opportunity to be hands-on with exciting projects that will

directly impact the business. You'll take full ownership of key data migrations, making sure every step is

smooth, efficient, and successful. Here’s what you’ll be diving into:

Data Migration Planning: You’ll collaborate with stakeholders to understand the big picture and develop detailed, strategic data migration plans. You’ll take charge of migrating data from M&A into our proprietary Gateway SQL database.

Data Mapping & Transformation: Designing and implementing data mapping and transformation processes will be a major part of your role as you move data from legacy systems to modern platforms.

ETL (Extract, Transform, Load) Processes: You’ll build and optimise ETL scripts and tools to ensure seamless data flow—extracting from the source, transforming to meet business needs, and loading it into target systems.

Data Quality Assurance: Accuracy is key. You’ll perform validation checks to ensure that all data is correct and complete throughout the migration.

Troubleshooting: Got a knack for problem-solving? You’ll identify and fix issues like data corruption or system incompatibility to keep everything running smoothly.

Performance Optimization: Your role will include keeping an eye on the performance of migration processes, optimizing for speed and efficiency, and minimizing any downtime.

Documentation: You’ll document everything—your processes, procedures, and outcomes—so that the migration journey is clear and trackable.

Collaboration: You won’t be doing this alone! You’ll work alongside business analysts, DBAs, developers, and others to make sure every migration project is executed flawlessly.

Compliance and Security: With data at the core, you’ll ensure every migration aligns with data governance policies and security standards, staying compliant with regulations.

Post-Migration Support: Even after migration, you’ll play a critical role in optimizing system performance and resolving any issues that may arise.

CI/CD: As part of our endeavour towards creating production-grade software, you will be involved in DevOps activities such as version control and migration of code artefacts to live environments.

This role is perfect for someone who thrives in a fast-paced, collaborative environment and loves solving complex data challenges while ensuring everything runs smoothly behind the scenes.

Salary & Benefits

• £dependent on skills and experience
• Company pension scheme
• Death in service
• 25 days annual leave
• Flexible Benefits
• Birthday as an additional day off
• Opportunity to purchase additional holidays.
• Enhanced family friendly policies
• Cycle to work scheme.
• Opportunity to work with cutting-edge technologies in a dynamic and collaborative environment.
• Professional development and growth opportunities including Training and support towards industry recognised certifications
• This role is primarily office based with 1 day per week working from home

Job Requirements

• Proven experience (3+ years) in data migration, database management, or related roles.
• Hands-on experience with ETL tools (e.g., Data Bricks, Data Factory, SSIS)
• Experience with SQL, NoSQL, and various database technologies (e.g., MSSQL, MySQL).
• Experience migrating data across different platforms (e.g., cloud-based systems, on-premise databases).
• Strong proficiency in SQL and data manipulation.
• Familiarity with Azure cloud services and migration tools.
• Experience with scripting languages (e.g., Python, Shell scripting) for automation.
• Knowledge of data governance and data security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and interpersonal skills.
• Ability to manage multiple tasks in a fast-paced environment.

Desirable Skills/Experience

• Experience with large-scale data migration projects.
• Familiarity with data warehousing solutions and BI tools.
• Microsoft Azure Certifications
• Familiarity with data visualization tools like Power BI or Tableau.

Personal Profile

• Passionate about data and have a genuine interest and understand its power to drive business decisions. You are committed to ensuring data quality, accuracy, and availability.
• You have excellent analytical and problem-solving skills. You enjoy tackling complex data challenges and finding innovative solutions.
• You work well in a team environment and communicate effectively with both technical and non-technical stakeholders. You are open to feedback and value the perspectives of others.
• Enjoys autonomy and has the ability to work independently and is willing to take ownership of initiatives from inception to completion
• You have a keen eye for detail and ensure that data is accurate, consistent, and reliable. You understand the importance of data governance and compliance.
• Strong communication and collaboration skills, with the ability to work effectively in a team environment.
• You stay current with the latest industry trends and technologies. You are eager to learn and continuously improve your skills and knowledge.
• You take initiative and are highly self-motivated. You can manage your workload efficiently and meet deadlines without compromising on quality.
• You thrive in a fast-paced, dynamic environment. You are flexible and can adapt to changing priorities and requirements.
• You are always looking for ways to optimize and improve data processes and systems. You embrace new ideas and technologies to enhance data engineering practices.

This is more than just a role; it’s a chance to grow your career while playing a pivotal part in shaping our data landscape. If you’re ready to take on exciting challenges and lead our data initiatives, we want to hear from you!