SQL Analyst

Company Description

At Neilson, we’re dedicated to helping families secure financial protection for their loved ones with a range of life insurance options. 

Neilson is a leading provider of innovative, simple and great-value direct life insurance products. You may have come across some of our brands such as British Seniors and Smart Insurance.

We have evolved from our origins in the UK, where the business was launched in 2012, to become an award-winning international operation and leader in the global life insurance market. Today, we have offices in the UK, USA, Canada, Ireland, and Australia.

Job Description

Location: Windsor

Work pattern: Hybrid (3 days in office, 2 from home)

Unfortunately we cannot offer sponsorship for this position.

We are seeking a highly skilled and motivated SQL Analyst Developer to join our Business Intelligence Solutions team.

This team is responsible for

• maintaining and enhancing the business’s lead management and CRM capabilities
• providing BI analysts with accurate and relevant application data
• leveraging business insights and predictive models developed by the BI team into self-optimising, productionised systems within the wider business.

The ideal candidate will be responsible for developing and maintaining SQL queries, procedures, and scripts to extract complex datasets needed for our business intelligence and reporting needs. Additionally, the candidate will support the development of production-level performant code for the organisation’s various CRM and lead-management applications and systems.

Key Responsibilities:

1. Data Extraction and Transformation:

   - Design and develop complex SQL queries, stored procedures, and scripts for efficient data extraction and transformation.

   - Collaborate with cross-functional teams to understand data requirements and ensure accurate and timely delivery of BI solutions.

2. Business Intelligence:

   - Work closely with business analysts and stakeholders to gather BI requirements and translate them into technical specifications.

   - Development and maintenance of complex datasets needed for reports, dashboards, and visualizations using BI tools such as Power BI or similar

3. Production Code Development:

   - Work closely with IT Teams that are making changes to production systems for lead management and CRM applications and systems, to leverage BI models and insights, and ensuring scalability, performance, and reliability.

   - Collaborate with software developers to integrate SQL components seamlessly into applications.

Qualifications

Qualifications:

- Bachelor's degree in Computer Science, Information Systems, or a related field strongly preferred.

- Proven experience as a SQL Developer Analyst with a focus on BI and production-level code.

Preferred Skills:

- Strong proficiency in SQL, T-SQL, and experience working with relational databases (e.g., SQL Server, Oracle, MySQL).

- Excellent problem-solving skills and attention to detail.

- Strong communication and collaboration skills.

- Knowledge of data modeling and database design principles.

- Familiarity with cloud platforms (e.g., AWS, Azure).

- Programming skills in languages such as Python or Java.

If you are a self-motivated individual with a passion for data and code, and you thrive in a dynamic and collaborative environment, we invite you to apply for this exciting opportunity to contribute to our Business Intelligence and development initiatives.