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
Position Summary
The
Data Warehouse Administrator
is responsible for managing, optimizing, and supporting the enterprise data warehouse environment to ensure high performance, reliability, and scalability. This role plays a critical part in the data lifecycle-overseeing
ETL development
, maintaining
data integrity
, and enabling enterprise reporting and analytics.
The ideal candidate has deep hands-on experience with
Microsoft SQL Server
,
, and
, along with a strong understanding of
such as
,
,
, and
. Experience with
-including integrating data from platforms such as
,
, and
.
Key Responsibilities
- Administer, maintain, and optimize enterprise data warehouse environments to ensure availability, scalability, and performance.
- Design, develop, and support ETL workflows using SSIS and other Microsoft BI components.
- Manage data integrations via APIs (REST, SOAP, JSON, XML) to extract and transform data from systems such as ServiceNow, Jira, Workday, and other enterprise applications.
Qualifications
Required:
- Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).
- 5+ years of experience administering or developing enterprise data warehouse environments.
- Advanced proficiency with Microsoft SQL Server, SSIS, and ETL development.
- Strong experience with Microsoft BI stack (SSAS, SSRS, Power BI).
- Hands-on experience working with REST/SOAP APIs for data integration and automation.
- Experience building and maintaining dashboards and reports using Power BI, Tableau, Grafana, or WebFOCUS.
- Strong SQL scripting and performance tuning skills.
- Excellent communication and documentation abilities.
Preferred
- Familiarity with ServiceNow, Jira, and Workday data models or API frameworks.
- Experience with Azure Data Factory, Synapse Analytics, or other cloud-based data solutions.
- Knowledge of Python, PowerShell, or other scripting languages for automation and API integration.
- Understanding of DevOps and source control tools (Git, Azure DevOps).
- Exposure to data governance, metadata management, and data security frameworks.
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.
PDN-a07e5149-471d-4103-8913-f74b08855e3f
