Data & Analytics Developer (ETL / BI / SQL / Cloud)

Stott and May; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A technology consulting firm is looking for an experienced Data & Analytics Developer to enhance ETL/ELT processes and data solutions in a fast-paced Agile environment. You will be responsible for developing dashboards and ensuring compliance with data policies. Strong expertise in SQL Server, cloud platforms, and data warehousing methodologies is essential. The role offers competitive daily rates and requires working on-site once a week in Central London.

Qualifications

• Strong experience in ETL/ELT development and data warehousing.
• Deep knowledge of star schema design and BI methodologies.
• Expertise with SQL Server, Azure, Oracle technologies.

Responsibilities

• Develop and maintain ETL/ELT processes, dashboards, and reporting tools.
• Participate in unit and regression testing to ensure code quality.
• Collaborate with Scrum team to meet delivery timelines.

Skills

ETL/ELT development

Data warehousing

BI methodologies

Complex SQL queries

Performance tuning

Data privacy compliance

Tools

SQL Server 2008+

Oracle 11g/RAC

Azure

Job description

Data & Analytics Developer (ETL / BI / SQL / Cloud)

Start: ASAP (December)

Location: 1-day per week in Central London

Rate: £400 per day (OUTSIDE IR35)

Duration: 6 months (rolling)

About the Role

We are seeking an experienced Data & Analytics Developer to support the development and maintenance of high-quality technical data solutions that enable evidence-based business and operational decision-making. You will work within an Agile Scrum team, building and enhancing ETL/ELT processes, data pipelines, dashboards, and reporting solutions aligned with the organisation’s Data & Analytics strategy.

Key Responsibilities

• Data & Analytics Development
• Develop and maintain new and existing ETL/ELT processes, dashboards, reporting tools, and analytics applications.
• Deliver high-quality, reliable code that meets business requirements, design specifications, and audit/compliance standards.
• Produce clear technical design documentation in line with Data & Analytics standards.

Testing & Quality Assurance

• Support and participate in unit testing and regression testing to ensure code quality and readiness for system test environments.
• Fix defects, perform performance tuning, and optimise code as required.
• Take part in design walkthroughs and quality assurance sessions with the wider Analytics Development & Delivery team.

Agile Delivery

• Develop to agreed timelines, raising technical risks or delays to the Technical Delivery Manager.
• Collaborate with Scrum team members to ensure work is delivered efficiently and meets operational requirements.

Governance & Compliance

• Ensure all solutions adhere to data privacy, data protection, and access control policies.
• Guarantee that personal data is stored securely and anonymised where appropriate.

Stakeholder Collaboration

• Work closely with Business Analysis teams to understand requirements for reports, dashboards, and applications.
• Work closely with Technical Delivery Manager and Test teams to ensure alignment and successful delivery.
• Work closely with internal compliance teams to meet Data Protection, FOI, and data release policies.
• Work closely with external data partners (e.g., ticketing system vendors, train operating companies).
• Provide user access to data, offer advice on data usage, and deliver training where needed.

Essential Skills & Experience

• Strong experience in ETL/ELT development, data warehousing, BI methodologies, and handling structured/unstructured data.
• Deep knowledge of star schema design, Kimball, Inmon, or hybrid warehouse approaches.
• Expertise with on-premise, cloud, or hybrid Oracle and/or Microsoft data technologies, ideally including:
• SQL Server 2008+, T-SQL, SSIS, APS, Azure
• Oracle 11g/RAC, SQL, PL/SQL, ODI, OBIEE
• Expert in writing and reviewing complex SQL queries, performance tuning, and database monitoring.
• Knowledge of Agile delivery frameworks and SDLC methodologies.