About this role
We are looking for an MS SQL Engineer to join our team and design, develop and maintain data solutions on an on-premises Microsoft SQL Server environment. The role focuses on SQL development and SSIS-based ETL processes that support critical business operations.
You will work closely with data, development and business teams to ensure reliable, well-performing and well-documented data pipelines. The position is open to both medior and senior engineers.
Key Responsibilities
- Design, develop and maintain SSIS packages and ETL processes
- Write and optimise T-SQL code, including stored procedures, functions, views and triggers
- Monitor, troubleshoot and tune the performance of SQL Server databases and ETL jobs
- Design and maintain data models and database structures
- Ensure data quality, integrity and consistency across systems
- Schedule, deploy and support ETL jobs in an on-premises environment
- Analyse and resolve production issues and perform root cause analysis
- Collaborate with developers, analysts and business stakeholders to gather and refine requirements
- Document solutions and contribute to best practices and code reviews
Requirements
-
Minimum 3 years of professional experience as an MS SQL / ETL Engineer or Developer (5+ years for senior level)
-
Strong hands-on experience with Microsoft SQL Server and T-SQL
-
Solid experience designing and developing SSIS packages
-
Experience with query optimisation and performance tuning
-
Good understanding of ETL principles, data warehousing and data modelling
-
Experience working in on-premises environments
-
Familiarity with version control and deployment practices for database and ETL code
-
Strong analytical thinking and problem-solving skills
-
Excellent debugging and troubleshooting abilities
-
Strong attention to detail and a structured way of working
-
Good communication and teamwork skills
-
Nice to Have
-
Experience with SSRS and/or SSAS
-
Experience with SQL Server Agent and job scheduling
-
Experience with CI/CD for database and ETL deployments
-
Experience in the financial services sector
-
Microsoft certifications in data or SQL Server
-
You will be a great candidate for us if you
-
Enjoy working with data and take pride in reliable, high-quality solutions
-
Take ownership of your work from development to production
-
Have a proactive approach to identifying and resolving performance and data issues
-
Are comfortable working in Agile environments
-
Enjoy collaborating with colleagues from both technical and business teams
Benefits
-
Why join inventYOU
-
Work on challenging, data-intensive enterprise projects
-
Use and deepen your expertise in the Microsoft data stack
-
Collaborate with experienced engineering and data professionals
-
Contribute to improving data engineering practices and standards
-
Continue developing your career as a SQL and ETL specialist