Data Integration Engineer

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.