Data Engineer

D.A. Davidson; Portland (OR); Presencial; USD 74.000 - 118.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical, Dental and Vision

Company 401(k) and ESOP contribution

Generous sick, vacation, and maternity

Paid holidays

Professional Development Opportunities

Tuition Reimbursement (lifetime cap of

Discounted personal insurance

Charitable gift-matching program

Davidson Day of Giving

Descripción de la vacante

D.A. Davidson is seeking a Data Engineer in Oregon to expand and improve data pipeline architecture with focus on reliability, performance tuning, and operational monitoring of data flows that collect, integrate, and provision data.

The role emphasizes collaboration with data architects and analysts, developing scalable, compliant data environments, and implementing standards for data quality and protection. On-call rotation is required.

Formación

• 5+ 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 T-SQL knowledge, including relational databases, query writing, stored procedures, and end-to-end data pipeline development.
• Experience performing operational analysis on internal and external data to identify failure points and improvement opportunities.

Responsabilidades

• Design, implement, and maintain a robust, efficient, and compliant data pipeline architecture.
• Identify, design, and implement internal process improvements, including automation of manual processes and data delivery optimization.
• Build and maintain a service-based architecture for publishing consumable data and information objects.
• Partner with data architects and data analysts to enhance and evolve the data environment.
• Collaborate with Business and IT stakeholders to address data-related technical issues and support data requirements.
• Define frameworks, guidelines, best practices, and examples for secure data structures and integration processes.
• Facilitate data quality, data protection standards, and enterprise adoption requirements.
• Define performance indicators and quality metrics, ensuring compliance with policies and adoption requirements.
• Participate in an on-call rotation to monitor, troubleshoot, and resolve data integration alerts and failures.

Conocimientos

Data pipelines

SQL

T-SQL

Azure

Microsoft Fabric

Monitoring & On-call

DevOps

Data modeling

Herramientas

MS SQL Server

SSIS

Azure Integration Services

ActiveBatch

Web services & APIs

Python

PowerShell

Descripción del empleo

The Data Engineer role at D.A. Davidson focuses on expanding and improving data and data pipeline architecture, with an emphasis on reliability, performance tuning, and operational monitoring of data flows that collect, integrate, and provision data.

Key Responsibilities

• Design, implement, and maintain a robust, efficient, and compliant data pipeline architecture
• Identify, design, and implement internal process improvements, including automation of manual processes, optimization of data delivery, and infrastructure redesign for greater scalability
• Build and maintain a service-based architecture for publishing consumable data and information objects
• Partner with data architects and data analysts to enhance and evolve the data environment
• Collaborate with Business and IT stakeholders to address data-related technical issues and support data and information requirements
• Define and develop frameworks, guidelines, best practices, and examples to support accurate, compliant, and secure data structures and integration processes
• Facilitate the development and implementation of data quality standards, data protection standards, and enterprise adoption requirements
• Define performance indicators and quality metrics, ensuring compliance with data policies, standards, roles and responsibilities, and adoption requirements
• Participate in an on-call rotation to monitor, troubleshoot, and resolve data integration alerts and failures

Required Qualifications

• 5 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, including experience with relational databases, query authoring, stored procedure development, and end-to-end data pipeline development
• Experience performing operational analysis on internal and external data and processes to uncover failure points and identify improvement opportunities
• Strong analytical skills working with complex, multi-layered data pipelines and dependent datasets
• Experience facilitating calls to capture end-user requirements with technical and non-technical participants
• Holistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance, and workload management
• Understanding of data modeling concepts including conceptual data modeling, logical data modeling, relational data modeling, and dimensional and multi-dimensional data modeling
• Understanding of meta-model and metadata management requirements
• Commitment to maintain client confidentiality and data security
• Ability to communicate clearly and in a service-oriented manner using professional language and grammar
• Ability to proactively work with external and internal clients in a professional manner to accomplish responsibilities and objectives
• Ability to maintain regular, predictable attendance

Technologies and Tools

• Microsoft cloud-based technologies
• TSQL, relational databases, and stored procedure development
• Microsoft Fabric
• Pipelines, notebooks, and Lakehouse/Warehouse concepts
• Medalion architecture
• MS SQL Server, SSIS, Azure Integration Services
• ActiveBatch
• Web services and API integrations
• Python and PowerShell
• Agile, DevOps, and DataOps
• Source code control, versioning, test automation, continuous integration, and automated deployment
• Recoverability and telemetry

Location and Employment Information

Location: Oregon (onsite)

Salary Range: USD 73,500 - 117,900 per year

Experience Required: 5+ years

Benefits

• Medical, Dental and Vision
• Company 401(k) and ESOP contribution
• Generous sick, vacation, and maternity/parental leave
• Paid holidays
• Professional Development Opportunities
• Tuition Reimbursement (lifetime cap of $15,000)
• Discounted personal insurance including home, auto and recreational vehicles
• Charitable gift-matching program
• Davidson Day of Giving

What We Offer

The position includes a competitive salary and benefits and perks, including professional development opportunities.

Base Pay Potential

The potential base pay hiring range for this role is $73,500 – $117,900 annually.