Summary/Function:
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.
Qualifications:
• 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:
o SSIS
o Azure Data Factory
o 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, 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.
• Specific skills include:
o Extensive experience with SQL syntax
o Experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture
o Experience using orchestration tools such as: ActiveBatch
o Experience with web services and API integrations
o Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc.
o Experience working with vendors and 3rd party data integrations.
Job Responsibilities:
Data Integration & Engineering
• 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.
Data Quality & Governance
• 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.
Platform & Operations
• 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.
Collaboration
• 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.
What we offer:
Competitive salary plus excellent benefits and perks including, but not limited to:
• Medical, Dental and Vision
• Company 401(k)and ESOP contribution
• Generous sick, vacation, and maternity/parental leave
• Paid holidays
• Professional Development Opportunities
• Tuition Reimbursement ($15,000 lifetime cap)
• Discounted personal insurance including home, auto and recreational vehicles
• Charitable gift-matching program
• Davidson Day of Giving – Our tradition of positively impacting communities in which we live and work.
The potential base pay hiring range for this role is $73,500 to $105,600 yearly. The compensation offered will be determined on a case-by-case basis considering a variety of factors including, but not limited to, the skills, relevant work experience, and geographic location of each specific candidate.
D.A. Davidson has been in business for 90 years! As an employee-owned company, our success is driven by our high standards of business ethics, integrity and the belief that our Associates are our most important assets. We hope you will consider joining us!
Skills Required
- 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
- Experience with cloud services such as Microsoft Azure or AWS
- Advanced T-SQL knowledge and experience with relational databases, query authoring, stored procedures, and end-to-end data pipelines
- Experience with ETL/ELT platforms including SSIS, Azure Data Factory, or 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, PowerShell, or 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
- Experience with Microsoft Fabric pipelines, notebooks, Lakehouse/Warehouse concepts, and Medallion architecture
- Experience with web services and API integrations
- Experience with Agile, DevOps, and DataOps methods and technologies
- Experience working with vendors and third-party data integrations
- Experience in financial services, banking, wealth management, brokerage, insurance, or another regulated industry
- MCSE or MCSA certification
D.A. Davidson Companies Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about D.A. Davidson Companies and has not been reviewed or approved by D.A. Davidson Companies.
-
Equity Value & Accessibility — Employee ownership through an ESOP is positioned as a core part of total rewards, complementing cash compensation. Ownership is framed as adding long‑term value alongside other benefits.
-
Retirement Support — 401(k) options and company contributions via profit‑sharing are highlighted as part of the package. Early eligibility and combined ESOP/401(k) design can materially boost long‑term retirement savings when the firm performs well.
-
Parental & Family Support — Paid parental, adoption, and surrogacy leave are explicitly offered. Broader paid time off and holidays are emphasized in role materials.
D.A. Davidson Companies Insights
What We Do
At D.A. Davidson Companies, we identify and evaluate market trends, investment ideas and business opportunities, and turn them into actionable insights and strategies. Founded in 1935 as a small brokerage firm, D.A. Davidson has grown into a diversified financial services company comprised of seven distinct business units across the U.S. Through the years, our most important service has remained consistent: a personalized approach that reflects the individuality of each of our clients. As part of an employee-owned company, each of our associates has a unique perspective of success. We believe in doing what is right for our clients and are empowered to deliver high-impact solutions. We are with our clients every step of the way—leveraging our nationally-recognized research, capital markets and investment banking expertise, and a robust network of financial advisors. Clients not only benefit from our expansive platform of solutions and services, but also from strong values rooted in tradition and a deep sense of responsibility to our communities.
.png){kind=logo}
