D.A. Davidson - Data Engineer
Requirements
• 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 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 • Experience facilitating calls to capture 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 like: o Conceptual data modeling o Logical data modeling o Relational data modeling o Dimensional and multi-dimensional data modeling • Understanding of meta-model and metadata management requirements • Specific skills include: o Extensive experience with SQL syntax o Experience designing and implementing data structures and interfaces for applications and business processes o Experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture o Experience with relational database platforms: preferably MS SQL Server o Experience with data pipeline tools such as: SSIS and Azure Integration Services o Experience using orchestration tools such as: ActiveBatch o Experience with web services and API integrations o Experience with scripting languages such as: Python and Powershell o Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc. • Commitment to maintain client confidentiality and data security • Communicate in a clear and service-oriented manner; use appropriate, professional language and grammar to effectively exchange ideas and information • Ability to proactively work with both external and internal clients; relate with others in a professional manner to accomplish work responsibilities and objectives • Ability to maintain regular, predictable attendance
Responsibilities
• Job Responsibilities:• Design, implement and maintain a robust, efficient and compliant data pipeline architecture • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. • 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 • Work in an on-call rotation to monitor, troubleshoot and resolve data integration alerts and failures
Benefits
• Competitive salary plus excellent benefits and perks including, but not limited to: • 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 – Our tradition of positively impacting communities in which we live and work. • The potential base pay hiring range for this role is $73,500 – $117,900 annually. The compensation offered will be determined on a case-by-case basis considering a variety of factors including, but not limited to, the skills, relevant work experience, and geographic location of each specific candidate. • $73,500 - $117,900 a year • At D.A. Davidson, we are committed to fostering a diverse environment that supports the development and inclusivity of all employees.
Apply in one click
Upload My Resume
Drop here or click to browse · Tap to choose · PDF, DOCX, DOC, RTF, TXT