Senior Data Warehouse & BI Developer

Cynet systems Inc; Richmond; On-site; GBP 60,000 - 80,000; Full time

Job summary

A technology solutions provider in the United Kingdom is looking for an experienced SQL Developer/Tester to join their Investment Decision Support team. The role involves SQL development support, performance tuning, and documentation for quarterly projects. Candidates should have 5+ years of SQL database experience and 3+ years in QA/testing, alongside strong communication skills. Additionally, familiarity with SQL Server Integration Services and automation tools like Power Automate is preferred. This position offers a dynamic work environment with opportunities for growth.

Qualifications

• 5+ years of experience in SQL database development and programming.
• 3+ years in a QA/testing role.
• Experience writing technical documentation.

Responsibilities

• Provide SQL development support including stored procedures creation.
• Review existing SQL queries for performance enhancements.
• Develop test plans and thoroughly test reports.

Skills

SQL database development

QA/testing

SQL Server Integration Services

Technical documentation

Excellent communication

Teamwork

Independence

Tools

Power Automate

Job description

Job Description

• The Investment Decision Support team is seeking an experienced SQL Developer/Tester with strong database, programming, and analytical skills to actively participate in the following scope of work:
• Assist with overall SQL Support (development, performance tuning, testing, documentation) related to quarterly projects and other efforts as needed. Activities may include:
• Development - SQL Development support to include creation of stored procedures or underlying queries. Provide support in the design, development, and implementation of ETL packages with SQL Server Integration Services (SSIS).
• Performance Tuning - Review existing SQL Queries, Execution Plans, etc. to determine performance enhancements for long running queries.
• Data Manipulation - Provide alternative options to existing data manipulation techniques. Examples would be converting Excel manipulation activities into SSIS packages that reduce process/cycle time of data preparation.
• SQL Development Processes - Review existing development processes and provide recommendations on how to enhance core development activities (i.e., Code Promotion, Code Reviews).
• Testing – Develop test plans and cases and thoroughly test reports and workflows.

Required Skills

• 5+ years of experience in SQL database development and programming
• 3+ years in a QA/testing role.
• Experience with SQL Server Integration Services.
• Experience writing technical documentation (requirements, process maps, etc.).
• Excellent communicator and ability to produce clear and concise documentation.
• Demonstrated experience working in a team environment.
• Demonstrated experience working independently with only high-level guidance.
• Additional Preferred Skills.
• Experience with automation tools such as Power Automate.
• Experience with data governance best practices/procedures.
• Investment/financial market industry experience.