Lead II - Senior Data / Reporting Developer ( SSIS SQL)

UST; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

UST is seeking a Senior Data/Reporting Developer to design data models, develop ETL pipelines, and support Seismic reporting platforms. You will work closely with business analysts, product owners and technology teams to deliver robust, scalable data solutions.

The role requires strong SQL/SSIS skills, data modelling expertise, and experience across data warehouses. Collaboration across onsite/offshore teams is essential for delivering high-quality outputs.

Qualifications

• Experience with SQL Server and SSIS for enterprise data pipelines.
• Strong data modelling and ETL development experience.
• Experience with Seismic or comparable reporting platforms.
• Experience in Agile delivery and SDLC.

Responsibilities

• Design data models supporting reporting and analytics requirements.
• Develop and maintain ETL processes using SSIS.
• Write complex SQL queries, stored procedures and data transformation logic.
• Develop data pipelines feeding Seismic or similar tools.
• Analyse existing reporting solutions and identify optimisation opportunities.
• Collaborate with business analysts and stakeholders to translate data needs.

Skills

Data modelling

ETL development

SQL queries

Agile delivery

Data mapping

Data quality

Performance tuning

SDLC

Tools

SSIS

SQL Server

T-SQL

Seismic

Job description

Role Description

Senior Data / Reporting Developer responsible for data modelling, ETL and reporting solutions supporting Seismic and similar reporting platforms.

Role Description

Senior Data / Reporting Developer 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.

The successful candidate will work closely with business analysts, product owners, reporting teams and other technology stakeholders to deliver robust, scalable and high-quality data solutions.

Key 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 optimised SQL queries, stored procedures and data transformation logic.
• Develop and maintain data pipelines feeding Seismic and/or similar reporting tools.
• Analyse existing reporting solutions and identify opportunities for optimisation 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.

Essential Technical Skills

• Strong SQL Server / T-SQL development experience.
• 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 analyse 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.

Skills

SQL Server Integration Services, Reporting and Analytics, Data Modeling, ETL, Agile, Data Mapping, Data Validation, Microsoft SQL Server, SQL, Issue Analysis, Performance Tuning