Data Engineer

Role Overview

The Data Engineer is responsible for expanding and optimizing our data and data pipeline architecture, as well as monitoring, troubleshooting and performance tuning data flows used in the collection, integration, and provisioning of data.

What You Will Do

Design, implement and maintain a robust, efficient and compliant data pipeline architecture, identify and implement internal process improvements, build and maintain a service-based architecture for the publication of consumable data and information objects.

Why It Might Be a Fit

The ideal candidate will have experience building data pipelines and optimizing entire data systems, as well as greenfield opportunities, and will be able to work alongside other software development teams, database architects, data analysts and end users on complex data initiatives.

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 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 conceptual data modeling, logical data modeling, relational data modeling, dimensional and multi-dimensional data modeling
• Understanding of meta-model and metadata management requirements
• Specific skills include experience with SQL syntax, designing and implementing data structures and interfaces for applications and business processes, experience with Microsoft Fabric, pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture, experience with relational database platforms, experience with data pipeline tools, experience with orchestration tools, experience with web services and API integrations, experience with scripting languages, commitment to maintain client confidentiality and data security, ability to proactively work with both external and internal clients, ability to maintain regular, predictable attendance

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 – Our tradition of positively impacting communities in which we live and work.

Tagged as: Data Analysis, Pipeline Management, SQL