Data Engineer

Education

• Bachelor's Degree in Computer Science, Information Technology, Software Engineering, Data Engineering, or related disciplines.

Experience

• Minimum 3 to 5 years of experience in Microsoft SQL Server technologies.
• Strong hands-on experience in SSRS report development.
• Experience supporting production reporting environments.
• Banking or financial services experience is an advantage.

Technical Competencies

SQL Server Reporting Services (SSRS) – Intermediate (Primary Skill)

• Report development and maintenance.
• Paginated reports.
• Parameterized reports.
• Subscriptions and scheduling.
• Dataset and data source management.
• Report performance optimization.
• Troubleshooting reporting issues.
• User requirement analysis and report design.

Microsoft SQL Server (MSSQL) – Intermediate

• Advanced T-SQL.
• Stored Procedures.
• Functions.
• Views and Triggers.
• Query optimization 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.

PowerShell – Intermediate

• Process automation.
• File handling and monitoring.
• Job scheduling and operational support.

Secure File Transfer & Encryption – Intermediate

• SSH/SFTP implementation and troubleshooting.
• PGP/GPG encryption and decryption.
• Automated file transmission and reconciliation.

MSSQL Administration – Beginner

• Basic backup and restore.
• User account and permission management.
• Database monitoring and maintenance.

Python – Beginner

• Basic scripting.
• File processing and automation.
• Support and enhancement of existing scripts.

Preferred Skills

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