Data Integration Engineer

D.A. Davidson Companies is an independent, employee-owned company with a rich history spanning 90 years. We are dedicated to conducting our business in accordance with the highest standards of integrity and ethics, and delivering outstanding service to our clients and each other. We support a friendly, open and supportive culture, and encourage candid communication and productive engagement that make our companies and each of us better.

Just as we work to improve our clients’ financial well-being, we also work to strengthen local communities—and giving back is one of our core values. You can learn more about our company culture and impact in our latest annual report.

The Data Integration Engineer is responsible for designing, developing, supporting, and optimizing enterprise data integration solutions that enable the movement, transformation, and delivery of data across business systems. This role contributes to the development of scalable data pipelines, ETL/ELT processes, API integrations, and data services that support operational, regulatory, and analytical workloads within a financial services environment.

• 3-5 years of experience in Data Engineering, Data Integration, or ETL development.
• Experience working in financial services, banking, wealth management, brokerage, insurance, or other regulated industries preferred.
• Experience supporting production data integration environments.
• Experience with Microsoft cloud-based technologies in a hybrid architecture.
• Experience with cloud services (Microsoft Azure, AWS); MCSE/MCSA certifications preferred.
• 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 relational database platforms, preferably Microsoft SQL Server.
• Experience with scripting languages such as Python, Power Shell, Diamond Plate.
• Experience with orchestration platforms such as Active Batch or equivalent scheduling tools.
• Familiarity with Git, CI/CD, Dev Ops, and Data Ops 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.
• Specific skills include:
• Extensive experience with SQL syntax
• Experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture
• Experience using orchestration tools such as:
  Active Batch
• Experience with web services and API integrations
• Experience with Agile, Dev Ops and Data Ops 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.

• 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.