SQL Developer

UST; Greater London; On-site; GBP 65,000 - 90,000; Full time

Job summary

UST seeks an experienced Senior Data / Reporting Developer to join a financial-services tech team. You will design data models, develop ETL pipelines with SSIS, and support Seismic reporting platforms. You will optimize complex SQL queries and ensure data quality across multiple sources.

The role involves collaboration with business and technical teams to translate requirements into scalable solutions and to support testing, deployment, and documentation across environments.

Qualifications

• Experience with SQL Server based ETL and data modelling.
• Proficient in SSIS and enterprise data integration.
• Knowledge of data warehousing concepts and reporting architectures.
• Experience with Seismic or comparable enterprise reporting tools.

Responsibilities

• Design, develop and maintain data models for reporting and analytics.
• Develop robust ETL processes using SSIS.
• Write complex SQL queries, stored procedures and transformations.
• Develop data pipelines feeding Seismic or similar tools.
• Analyze and optimize existing reporting solutions for performance.
• Collaborate with business and technical teams to translate data requirements.
• Map, transform and reconcile data across source systems.
• Ensure data quality and resolve data issues; troubleshoot production problems.
• Support testing, deployment and release activities; produce technical docs.
• Work with onsite and offshore technology teams.

Skills

SSIS & ETL

SQL queries

Data modelling

Data warehousing

Performance tuning

Agile delivery

Data quality

Seismic experience

BI reporting

Tools

Seismic

Job description

We are looking for an experienced Senior Data / Reporting Developer to join a financial-services technology team responsible for data modelling, ETL and reporting solutions supporting Seismic and similar reporting platforms. The role requires strong hands-on technical expertise in SQL, SSIS, ETL and data modelling, together with experience developing and supporting enterprise reporting solutions.

Responsibilities

• Design, develop and maintain data models supporting reporting and analytics requirements.
• Develop robust ETL processes using SQL Server Integration Services (SSIS).
• Write complex and optimized SQL queries, stored procedures and data transformation logic.
• Develop and maintain data pipelines feeding Seismic and/or similar reporting tools.
• Analyze existing reporting solutions and identify opportunities for optimization and automation.
• Work with business and reporting teams to understand data requirements and translate them into technical solutions.
• Perform data mapping, transformation and reconciliation across multiple source systems.
• Ensure data quality, accuracy, completeness and consistency across reporting outputs.
• Troubleshoot production issues and provide root-cause analysis and permanent fixes.
• Support testing, deployment and release activities across development and production environments.
• Produce technical documentation covering data models, ETL processes and reporting interfaces.
• Work collaboratively with onsite and offshore technology teams.

Required Skills

Essential Technical Skills

• Strong hands-on experience with SSIS and ETL development.
• Solid understanding of relational database design and data modelling.
• Experience designing and implementing data transformation and integration processes.
• Experience with enterprise reporting tools/platforms, preferably Seismic or comparable products.
• Ability to analyze complex datasets and troubleshoot data-quality issues.
• Good understanding of data warehousing concepts and reporting architectures.
• Experience with performance tuning of SQL queries and ETL processes.
• Strong software-development lifecycle and Agile delivery experience.
• Previous Seismic experience.
• Experience with other enterprise reporting platforms comparable to Seismic.
• Knowledge of financial-services data and reporting standards.