Data Integration Engineer
Core
Design, develop, test, deploy, and support ETL/ELT processes and data integration solutions that enable the movement, transformation, and delivery of data across business systems in a financial services environment.
Role type
Data Integration Engineer
Builds
Scalable data pipelines, ETL/ELT processes, API integrations, and data services
Domain
Financial services, banking, wealth management
Required skills
TSQL, relational databases, ETL/ELT platforms (SSIS, Azure Data Factory, Microsoft Fabric), API and file-based integrations, Python, PowerShell, orchestration tools (ActiveBatch), Git, CI/CD, DevOps, DataOps, dimensional modeling, data warehousing, database security
Preferred skills
Financial services industry experience, Microsoft cloud technologies (Azure, AWS), MCSE/MCSA certifications
Technologies
Microsoft SQL Server, SSIS, Azure Data Factory, Microsoft Fabric, ActiveBatch, Python, PowerShell, Git
Responsibilities
Design and maintain data pipelines ingesting data from internal applications, vendors, and APIs; Develop reusable integration frameworks; Troubleshoot data flow and performance issues; Implement data quality controls and governance; Monitor production workflows and tune SQL queries; Collaborate with business users and data architects
Seniority
Mid-level, hands-on IC