Data Engineer

The Data Engineer role at D.A. Davidson focuses on building out and improving data and data pipeline architecture, with an emphasis on reliable data delivery, monitoring, troubleshooting, and performance tuning. The position partners with software development teams and stakeholders to ensure data delivery practices align with established best practices.

Responsibilities

• Design, implement, and maintain a robust, efficient, and compliant data pipeline architecture.
• Identify and deliver internal process improvements, including automating manual activities, optimizing data delivery, and redesigning infrastructure for greater scalability.
• Build and maintain a service-based architecture for the publication of 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 address data-related technical issues and support their data and information requirements.
• Define and develop frameworks, guidelines, best practices, and examples that support accurate, compliant, and secure data structures and integration processes.
• Support the development and implementation of data quality standards, data protection standards, and enterprise adoption requirements.
• Define performance indicators and quality metrics, and ensure alignment 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.

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 knowledge of TSQL, 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 identify failure points and improvement opportunities.
• Strong analytical skills working with complex, multi-layered data pipelines and dependent datasets.
• Experience facilitating calls to capture end-user requirements with both 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, and Dimensional and multi-dimensional data modeling.
• Understanding of meta-model and metadata management requirements.
• Commitment to client confidentiality and data security.
• Clear, service-oriented communication with appropriate 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

• 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
• API integrations
• Python
• Powershell
• Agile, DevOps, DataOps
• Source Code Control and Versioning
• Test Automation
• Continuous Integration
• Automated Deployment
• Recoverability
• Telemetry

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

Compensation and Location

• Location: Oregon (onsite)
• Salary: USD 73,500 - 117,900 per year
• Experience: 5+ years
• Potential Base Pay: $73,500 – $117,900 annually