System Analyst (T-SQL SSIS/SSRS)
eSolutionsFirst, LLC
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- SQL – SSIS/SSRS
Summary
Job Title: System Analyst (T-SQL – SSIS/SSRS)
Job Type: Contract (6-12 Months)
Location: Philadelphia, PA
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.
- Dice Id: 10367586
- Position Id: 9140273
- Posted 1 hour ago
Company Info
eSolutionsFirst is a premier technology and talent solutions partner providing best-in-class IT solutions and staffing services that empower our clients to be market leaders.
We Believe in Consistent, Quality & Transparent Hiring Process.
As a pioneer in talent management since we are proud of bridging the gap between diverse aspiring talent and various visionary organizations. Our people-centric Workforce portfolio spans across to help businesses overcome any talent management challenge. Our experience in serving industry leaders and Fortune500 companies gear us to empower enterprises of any size and industry with our dynamic staffing solutions.
We Deliver the Promise of Modern Technology.
Our leading-edge capabilities in Cloud, Data, and Security have been fortifying businesses with accelerated digital transformation over years. Our proven methodologies and pragmatic approaches revolutionize IT environments across diverse industries. Through our advisory and end-to-end digital transformation solutions, we encourage companies to establish a “Cloud-First Data-Driven” culture.
• Over 1,000 man-years of services in IT services.
• Over 100+ software development and management engagements.
• Over 17+ years of advisory services and multiple commercial-grade software products developed.
