Senior Data Engineer

December 4, 2024

Apply Now

Receive Emails with Similar Jobs

D.A. Davidson Companies

WebsiteLinkedInAll Job Openings

D. A. Davidson Companies is a comprehensive financial services company that offers a wide array of services to individual investors, corporations, and institutions. With a history of 88 years, they provide wealth management, equity capital markets, investment banking, and trust services. D. A. Davidson is committed to guiding clients through life's key financial moments with services like retirement planning, estate planning, education planning, and more. Additionally, they are involved in public finance, offering expertise in municipal advisory services, tribal financing, and fixed income capital markets. Renowned for their professional money management and advisory solutions, D. A. Davidson emphasizes personalized client service and strategic investment advice. Their investment advisors use a research-based approach to ensure client portfolios align with their financial goals. The firm's dedicated team is also involved in community empowerment initiatives nationwide, leveraging their extensive knowledge in various sectors to benefit the communities they serve.

Wealth management • financial planning • equity & fixed income capital markets • investment banking • award-winning research

1001 - 5000 employees

Founded 1935

💸 Finance

📋 Description

•Senior Data Engineer responsible for expanding and optimizing data pipeline architecture and monitoring. •Works with software development teams and data analysts on complex data initiatives ensuring best practices. •Oversees junior team members and contributes to data architecture and technology roadmaps.

🎯 Requirements

•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 •Advanced working TSQL knowledge and experience working with relational databases, query authoring, stored procedure development, end-to-end data pipeline development •Experience performing operational analysis on internal and external data and processes to uncover failure points and identify opportunities for improvement •Strong analytic skills related to working with complex, multi-layered data pipelines and dependent datasets •Holistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance and workload management •Understanding of data modeling concepts like: o Conceptual data modeling o Logical data modeling o Relational data modeling o Dimensional and multi-dimensional data modeling •Understanding of meta-model and metadata management requirements •Specific skills include: o Extensive experience with SQL-based syntax o Extensive experience designing and implementing data structures and interfaces for applications and business processes o Experience with relational database platforms: preferably MS SQLServer o Experience with data pipeline tools such as: SSIS o Experience using orchestration tools such as: ActiveBatch o Experience with web services and API integrations o Experience with scripting languages such as: Python and Powershell o Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc. o Familiarity with data visualization technologies such as: Tableau, PowerBI

🏖️ Benefits

•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.