Senior Data Engineer - SQL

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

About StarCompliance

StarCompliance is on a mission to make compliance simpleandeasy. Trusted globally by enterprise financial institutions, the user-friendly STAR platform empowers organizations to achieve regulatory compliance while safeguarding their integrityandbusiness reputations. Through a customizable, 360-degree view of employee activity, the STAR software enables firms to automate the detectionand resolution of potential areas of conflict while streamlining daily workflowsandincreasing efficiency.

• You will be responsible for enhancing our master data platform (RDM) to provide a consistent, quality internal product for all other product teams to utilise, providing data and search capability to thousands of users across hundreds of clients across the globe. As the RDM Developer you will be hands-on, continually contributing to the predominantly SQL codebase and investigating/solving data issues. Our platform is SQL Server in Azure with a web-services layer. We are looking for individuals who will challenge ideas in a respectful manner in the pursuit of a better outcome. It is expected you will be vocal in team meetings especially in refinement sessions and be able to demo work completed in reviews to stakeholders. You should be passionate and take pride in your work with the ability to use initiative to make sure tasks are progressed and workload is prioritised accordingly

• Responsibilities
• - Design and build scalable, efficient, and fault-tolerant data products using predominantly T-SQL on SQL Server in Azure and Azure DevOps.
• - Work closely with the rest of the members of the Data team to identify, refine and build solutions to enhance the Reference Data Master data platform in being truly enterprise-level
• - Continually contribute to the codebase and aid other engineers within the team by reviewing and advising/sharing best practices
• - Run spikes and POCs for new technical innovation when required and share back to the group
• - Ensure the platform remains secure, well-monitored and performant
• - Engage with stakeholders to understand requirements
• - Play a key role in Agile ceremonies with input into backlog refinement and estimations, as well as ownership of the tech-debt backlog
• Mandatory Skills, Knowledge or Experience
• - At least 3 years of experience in data engineering in a fast-paced, large-scale production environment
• - Demonstrable expert skills in SQL, including a knowledge of efficient and performant query design
• - Experience of programming/scripting languages (e.g. T-SQL / C# / PowerShell / Python)
• - Experience building production systems utilising cloud systems, with particular value in expertise with Microsoft Azure.
• - Uses coding best practices and understands data architecture patterns
• - Deep understanding/experience of ETL/ELT processes
• - Familiar with utilizing CI/CD processes (e.g. Azure DevOps) and Git-based code repositories
• - Familiar with building and executing automated unit-tests
• - Work in an Agile development environment
• - Excellent communication, collaboration, and problem-solving skills
• Desirable skills
• - Experience of data modelling
• - Experience defining, implementing or supporting software in financial services industry
• - Cloud certification in Azure is particularly desirable
• - Knowledge of data quality, data governance, and data security principles and practices
• - Experience of Mend/SonarQube

StarCompliance Background Checks

All positions require pre-employment screening due to employees potentially having access to highly sensitive and confidential information involving finance and compliance; candidates must be trustworthy and have a heightened sensitivity to protecting confidential financial, professional information. To be eligible for employment with StarCompliance, candidates must undergo a rigorous background investigation with checks including, but not limited to, criminal record history, consumer credit, employment history, qualifications, and education checks.

Equal Opportunity Employer Statement

We prohibit discrimination and harassment of any kind based on race, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, gender identity or expression, marital/civil union/domestic partnership status, veteran status or any other protected characteristic as outlined by country, state, or local laws.

This policy applies to all employment practices within our organisation, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. StarCompliance makes hiring decisions based solely on qualifications, merit, and business needs at the time. For more information, please request a copy of our Equal Opportunities Policy.