Data Integration Engineer

D.A. Davidson & Co. is hiring a Data Integration Engineer to design, develop, support, and optimize enterprise data integration solutions in a financial services environment. The role builds and maintains data pipelines, ETL/ELT processes, API integrations, and data services while supporting data quality, governance, and production operations.

Responsibilities:

• Design, develop, test, deploy, and support ETL/ELT processes and data integration solutions
• Build and maintain data pipelines that ingest information from internal applications, vendors, APIs, and third-party financial systems
• Develop reusable integration frameworks and patterns to improve scalability and maintainability
• Support batch, near real-time, and event-driven data integration architectures
• Troubleshoot and resolve data flow, performance, and reliability issues
• Implement controls to ensure data accuracy, completeness, and consistency
• Support data lineage, metadata management, and data governance initiatives
• Participate in regulatory and audit-related data validation efforts
• Assist in developing standards for secure and compliant data movement
• Monitor production workflows and respond to operational issues
• Tune SQL queries, integration jobs, and data pipelines for performance
• Participate in release, deployment, and change management processes
• Maintain documentation for integration processes, data mappings, and technical designs
• Work with business users to gather and interpret data requirements
• Partner with data architects and senior engineers on enterprise data initiatives
• Support analysts and reporting teams by delivering reliable and well-structured datasets
• Participate in Agile planning, code reviews, testing, and continuous improvement activities

Requirements:

• 3-5 years of experience in Data Engineering, Data Integration, or ETL development
• Experience supporting production data integration environments
• Experience with Microsoft cloud-based technologies in a hybrid architecture
• Advanced working TSQL knowledge and experience working with relational databases, query authoring, stored procedure development, end-to-end data pipeline development
• Experience with ETL/ELT platforms such as:
• SSIS
• Azure Data Factory
• Microsoft Fabric Data Pipelines
• Experience with API and file-based integrations
• Experience with scripting languages such as Python, PowerShell, DiamondPlate
• Experience with orchestration platforms such as ActiveBatch or equivalent scheduling tools
• Familiarity with Git, CI/CD, DevOps, and DataOps practices
• Understanding of dimensional modeling, data warehousing, and data governance principles
• Knowledge of database security, backup and recovery, and performance monitoring standards
• Familiar with Agile work principles
• Satisfactory written and oral communication skills
• Understanding of software and database development life cycle concepts
• Awareness of information sensitivity regulations and best-practices regarding data security and confidentiality
• Extensive experience with SQL syntax
• Experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture
• Experience using orchestration tools such as: ActiveBatch
• Experience with web services and API integrations
• Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc
• Experience working with vendors and 3rd party data integrations
• Experience working in financial services, banking, wealth management, brokerage, insurance, or other regulated industries
• Experience with cloud services (Microsoft Azure, AWS)
• MCSE/MCSA certifications
• Experience with relational database platforms
• Microsoft SQL Server