SS&C Technologies · 1 month ago
Senior Data Warehouse Engineer
United States
Full-time
Remote
Senior Level
5+ years expSS&C Technologies is a leading financial services and healthcare technology company headquartered in Windsor, Connecticut. They are seeking a Senior Data Warehouse Engineer to manage and optimize the enterprise data warehouse environment, ensuring high performance and reliability while overseeing ETL development and maintaining data integrity.
Cloud ManagementEnterprise SoftwareFinanceFinancial ServicesHealth CareProfessional ServicesSoftwareSoftware Engineering
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
Ensure data accuracy, quality, and consistency across multiple data sources and systems
Collaborate with business and technical stakeholders to define and implement data models, schemas, and transformation logic
Create, schedule, and monitor data pipelines to meet SLA and performance targets
Support enterprise reporting and analytics through tools such as Power BI, Tableau, Grafana, and WebFOCUS
Implement best practices for data governance, metadata management, and security
Troubleshoot ETL and API integration issues, monitor system performance, and support production releases
Document data flows, integration logic, and APIs to ensure maintainability and compliance
Qualification
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
Benefits
Health
Dental
401k plan
Tuition and professional development reimbursement plan
Company
SS&C Technologies
SS&C is a global provider of investment and financial software-enabled services and software focused exclusively on the global financial
10001+ employees
H1B Sponsorship
SS&C Technologies has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (105)
2024 (59)
2023 (74)
2022 (35)
2021 (30)
2020 (21)
Funding
Current Stage
Public CompanyTotal Funding
$750M2024-05-02Post Ipo Debt· $750M
2005-07-27Acquired
1996-05-31IPO
Leadership Team
Anthony Caiafa
Global CTO / CIO
Brian Schell
EVP, Chief Financial Officer
Recent News
Business Wire
2025-12-03
2025-11-25
Company data provided by crunchbase