MI SQL Developer

Ventrica; Southend-on-Sea; On-site; GBP 40,000 - 60,000; Full time

Job summary

A fast-growth customer management business in the UK is seeking an MI SQL Developer to own and develop reporting solutions. The ideal candidate will have expertise in SQL development, ETL processes, and Power BI. Responsibilities include ensuring data integrity, creating ETL workflows, and troubleshooting database issues. This role is a 6-month fixed-term contract offering an opportunity to contribute to innovative customer management solutions.

Qualifications

• Proficiency in SQL development using SSMS.
• Experience in leading SQL and ETL processes.
• Strong skills in Excel and data manipulation.
• Experience with complex queries and stored procedures.

Responsibilities

• Own and develop reporting solutions for in-house and clients.
• Ensure the accuracy, integrity, and security of data.
• Create ETL workflows for processing large datasets.
• Troubleshoot database performance issues.
• Design and deliver reports on big datasets.

Skills

SQL development

ETL processes

Power BI development

Data warehousing

Data manipulation

Troubleshooting

Job description

As our MI SQL Developer at Ventrica, operating within our MI & Data function you will own and develop both our in-house and client reporting solutions. This position requires expertise in SQL development, ETL processes, Power BI development and data warehousing, with a proven track record of leading these processes essential for this role. Please note this role is a 6 month fixed term contract.

Primary Responsibilities

• Standard SQL tasks such as table design, query creation, etc
• Ensuring the accuracy, integrity and security of data
• Creating ETL workflows to process large datasets, in a variety of formats
• Troubleshooting database performance issues
• Identify and resolve issues from complex stored procedures, optimise ETL workflows.
• Designing and delivering reports on big datasets
• Act as a SME in SQL Architecture
• Communicate effectively and professionally with end users and stakeholders, including finance teams, to ensure their requirements are fully understood and met.
• Follow industry-standard testing and change management procedures to safeguard data integrity.
• Share knowledge freely and help foster an environment where everyone can learn and innovate together.

Required Experience

• Previous experience as a T-SQL Developer
• Proficiency in SQL development (SSMS), advanced data modelling, and ETL workflows.
• Strong skills in Excel and data manipulation.
• Expertise in Power BI
• Experience of designing and implementing solutions which involve big datasets
• Experience in writing and troubleshooting complex queries, stored procedures, functions, etc
• Desired Experience
• Previous experience within the BPO industry.
• Experience with OLAP data cubes and administration.
• Cloud database technologies or Python skills would be beneficial
• Experience working on a web application would be desirable Experience with Azure technologies is beneficial
• Comfortable in a fast-paced environment where priorities shift.

Who are Ventrica?

Ventrica is a forward-thinking, fast-growth customer management business that partners with blue-chip brands to provide exceptional outsourced customer service. We don’t just meet customer expectations—we exceed them. We’re a company fuelled by passion for technology and customer service, boldness in how we innovate, and trust in the relationships we build with clients and customers alike, with a reputation for delivering intelligent, customer-centric solutions. As we continue to grow, we are looking for passionate individuals who can help shape the future with bold ideas and a commitment to excellence.