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

Azure Data Engineer

Lingaro 5K-10K IT Services

Azure Data Engineer at CC Data Engineering & Management – Data E&M in Poland is a full-time remote role focused on data engineering and management work.

Azure
4 minutes ago

Lead Data Engineer

Arcadia 251-1K IT Services

Arcadia is seeking a Lead Data Engineer to design and deliver healthcare data pipeline connectors that integrate client claim and clinical data platforms with its analytics solution for providers and payers.

Agile Apache Spark AWS EC2 Java JIRA Kafka Python Scrum SQL
4 minutes ago

Data Engineer- AWS/Snowflake

Egen.ai IT Services

Egen is seeking a remote Data Engineer for a 6-month contract to support cloud data platform migration and analytics data delivery across AWS, Snowflake, and BI environments.

Apache Airflow AWS dbt GCP Looker Python Snowflake SQL Tableau
4 minutes ago

Senior Data Engineer

Zencore Group 11-50 Internet Software & Services

Zencore is hiring a Senior Data Engineer in Europe to work remotely with customer teams on Google Cloud data and application modernization initiatives, helping design and execute cloud data solutions that reduce risk and accelerate migration timelines.

Apache Airflow Apache Spark dbt GCP Hadoop Java Python Scala Snowflake SQL Terraform
4 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