Data Integration Engineer

D.A. Davidson Companies

. Design, develop, test, deploy, and support ETL/ELT processes and data integration solutions .

Posted 11/11/2026full-timeRemote • United StatesMid-LevelSenior💰 $73,500 - $105,600 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and developing ETL/ELT processes and data integration solutions, with a strong focus on data accuracy, governance, and compliance in financial services. Proficient in utilizing cloud technologies and relational databases to deliver reliable data pipelines and support enterprise data initiatives.

Highest-signal resume keywords

ETL/ELT DevelopmentMicrosoft AzureTSQL Query AuthoringData GovernanceData Integration Solutions

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data EngineeringData Pipeline DevelopmentSQL SyntaxRelational DatabasesAPI IntegrationsScripting LanguagesDimensional ModelingData WarehousingPerformance MonitoringData Accuracy Controls

Soft Skills

Problem SolvingCollaborationCommunicationAgile MethodologiesContinuous Improvement

Tools & Technologies

SSISAzure Data FactoryMicrosoft FabricActiveBatchGitCI/CDDevOpsDataOpsPythonPowerShell

Certifications & Qualifications

MCSEMCSA

Industry Keywords

Financial ServicesBankingWealth ManagementBrokerageInsuranceRegulated IndustriesData SecurityInformation Sensitivity RegulationsAudit ComplianceData Validation

Tech Stack

Tools & technologies

AWSAzureCloudETLMS SQL ServerPythonSQLSSIS

About the role

Key responsibilities & impact

Design, develop, test, deploy, and support ETL/ELT processes and data integration solutions
Build and maintain data pipelines ingesting 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 ensuring 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
Gather and interpret data requirements with business users
Partner with data architects and senior engineers on enterprise data initiatives
Deliver reliable, well-structured datasets to analysts and reporting teams
Participate in Agile planning, code reviews, testing, and continuous improvement activities

Requirements

What you’ll need

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 (Microsoft Azure, AWS)
Advanced working TSQL knowledge and experience with relational databases, query authoring, stored procedure development, and end-to-end data pipeline development
Experience with ETL/ELT platforms such as SSIS, Azure Data Factory, and 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, and 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
Familiarity with Agile work principles
Understanding of software and database development life cycle concepts
Awareness of information sensitivity regulations and data security and confidentiality best practices
Extensive experience with SQL syntax
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
MCSE/MCSA certifications preferred
Experience in financial services, banking, wealth management, brokerage, insurance, or other regulated industries preferred

Benefits

Comp & perks

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