Data Engineer at D.A. Davidson

Tahoe City, California, United States

D.A. Davidson Logo
Not SpecifiedCompensation
Junior (1 to 2 years), Mid-level (3 to 4 years)Experience Level
Full TimeJob Type
UnknownVisa
Financial ServicesIndustries

Requirements

  • 2 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
  • Experience facilitating calls to capture end-user requirements with technical and non-technical users
  • Holistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance and workload management
  • Understanding of data modeling concepts like: Conceptual data modeling, Logical data modeling, Relational data modeling, Dimensional and multi-dimensional data modeling
  • Understanding of meta-model and metadata management requirements
  • Extensive experience with SQL-based syntax
  • Extensive experience designing and implementing data structures and interfaces for applications and business processes
  • Experience with relational database platforms: preferably MS SQL Server
  • Experience with data pipeline tools such as: SSIS
  • Experience using orchestration tools such as: ActiveBatch
  • Experience with web services and API integrations
  • Experience with scripting languages such as: Python and PowerShell
  • Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc
  • Familiarity with data visualization technologies such as: Tableau, PowerBI

Responsibilities

  • Design, implement and maintain a robust, efficient and compliant data pipeline architecture
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc
  • Build and maintain a service-based architecture for the publication of consumable data and information objects
  • Work with data architects and data analysts to enhance and evolve the data environment
  • Work with Business and IT stakeholders to assist with data-related technical issues and support their data and information requirements
  • Define and develop frameworks, guidelines, best practices and examples to ensure data structures and integration processes are accurate, compliant and secure
  • Facilitate the development

Skills

TSQL
Data Pipelines
Relational Databases
Stored Procedures
Query Authoring
Microsoft Azure
Hybrid Architecture

D.A. Davidson

Provides wealth management and financial advisory services

About D.A. Davidson

D.A. Davidson & Co. provides personalized wealth management and financial advisory services to individuals, families, and businesses primarily in the United States. The firm offers a variety of services, including investment management, financial planning, and trust services, aimed at helping clients align their portfolios with their financial goals. D.A. Davidson employs a research-based approach to tailor solutions for a diverse client base, which includes individual investors and business owners. Unlike many competitors, D.A. Davidson has a long history dating back to 1935 and has grown through strategic acquisitions and organic growth, establishing a reputation as a trusted name in the financial services industry. The company's goal is to deliver personalized financial solutions that meet the unique needs of each client.

Great Falls, MontanaHeadquarters
2014Year Founded
VENTURE_UNKNOWNCompany Stage
Financial ServicesIndustries
1,001-5,000Employees

Benefits

Health Insurance
Dental Insurance
Vision Insurance
401(k) Company Match
Paid Vacation
Paid Sick Leave
Paid Holidays
Professional Development Budget
Tuition Reimbursement
Employee Discounts
Company Social Events

Risks

Competition in AI-driven financial services could challenge D.A. Davidson's market position.
Rapid AI technology evolution may outpace D.A. Davidson's current capabilities.
Resource diversion to Diversified Industrials may affect overall service quality.

Differentiation

D.A. Davidson offers personalized wealth management and financial advisory services in the U.S.
The firm has a strong focus on small to middle-market companies across various sectors.
D.A. Davidson's research-based approach aligns client portfolios with financial goals.

Upsides

The rise of digital wealth management platforms enhances personalized investment advice delivery.
Growth in middle-market private equity presents opportunities for D.A. Davidson's advisory services.
Increased focus on sustainable finance aligns with D.A. Davidson's advisory offerings.

Land your dream remote job 3x faster with AI