System Analyst (T-SQL SSIS/SSRS)

Job Summary

We are looking for an experienced System Analyst with strong hands-on experience in Microsoft SQL Server technologies, including T-SQL, SSIS, and SSRS.

The ideal candidate will have experience analyzing complex data requirements, developing SQL queries, supporting ETL processes, and building financial and operational reports.

Experience in the Wealth Management or Financial Services industry is highly preferred.

The candidate will work closely with business stakeholders, data teams, and technology teams to support data integration, reporting, and application enhancements.

Key Responsibilities

• Analyze business and system requirements and translate them into technical specifications.
• Develop, optimize, and maintain complex T-SQL queries, stored procedures, views, and functions.
• Design, develop, and maintain SSIS packages for ETL and data integration processes.
• Develop and maintain SSRS reports, dashboards, and reporting solutions.
• Perform data analysis, data mapping, validation, and reconciliation.
• Troubleshoot SQL queries, ETL workflows, and reporting issues.
• Analyze existing systems and recommend improvements to performance, scalability, and data quality.
• Collaborate with business analysts, developers, QA, and business stakeholders.
• Support production issues, root cause analysis, and system enhancements.
• Prepare technical documentation, data flow diagrams, and system specifications.

Required Qualifications

• 8+ years of experience in System Analysis, SQL Development, or Database-related roles.
• Strong hands-on experience with Microsoft SQL Server and T-SQL.
• Extensive experience developing complex SQL queries, stored procedures, and performance tuning.
• Hands-on experience with SQL Server Integration Services (SSIS).
• Experience developing and maintaining SQL Server Reporting Services (SSRS) reports.
• Strong understanding of ETL processes, data integration, and data warehousing concepts.
• Experience with data analysis, data validation, and troubleshooting.
• Strong analytical, communication, and problem-solving skills.

Preferred Qualifications

• Experience in Wealth Management, Investment Management, or Financial Services.
• Understanding of investment data, client accounts, portfolio data, and financial reporting.
• Experience working with large datasets and enterprise reporting environments.
• Knowledge of SQL Server database performance optimization.
• Experience working in Agile/Scrum environments.