Data Engineer

The Data Engineer role at D.A. Davidson focuses on scaling and optimizing data and data pipeline architecture, while monitoring and tuning data flows that support the collection, integration, and provisioning of enterprise data. The position partners with software development teams and other stakeholders to ensure data delivery follows established best practices.

Responsibilities

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

Requirements

• 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.
• Ability to perform operational analysis on internal and external data and processes to identify failure points and improvement opportunities.
• Strong analytical capability working with complex, multi-layered data pipelines and dependent datasets.
• Experience facilitating calls to gather end-user requirements with technical and non-technical users.
• 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
  • Dimensional and multi-dimensional data modeling
• Understanding of meta-model and metadata management requirements.
• Commitment to maintain client confidentiality and data security.
• Clear, service-oriented communication using appropriate professional language and grammar.
• Ability to proactively work with external and internal clients in a professional manner.
• Ability to maintain regular, predictable attendance.

Technologies

• Microsoft cloud-based technologies
• TSQL
• Relational databases
• Stored procedure development
• Microsoft Fabric
• Pipelines and notebooks
• 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, automated deployment
• Recoverability and telemetry

Location

Oregon (onsite)

Compensation

Salary range: USD 73,500 - 117,900 per yearly

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 ($15,000 lifetime cap)
• Discounted personal insurance including home, auto and recreational vehicles
• Charitable gift-matching program
• Davidson Day of Giving

What We Offer

Competitive salary plus excellent benefits and perks, including but not limited to the benefits listed above.