Apply on Employer Site

D.A. Davidson Companies · 8 hours ago

Senior Data Engineer

Atlanta, GA

Full-time

Hybrid

Mid, Senior Level

$110K/yr - $150K/yr

7+ years exp

D.A. Davidson Companies is an independent, employee-owned company with a rich history spanning more than 80 years. The Senior Data Engineer is responsible for expanding and optimizing data and data pipeline architecture, monitoring, troubleshooting, and performance tuning data flows, and mentoring junior team members.

Financial Services

Responsibilities

Design, implement and maintain a robust, efficient and compliant data pipeline architecture

Oversee and review the work of other engineers through peer reviews, code reviews and process reviews

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc

Research and analyze new technologies, methodologies and architectures for viability

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 and implementation of data quality standards, data protection standards and adoption requirements across the enterprise

Define indicators of performance and quality metrics and ensure compliance with data related policies, standards, roles and responsibilities, and adoption requirements

Qualification

Data Engineering experienceFinancial Services experienceTSQL knowledgeSQL-based syntaxMicrosoft cloud technologiesData pipeline developmentRelational databasesData modeling conceptsData visualization technologiesAnalytic skillsAgile methodologiesDevOps practicesMentorshipSoft skills

Required

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: 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 SQLServer

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