Senior Data Warehouse Engineer

3 days ago

🏰 Missouri – Remote

Although this job is listed in Missouri, this company may be open to hiring remote in other states.

⏰ Full Time

🟠 Senior

🚰 Data Engineer

Apply Now

Receive Emails with Similar Jobs

SS&C Technologies

WebsiteLinkedInAll Job Openings

Banking • Healthcare • Fintech

SS&C Technologies is a global leader in financial services and healthcare technology, recognized as the world’s largest independent hedge fund and private equity administrator, as well as the largest mutual fund transfer agency. The company offers a comprehensive range of solutions including asset management, banking, healthcare, insurance, and wealth management, leveraging proprietary software and extensive expertise to meet the operational needs of clients across multiple industries.

10,000+ employees

Founded 1986

🏦 Banking

💳 Fintech

📋 Description

• 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

🎯 Requirements

• 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 • Familiarity with ServiceNow, Jira, and Workday data models or API frameworks (preferred) • Experience with Azure Data Factory, Synapse Analytics, or other cloud-based data solutions (preferred) • Knowledge of Python, PowerShell, or other scripting languages for automation and API integration (preferred) • Understanding of DevOps and source control tools (Git, Azure DevOps) (preferred) • Exposure to data governance, metadata management, and data security frameworks (preferred)

🏖️ Benefits

• Health, dental, 401k plan • Tuition and professional development reimbursement plan