MI SQL Developer

As an MI SQL Developer at Ventrica, within our MI & Data function you will perform a key role in maintaining and enhancing the accuracy and efficiency of both our in-house and client reporting solutions. This position requires expertise in SQL development, ETL processes, Power BI development and data warehousing.

In this role you will undertake a wide variety of tasks which includes, data loading and ETL, writing queries/stored procedures tables and producing reports and creating workflows.

Please note, this role is a 6 month fixed term contract. 

Primary responsibilities include:

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