Senior Data Engineer

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. Company Overview: 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, while delivering outstanding service to our clients and coworkers. We support a friendly, open and adaptive culture, and encourage candid communication and productive collaboration across throughout the firm. Just as we work to improve our clients and employees’ well-being, we also work to strengthen local communities—and giving back is one of our core values. 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: o Extensive experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion ar…