D.A. Davidson Companies

D.A. Davidson Companies

D.A. Davidson Companies is a diversified financial services company offering expertise in wealth management, capital markets, investment banking, trust and asset management. With a tradition of personalized client service, our advisors provide trusted ...

Capital Markets
1K-5K
Founded 1935

Description

  • Design, implement, and maintain a robust, efficient, and compliant application data repository and integration architecture.
  • Troubleshoot, expand, and optimize existing data integrations and architecture.
  • Refactor and migrate legacy structures and code into cloud and service-based architectures.
  • Work with business and IT stakeholders to resolve data-related technical issues and provide application support.
  • Coordinate and oversee third-party engineers through solution design reviews, code reviews, and process reviews.
  • Identify and implement process improvements, including automating manual work and optimizing data delivery and infrastructure scalability.
  • Research and evaluate new technologies, methodologies, and architectures for viability.
  • Build and maintain a service-based architecture for web and mobile applications.
  • Contribute to frameworks, guidelines, best practices, and examples to ensure data structures and integration processes are accurate, compliant, and secure.
  • Implement telemetry, quality metrics, and access controls to monitor performance, accuracy, and compliance.

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 Microsoft SQL Server expertise, including on-prem and Azure SQL, advanced T-SQL, query design, execution plans, index strategies, partitioning, statistics, and concurrency/isolation levels.
  • Strong data modeling knowledge, including 3NF normalization, strategic denormalization, star/snowflake schemas, surrogate vs. natural keys, referential integrity, and temporal tables.
  • Experience performing operational analysis on data and processes to identify failure points and improvement opportunities.
  • Experience designing and implementing API-oriented schemas for web and mobile application performance and optimization.
  • Knowledge of data preparation, metadata, dependencies, lineages, compliance, and workload management.
  • Security and governance experience, including RBAC, least privilege, secrets management, PII handling, encryption, row-level security, auditing, and compliance such as SOC2, HIPAA, or GDPR.
  • Extensive experience with Microsoft Fabric, including pipelines, notebooks, Lakehouse/Warehouse concepts, and Medallion architecture.
  • Experience with Azure DevOps CI/CD pipelines for AIS and Fabric assets.
  • Experience with ETL/ELT and data movement tools and patterns such as SSIS, ADF/Azure Data Factory, dbt, Airflow, CDC/change tracking, bulk load utilities, and data quality checks.
  • Experience designing metadata-driven and reusable integration patterns.
  • Experience with API Management, including API design, security with OAuth/JWT, policies, and versioning.
  • Experience reverse-engineering, refactoring, and migrating legacy applications.
  • Experience with Service Bus and Event Grid design patterns for asynchronous and event-driven integrations.
  • Experience with scripting languages such as Python.
  • Experience with MDM concepts such as golden record, survivorship, matching, and data quality.
  • Commitment to client confidentiality and data security.
  • Ability to communicate clearly in a service-oriented and professional manner.
  • Ability to work proactively with internal and external clients in a collaborative, professional manner.
  • Ability to maintain regular, predictable attendance.

Benefits

  • Competitive salary with a base pay range of $120,000 to $126,000 annually.
  • Medical, dental, and vision insurance.
  • Company 401(k) and ESOP contribution.
  • Generous sick, vacation, and maternity/parental leave.
  • Paid holidays.
  • Professional development opportunities.
  • Tuition reimbursement up to a $15,000 lifetime cap.
  • Discounted personal insurance, including home, auto, and recreational vehicles.
  • Charitable gift-matching program and Davidson Day of Giving community impact tradition.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Senior Data Engineer + AI

Coforge 10K-50K IT Services

Coforge is hiring a Senior Data Engineer + AI to build and maintain cloud-native data platforms and AI-powered applications for internal and customer-facing use.

Apache Spark AWS CI/CD Databricks dbt LLM Python SQL TypeScript
13 hours, 46 minutes ago

Senior Data Engineer

CodeRoad 51-250 Internet Software & Services

CodeRoad is hiring a Senior Data Engineer to own end-to-end data architecture and pipelines for a remote Latin America team, building a trusted single source of truth that supports Finance and Operations.

Apache Airflow dbt FastAPI Flask Flink GCP Kafka Microservices Python SQL Terraform
13 hours, 46 minutes ago

Principal Data Engineer

EnergyHub 51-250 Utilities

EnergyHub is hiring a Principal Data Engineer to build and evolve data systems that power electric vehicle, IoT, and grid-related energy products for a cleaner and more resilient electric grid.

Apache Airflow AWS CI/CD dbt IoT Java Machine Learning MongoDB Python REST API Snowflake SQL System Design Tableau
13 hours, 46 minutes ago

Senior Engineer - Platform & Data Infrastructure

Ampd Energy 51-250 Electrical Equipment

Ampd Energy is hiring a senior software engineer to own and scale the cloud telemetry platform behind its battery energy storage fleet, improving reliability, performance, and cost as device volume grows.

AWS ClickHouse Go Grafana GraphQL InfluxDB Kafka NestJS Node.js REST API SQL Terraform TimescaleDB TypeScript Vue.js
2 days, 12 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers