Senior Data Engineer

D.A. Davidson Companies; Tualatin (OR); On-site; USD 120,000 - 126,000; Full time

Benefits offered by this job

Medical, Dental, Vision

401(k) and ESOP

Generous leave

Holidays

Professional development

Tuition reimbursement

Discounted insurance

Charitable gift‑matching

Community giving

Job summary

D.A. Davidson Companies is seeking a Senior Data Engineer to join the Agile team supporting our Client Access web and mobile apps. You will troubleshoot, expand and optimize data integrations and architecture while migrating legacy structures to cloud, service‑based architectures.

You will collaborate with software teams, database architects and business analysts to design scalable data pipelines, governance and telemetry for security and compliance across our platforms.

Qualifications

• 7+ years of Data Engineering in an oversight capacity.
• Extensive Financial Services domain experience.
• Experience with Microsoft cloud technologies in hybrid Architecture.
• Experience designing API‑oriented schemas and data pipelines.

Responsibilities

• Design, implement and maintain a robust data repository and integration architecture.
• Coordinate with stakeholders to resolve data-related issues and provide support.
• Oversee third‑party engineers through reviews and process audits.
• Identify internal process improvements and scalable infrastructure.
• Explore new technologies and architectures for growth.
• Build service‑based architecture for web and mobile apps.
• Develop telemetry and access controls to ensure compliance.

Skills

Data engineering leadership

Cloud data architecture

Data security & governance

SQL Server / T-SQL

API design

Education

Bachelor's degree in CS/Engineering

Tools

Microsoft Fabric

Azure Data Factory

dbt

Airflow

Azure DevOps

SSIS

Job description

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.

Summary

This Senior Data Engineer will be a member of the Agile team responsible for D.A. Davidson’s flagship Client Access web and mobile applications. As a member of the team, responsibilities will include troubleshooting, expanding and optimizing the existing data integrations and architecture. Additionally, the role will be involved in refactoring and migrating legacy structures and code into cloud and service‑based architectures. This individual will work as part of a dedicated product team in conjunction with other software development teams, database architects, business analysts and end users. A Senior Data Engineer collaborates on specific solution designs as well as broader data architecture and technology roadmaps to support strategic growth and team development.

Qualifications

• Commitment to maintain client confidentiality and data security
• Communicate in a clear and service‑oriented manner; use appropriate, professional language and grammar to effectively exchange ideas and information
• Ability to proactively work with both external and internal clients; relate with others in a professional manner to accomplish work responsibilities and objectives
• Ability to maintain regular, predictable attendance
• 7 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
• RDBMS expertise with Microsoft SQL Server (on prem and Azure SQL): advanced T SQL, query design, execution plans, index strategies (clustered/non‑clustered, filtered, included columns), partitioning, statistics, and concurrency/isolation level
• Data modeling mastery: 3NF normalization, strategic denormalization for read models, star/snowflake schemas, surrogate vs. natural keys, referential integrity, and temporal tables for auditing/history
• Experience performing operational analysis on internal and external data and processes to uncover failure points and identify opportunities for improvement
• Experience designing and implementing API‑oriented schemas for web and mobile application performance and optimization
• Holistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance and workload management
• Understanding of meta‑model and metadata management requirements
• Security and governance experience: RBAC, least privilege, secrets management, PII handling, encryption at rest/in transit, row level security, auditing, and compliance (e.g., SOC2, HIPAA, GDPR)

Specific skills include

• Extensive experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture
• Experience with Azure DevOps: CI/CD pipelines for AIS and Fabric assets
• ETL/ELT and data movement: SSIS/ADF/Azure Data Factory or modern pipelines (dbt, Airflow), CDC/change tracking, bulk load (BCP, BULK INSERT), and data quality checks. Experience designing metadata‑driven and reusable integration patterns
• Experience with API Management (APIM): API design, security (OAuth/JWT), policies, and versioning
• Experience in reverse‑engineering, refactoring and migrating legacy applications
• Experience with Service Bus / Event Grid design patterns: asynchronous and event‑driven integrations
• Experience with scripting languages such as: Python
• Experience with MDM concepts (golden record, survivorship, matching, data quality)

Job Responsibilities

• Design, implement and maintain a robust, efficient and compliant application data repository and integration architecture
• Work with Business and IT stakeholders to assist with data‑related technical issues and provide application support
• Coordinate, direct and oversee the work of third‑party engineers through solution design reviews, code reviews and process reviews
• Identify, design, and implement internal process improvements like automating manual processes, optimizing data delivery, re‑designing infrastructure for greater scalability
• Research and analyze new technologies, methodologies and architectures for viability
• Build and maintain a service‑based architecture for web and mobile applications
• Work independently within a scrum delivery team, with oversight from domain and enterprise architects, in support of business‑critical applications
• Contribute to the development of frameworks, guidelines, best practices and examples to ensure data structures and integration processes are accurate, compliant and secure
• Implement telemetry indicators to monitor performance, quality metrics to track accuracy and access controls to ensure compliance

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 $120,000 - $126,000 annually. 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.

Equity and Diversity

At D.A. Davidson, we are committed to fostering a diverse environment that supports the development and inclusivity of all employees.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.