SQL Developer

Overview:

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

This team is responsible for

• and enhancing the business’s lead management and CRM capabilities
• BI analysts with accurate and relevant application data
• 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 data pipelines and queries to extract complex datasets needed for our business intelligence and reporting needs.

Additionally, the candidate will be involved in writing production-level code to support the organisation’s various CRM and lead-management applications and systems.

Key Responsibilities:

1. Data Extraction and Transformation:

- Design and develop data pipelines and queries, 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:

- Write and maintain production-level code to support lead management and CRM applications and systems, ensuring scalability, performance, and reliability.

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

4. Performance Tuning and Support:

- Monitor and optimize database performance, identifying and resolving bottlenecks and inefficiencies.

- Conduct regular reviews of SQL code and queries for performance improvements

Qualifications:

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

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

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

- Knowledge of software development best practices and ability to write production-level performant SQL code.

- Excellent problem-solving skills and attention to detail.

- Strong communication and collaboration skills.

- Must be happy to commute to our head office in Windsor, Berkshire at least once a week.

Preferred Skills:

- Knowledge of data modeling and database design principles.

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

- Programming skills in languages such as C# or Python

- Experience with version control systems (e.g., Git).

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.