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 data 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, code reviews, and process reviews.
  • Identify and implement process improvements, including automation, data delivery optimization, and infrastructure redesign for scalability.
  • Research and analyze new technologies, methodologies, and architectures for viability.
  • Build and maintain service-based architecture for web and mobile applications.
  • Contribute to frameworks, guidelines, best practices, and examples for secure, accurate, and compliant data structures and integration processes.
  • Implement telemetry, quality metrics, and access controls to monitor performance, accuracy, and compliance.

Requirements

  • 7+ 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 and Azure SQL expertise, including T-SQL, query design, execution plans, indexing strategies, partitioning, statistics, and concurrency/isolation levels.
  • Strong data modeling knowledge, including 3NF normalization, denormalization for read models, star/snowflake schemas, surrogate and natural keys, referential integrity, and temporal tables.
  • Experience performing operational analysis on internal and external data and processes to identify failure points and improvement opportunities.
  • Experience designing API-oriented schemas for web and mobile application performance and optimization.
  • Knowledge of data preparation, metadata, dependencies, lineage, compliance, and workload management.
  • Security and governance experience with RBAC, least privilege, secrets management, PII handling, encryption, row-level security, auditing, and compliance standards such as SOC2, HIPAA, and GDPR.
  • Hands-on experience with Microsoft Fabric, Azure DevOps CI/CD, ETL/ELT and data movement tools such as SSIS, ADF/Azure Data Factory, dbt, or Airflow, plus CDC/change tracking, bulk load methods, APIM, Service Bus/Event Grid patterns, Python, and MDM concepts.
  • Commitment to client confidentiality, data security, clear professional communication, proactive collaboration, and 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 leave, 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.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Senior BI & Data Integration Lead

Freelance Latin America 1-10 Professional Services

Freelance Latin America is hiring a highly autonomous Senior BI & Data Integration Lead to support SMB consulting clients with Power BI, data integration, automation, and business analysis for executive-level reporting.

Git Pandas PostgreSQL Power BI Python SQL
2 hours, 42 minutes ago

Middle Data Engineer + AI experience

GlobalDev Tech 51-250 Internet Software & Services

This role is for a Data Engineer at a growing project, focused on building and improving data pipelines, integrations, and AI-driven automation for business workflows.

Apache Airflow AWS CI/CD dbt Docker LLM Python
3 hours, 34 minutes ago

[Job - 29279] Mid Data Deveolper (AWS), Brazil

CI&T 5K-10K Internet Software & Services

CI&T is hiring a Mid Data Developer focused on AWS applications to build and optimize data processing pipelines that consolidate data from multiple applications in a remote/home office setting in Brazil.

Agile Apache Spark AWS Go Python REST API
8 hours, 17 minutes ago

GCP Data Engineer- Lead Consultant

Lingaro 5K-10K IT Services

Lingoarians is hiring a GCP Data Engineer Lead Consultant in India to design and develop a client’s end-to-end Google Cloud data ecosystem while working directly with stakeholders in a remote, full-time role.

Apache Airflow Apache Spark Azure Confluence Databricks dbt GCP Git JIRA Looker Power BI Python SQL Tableau
8 hours, 46 minutes 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