SSR Reporting Specialist / Data Engineer (MSSQL & SSRS)

SSR Reporting Specialist / Data Engineer (MSSQL & SSRS)

Technical Skills

MSSQL Scripting (T-SQL), Stored Procedures, SSIS, SQL Server Agent, PowerShell,
SSH / SFTP File Transfer, PGP/GPG Encryption & Decryption, MSSQL Administration, Python Scripting

Technical Competencies

SQL Server Reporting Services (SSRS) – Intermediate (Primary Skill)
• Report development and maintenance.
• Paginated reports.
• Parameterised reports.
• Subscriptions and scheduling.
• Dataset and data source management.
• Report performance optimisation.
• Troubleshooting reporting issues.
• User requirement analysis and report design.

Microsoft SQL Server (MSSQL) – Intermediate
• Advanced T-SQL.
• Stored Procedures.
• Functions.
• Views and Triggers.
• Query optimisation and tuning.
• SQL Server Agent job support.

SQL Server Integration Services (SSIS) – Intermediate
• ETL package development.
• Data migration and transformation.
• Package deployment and troubleshooting.
• Scheduling and automation.

System Integration – Intermediate
• Interface development and support.
• Data mapping and reconciliation.
• File-based integration.
• Batch processing support.

Preferred Skills

• Power BI.
• Data Warehouse (DWH) concepts.
• Azure Data Factory.
• Azure SQL Database.
• Banking and financial reporting systems.

Key Success Indicators
• Timely delivery of business and regulatory reports.
• High report accuracy and data integrity.
• Improved report performance and user satisfaction.
• Stable ETL and integration processes.
• Efficient incident resolution and production support.

Ideal Candidate Profile
A reporting-focused Data Engineer with strong SSRS development experience,
solid MSSQL and SSIS skills, and practical exposure to system integration,
PowerShell automation, SFTP file transfers, and PGP/GPG encryption, capable
of supporting both project delivery and production operations in a banking or
enterprise environment.