About the role
TL;DR
Senior Data Engineer for D.A. Davidson's Client Access applications.
- •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.
- •Key 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.
- •Requirements 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)
Required skills
dbtAirflowPythonOAuthJWTCI/CD
Domain expertise
fintech
Benefits & 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
Tech stack
dbtAirflowPythonOAuthJWTCI/CD