[Hiring] Senior Data Engineer @D.A. Davidson

Role Description

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. Responsibilities will include:

• Troubleshooting, expanding, and optimizing existing data integrations and architecture.
• Refactoring and migrating legacy structures and code into cloud and service-based architectures.
• Collaborating with software development teams, database architects, business analysts, and end users.
• Contributing to specific solution designs and broader data architecture and technology roadmaps to support strategic growth and team development.

Qualifications

• Commitment to maintain client confidentiality and data security.
• Clear and service-oriented communication; use of appropriate, professional language and grammar.
• Ability to proactively work with both external and internal clients.
• 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, 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).

Requirements

• 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, 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, and redesigning 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.

Benefits

• Competitive salary plus excellent benefits and perks including:
• 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.