Data Engineer

D.A. Davidson Companies

. Expand and optimize data and data pipeline architecture .

Posted 10/15/2026full-timeRemote • United StatesMid-LevelSenior💰 $73,500 - $117,900 per yearWebsite

Tech Stack

Tools & technologies

AzureCloudMS SQL ServerPythonSQLSSIS

About the role

Key responsibilities & impact

Expand and optimize data and data pipeline architecture
Monitor, troubleshoot, and performance-tune data flows used for data collection, integration, and provisioning
Design, implement, and maintain robust, efficient, and compliant data pipeline architecture
Identify and implement process improvements, including automation, data delivery optimization, and infrastructure redesign for scalability
Build and maintain service-based architecture for publishing consumable data and information objects
Work with data architects and data analysts to enhance and evolve the data environment
Support Business and IT stakeholders with data-related technical issues and information requirements
Define frameworks, guidelines, best practices, and examples for accurate, compliant, and secure data structures and integration processes
Facilitate development and implementation of enterprise data quality and data protection standards
Define performance indicators and quality metrics and ensure compliance with data-related policies and standards
Participate in an on-call rotation to monitor, troubleshoot, and resolve data integration alerts and failures
Collaborate with software development teams, database architects, data analysts, and end users on complex data initiatives

Requirements

What you’ll need

5 or more years of Data Engineering experience in an oversight capacity
Extensive domain-specific experience in the Financial Services industry
Experience with Microsoft cloud-based technologies in a hybrid architecture
Advanced working TSQL knowledge and experience with relational databases, query authoring, stored procedure development, and end-to-end data pipeline development
Experience performing operational analysis on internal and external data and processes
Strong analytic skills related to complex, multi-layered data pipelines and dependent datasets
Experience facilitating calls to capture end-user requirements with technical and non-technical users
Awareness of data preparation, metadata, dependencies, lineages, compliance, and workload management
Understanding of conceptual, logical, relational, dimensional, and multi-dimensional data modeling
Understanding of meta-model and metadata management requirements
Extensive experience with SQL syntax
Experience designing and implementing data structures and interfaces for applications and business processes
Experience with Microsoft Fabric, including pipelines, notebooks, Lakehouse/Warehouse concepts, and Medallion architecture
Experience with relational database platforms, preferably MS SQL Server
Experience with SSIS and Azure Integration Services
Experience with orchestration tools such as ActiveBatch
Experience with web services and API integrations
Experience with Python and PowerShell
Experience with Agile, DevOps, and DataOps methods and technologies
Commitment to client confidentiality and data security
Clear, service-oriented communication using appropriate professional language and grammar
Ability to work proactively with external and internal clients
Ability to maintain regular, predictable attendance

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