MI SQL Developer

Overview

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.

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
• 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

About 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.