Data Integration Engineer

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Data Integration Engineer based in the United States.

As a Data Integration Engineer, you will play a key role in designing, developing, and maintaining enterprise data integration solutions within a dynamic financial services environment. You will build and optimize scalable data pipelines, ETL/ELT processes, and API integrations to ensure the reliable flow of information across business systems.

Working with modern Microsoft cloud technologies and hybrid architectures, you will help support critical operational, regulatory, and analytical data needs. You will also contribute to data quality, governance, security, and performance optimization initiatives. Collaborating with data architects, engineers, business stakeholders, and external vendors, you will deliver robust and reusable integration solutions.

This remote opportunity offers the chance to contribute to enterprise technology initiatives while developing your expertise in modern data engineering practices.

Accountabilities

Design and develop data integration solutions: Build, test, deploy, and maintain ETL/ELT processes and enterprise data integration solutions that support business and technical requirements.

Build and maintain data pipelines: Develop scalable pipelines to ingest, transform, and deliver data from internal applications, third-party financial systems, vendor platforms, APIs, and other external sources.

Develop integration frameworks: Create reusable integration patterns and frameworks that improve scalability, reliability, performance, and long-term maintainability.

Manage different integration architectures: Support batch, near-real-time, and event-driven data integration processes to ensure efficient and consistent data delivery.

Optimize data performance: Troubleshoot data flow issues, resolve integration failures, optimize SQL queries and stored procedures, and improve the performance and reliability of data pipelines.

Ensure data quality and governance: Implement validation controls to maintain data accuracy, completeness, and consistency while supporting data lineage, metadata management, and enterprise data governance initiatives.

Support regulatory compliance: Participate in audit-related data validation activities and contribute to secure, compliant data movement practices in a regulated financial services environment.

Monitor production environments: Oversee production workflows, identify operational issues, respond to incidents, and ensure the stability and availability of integration processes.

Maintain platform operations: Participate in software releases, deployments, change management, and operational support activities while following established development and database lifecycle practices.

Document technical solutions: Maintain clear documentation covering integration processes, data mappings, technical designs, workflows, and operational procedures.

Collaborate with stakeholders: Work closely with business users to understand data requirements and partner with data architects and senior engineers on enterprise data initiatives.

Support reporting and analytics: Deliver reliable, structured, and accessible datasets to analysts and reporting teams to support business intelligence and decision-making.

Contribute to continuous improvement: Participate in Agile planning, code reviews, testing, and process optimization while applying DevOps and DataOps practices to improve development and deployment workflows.

Coordinate external integrations: Collaborate with vendors and third-party providers to implement, maintain, and troubleshoot external data connections.

Requirements

3–5 years of professional experience in data engineering, data integration, ETL development, or a closely related technical field.

Experience working in financial services, banking, wealth management, brokerage, insurance, or another regulated industry is strongly preferred.

Previous experience supporting production data integration environments and enterprise data workflows.

Experience with Microsoft cloud-based technologies and hybrid architecture environments.

Familiarity with cloud platforms such as Microsoft Azure and AWS. MCSE or MCSA certifications are preferred.

Advanced proficiency in T-SQL and Microsoft SQL Server, including complex SQL queries, stored procedure development, relational database management, and end-to-end data pipeline development.

Hands-on experience with ETL/ELT technologies such as SQL Server Integration Services (SSIS), Azure Data Factory, and Microsoft Fabric Data Pipelines.

Strong working knowledge of Microsoft Fabric, including pipelines, notebooks, Lakehouse and Warehouse concepts, and Medallion Architecture.

Experience developing and maintaining API integrations, web services, and file-based data integrations.

Proficiency in scripting languages such as Python, PowerShell, or DiamondPlate.

Experience with workflow orchestration and scheduling platforms such as ActiveBatch or equivalent tools.

Familiarity with Git, source control, versioning, CI/CD pipelines, and modern DevOps and DataOps practices.

Understanding of dimensional modeling, data warehousing, data architecture, and data governance principles.

Knowledge of database security, backup and recovery procedures, performance monitoring, and data protection best practices.

Understanding of software development and database development lifecycle concepts, including testing, deployment, recoverability, telemetry, and automated release processes.

Familiarity with Agile methodologies and collaborative software development practices.

Experience working with external vendors and managing third-party data integrations.

Strong analytical and troubleshooting skills, with the ability to investigate complex technical issues and implement effective solutions.

Excellent written and verbal communication skills, with the ability to collaborate effectively with technical and non-technical stakeholders.

Strong organizational skills, attention to detail, and the ability to manage multiple priorities independently.

Understanding of information sensitivity regulations and best practices for maintaining data confidentiality, integrity, and security.

Benefits

Competitive annual salary: Base salary ranging from $73,500 to $105,600, depending on relevant experience, technical skills, qualifications, and geographic location.

Remote work flexibility: Opportunity to work remotely within the United States, with the role primarily targeting candidates in the Western States or Midwest.

Comprehensive healthcare coverage: Medical, dental, and vision insurance.

Retirement savings: Access to a company-sponsored 401(k) plan, including an Employee Stock Ownership Plan (ESOP) contribution.

Paid time off: Generous sick leave and vacation allowances.

Family support: Maternity and parental leave benefits.

Paid holidays: Company-paid holidays throughout the year.

Professional development: Access to professional learning opportunities and resources to support career growth and technical development.

Tuition reimbursement: Educational assistance with a lifetime reimbursement cap of $15,000.

Insurance discounts: Reduced rates on personal insurance products, including home, auto, and recreational vehicle coverage.

Charitable giving: Access to a charitable gift-matching program supporting causes that matter to employees.

Community engagement: Participation in an annual Day of Giving initiative dedicated to supporting and strengthening local communities.

Inclusive workplace: A professional environment committed to diversity, equal opportunities, employee development, and accessibility.

How Jobgether works

• We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.
• We appreciate your interest and wish you the best!
• Why Apply Through Jobgether?

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.

#LI-CL1