Overview
USD 100,000.00 per year
Full Time
Skills
Financial Services
Health Care
Attention To Detail
Database Architecture
ROOT
Training
Servers
Data Manipulation
Reporting
Extract
Transform
Load
Workflow
Collaboration
Scheduling
Management
Orchestration
System Integration
Optimization
Microsoft SQL Server
Sybase
Database
Transact-SQL
Stored Procedures
Microsoft SSIS
Scripting
SQL
Microsoft Windows
Batch File
ODBC
Debugging
Conflict Resolution
Problem Solving
Communication
DirectShow
DS
Recruiting
Professional Development
SAP BASIS
Job Details
As a leading financial services and healthcare technology company based on revenue, SS&C is headquartered in Windsor, Connecticut, and has 27,000+ employees in 35 countries. Some 20,000 financial services and healthcare organizations, from the world's largest companies to small and mid-market firms, rely on SS&C for expertise, scale, and technology.
Job Description
Job Title: Microsoft SQL Developer (SSIS Specialist)
Location: Union, NJ (Hybrid)
Get To Know Us:
We are seeking a highly skilled and detail-oriented Microsoft SQL Developer with deep experience in SQL scripting, database architecture, and ETL processes using SSIS. The ideal candidate will have a strong background in both MS SQL Server and Sybase, and will be responsible for designing, developing, and maintaining robust data solutions that support business-critical operations. This role requires a proactive problem solver who can dive into complex codebases, identify root causes, and optimize performance across systems.
Why You Will Love It Here!
What You Will Get To Do:
Database Development & Maintenance:
Design, build, and optimize stored procedures, triggers, and functions in MS SQL and Sybase environments
Set up and maintain MS SQL linked servers and develop scripts that leverage cross-server data access
Perform advanced SQL scripting for data manipulation, transformation, and reporting
ETL & SSIS Package Management:
Develop, modify, and troubleshoot SSIS packages for complex ETL workflows
Review and enhance package logic, configuration, and performance
Collaborate with stakeholders to ensure data pipelines meet business requirements
Automation & Scheduling:
Configure and manage MS SQL Agent Jobs for scheduled tasks and data operations
Set up and maintain Windows Task Scheduler jobs for auxiliary automation
Write and maintain Windows batch scripts for file handling and process orchestration
System Integration & Connectivity:
Configure ODBC data sources at the OS level to support external data connectivity
Ensure seamless integration between internal databases and third-party systems
Troubleshooting & Optimization:
Analyze code and system behavior to identify and resolve errors or unexpected outcomes
Monitor performance and implement tuning strategies for queries and processes
What You Will Bring:
5+ years of experience in MS SQL Server and Sybase database development
Strong proficiency in T-SQL, stored procedures, triggers, and functions
Hands-on experience with SSIS package development and maintenance
Familiarity with linked server configurations and cross-server scripting
Experience with SQL Agent Jobs and Windows Task Scheduler
Basic knowledge of Windows batch scripting and ODBC setup
Proven ability to analyze and debug complex codebases
Excellent problem-solving and communication skills
#LI-DS3
#LI-Hybrid
Unless explicitly requested or approached by SS&C Technologies, Inc. or any of its affiliated companies, the company will not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services.
SS&C offers excellent benefits including health, dental, 401k plan, tuition and professional development reimbursement plan.
SS&C Technologies is an Equal Employment Opportunity employer and does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status or any other classification protected by applicable discrimination laws.
Salary is determined by various factors including, but not limited to, relevant work experience, job related knowledge, skills, abilities, business needs, and geographic regions.
NY: Salary range for the position: 100,000.00 USD to 120,000.00 USD.
Job Description
Job Title: Microsoft SQL Developer (SSIS Specialist)
Location: Union, NJ (Hybrid)
Get To Know Us:
We are seeking a highly skilled and detail-oriented Microsoft SQL Developer with deep experience in SQL scripting, database architecture, and ETL processes using SSIS. The ideal candidate will have a strong background in both MS SQL Server and Sybase, and will be responsible for designing, developing, and maintaining robust data solutions that support business-critical operations. This role requires a proactive problem solver who can dive into complex codebases, identify root causes, and optimize performance across systems.
Why You Will Love It Here!
- Flexibility: Hybrid Work Model and Business Casual Dress Code, including jeans
- Your Future: 401 (k) Matching Program, Professional Development Reimbursement
- Work/Life Balance: Flexible Personal/Vacation Time Off, Sick Leave, Paid Holidays
- Your Wellbeing: Medical, Dental, Vision, Employee Assistance Program, Parental Leave
- Wide-Ranging Perspectives: Committed to Celebrating the Variety of Backgrounds, Talents, and Experiences of Our Employees
- Training: Hands-On, Team-Customized, including SS&C University
- Extra Perks: Discounts on fitness clubs, travel, and more!
What You Will Get To Do:
Database Development & Maintenance:
Design, build, and optimize stored procedures, triggers, and functions in MS SQL and Sybase environments
Set up and maintain MS SQL linked servers and develop scripts that leverage cross-server data access
Perform advanced SQL scripting for data manipulation, transformation, and reporting
ETL & SSIS Package Management:
Develop, modify, and troubleshoot SSIS packages for complex ETL workflows
Review and enhance package logic, configuration, and performance
Collaborate with stakeholders to ensure data pipelines meet business requirements
Automation & Scheduling:
Configure and manage MS SQL Agent Jobs for scheduled tasks and data operations
Set up and maintain Windows Task Scheduler jobs for auxiliary automation
Write and maintain Windows batch scripts for file handling and process orchestration
System Integration & Connectivity:
Configure ODBC data sources at the OS level to support external data connectivity
Ensure seamless integration between internal databases and third-party systems
Troubleshooting & Optimization:
Analyze code and system behavior to identify and resolve errors or unexpected outcomes
Monitor performance and implement tuning strategies for queries and processes
What You Will Bring:
5+ years of experience in MS SQL Server and Sybase database development
Strong proficiency in T-SQL, stored procedures, triggers, and functions
Hands-on experience with SSIS package development and maintenance
Familiarity with linked server configurations and cross-server scripting
Experience with SQL Agent Jobs and Windows Task Scheduler
Basic knowledge of Windows batch scripting and ODBC setup
Proven ability to analyze and debug complex codebases
Excellent problem-solving and communication skills
#LI-DS3
#LI-Hybrid
Unless explicitly requested or approached by SS&C Technologies, Inc. or any of its affiliated companies, the company will not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services.
SS&C offers excellent benefits including health, dental, 401k plan, tuition and professional development reimbursement plan.
SS&C Technologies is an Equal Employment Opportunity employer and does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status or any other classification protected by applicable discrimination laws.
Salary is determined by various factors including, but not limited to, relevant work experience, job related knowledge, skills, abilities, business needs, and geographic regions.
NY: Salary range for the position: 100,000.00 USD to 120,000.00 USD.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.