Mid - Senior MS SQL Engineer - ETL & Data Integration

InventYOU AB; Ohio; On-site; USD 90,000 - 140,000; Full time

Job summary

inventYOU is seeking an MS SQL Engineer to design, develop and maintain data solutions on an on-premises Microsoft SQL Server environment. The role emphasizes SQL development and SSIS-based ETL processes that support critical business operations.

You will collaborate with data, development and business teams to ensure reliable, well-performing data pipelines, with opportunities to contribute to best practices and code reviews. The position welcomes medior and senior engineers.

Qualifications

• 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

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

Skills

SQL Server

T-SQL

SSIS

ETL

Data Modeling

Performance Tuning

On-Premises

Version Control

Analytical Thinking

Teamwork

Tools

SSIS Packages

SQL Server Management Studio

Job description

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

• 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

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