Sr Data Engineer - Data Platform

D&H Distributing Co.; Harrisburg, Northern (Dauphin County, KY); Hybrid; USD 110,000 - 165,000; Full time

Benefits offered by this job

401k

Paid Time Off

Medical insurance

Dental insurance

Vision insurance

Gym Reimbursement

Work from Home Reimbursement

Employee Stock Ownership Plan

Tuition Assistance

Job summary

D&H Distributing Co. is seeking a Sr. Data Engineer – Data Platform to design, build, and maintain scalable data pipelines powering enterprise analytics and AI enablement.

You will work on SAP BDC/Datasphere integration, Databricks Lakehouse architecture, and governed data assets in a 24x7 on-call environment. The role requires strong SQL skills, ETL expertise, and experience interfacing with business users to gather requirements.

Qualifications

• Experience extracting and summarizing data from a variety of data source types using ETL tools.
• Experience writing complex SQL statements to extract and analyze data.
• Experience interfacing with business users and understanding their requirements.
• Experience with Tableau and Cognos a plus.

Responsibilities

• Analyze the existing data warehouse to ensure efficiency and accuracy for business functions and reporting.
• Modify ETL processes for a complex and maturing data warehouse.
• Support, optimize and monitor data warehousing, data modeling, data integration, BI and ETL on NETEZZA with CTAS, CBT, zone map, workload management.
• Troubleshoot data and system issues and address outages when needed.
• Maintain methods for tracking data quality, completeness, redundancy, and improvement.
• Collaborate with business users to understand data requirements and enhance data models and pipelines.
• Develop and optimize scalable data pipelines and new data source integrations.
• Proactively tune SQL code and capture lessons learned.

Skills

SQL

ETL tools

Tableau

Cognos

Data modeling

Education

Bachelor's degree

Tools

Netezza

Databricks

Job description

D&H is growing! Join 100+ year old Employee-Owned technology distributor, offering end-to-end solutions for today's resellers, retailers, and the clients they serve across the SMB and Consumer markets.

• We are empowered by our employee Co-Owners who provide the industry’s best service, and we promote a collaborative culture.
• We offer an Employee Stock Ownership Plan, 401k, Paid Time Off, Medical, Prescription, Dental and Vision benefits as well as Gym Reimbursement, Work from Home Reimbursement, Employee Purchase Program, Tuition Assistance and much more!
• As a D&H Co-Owner you receive numerous discounts on services.
• We feel strongly about giving back to the community and promoting sustainable, eco-friendly business practices.

Summary:

We are seeking a Sr. Data Engineer – Data Platform for our Data Science & Insights Department. This position is responsible for designing, building, and maintaining scalable, reliable data pipelines that power D&H’s enterprise data platform. This role supports SAP BDC/Datasphere integration, Databricks Lakehouse architecture, curated data products, and AI-ready data modeling. The Senior Data Engineer plays a foundational role in modernizing legacy data environments and delivering governed, production-grade data assets for enterprise analytics and AI enablement.

The Data Engineer will need to be analytical, technically inclined, detail-oriented, visually focused, and a self-learner. As a Subject Matter Expert in technical requirements, this role is critical in supporting and implementing data projects and solutions and effectively engaging with users and other IT staff.

Responsibilities:

As a member of the Business Intelligence team, the individual will analyze the existing data warehouse database to ensure efficiency and accuracy to business functions and operational reporting, as well as modify the ETL processes for a complex and maturing data warehouse. Responsibilities include the following:

• Support, optimize and monitor current data warehousing, data modeling, data integration, business intelligence and ETL processes on NETEZZA platform with CTAS, CBT, zone map and work-load management.
• Provide assistance in troubleshooting and resolving data and system issues, stepping in when necessary to address outages and challenges.
• Maintain methods and procedures for tracking data quality, completeness, redundancy, and improvement.
• Analyze and troubleshoot issues across various applications from Access Tools (Cognos, Tableau and Excel), Data warehouse/Data Marts on Netezza Platform.
• Actively participate in design discussions, code reviews, and project-related team meetings.
• Develop processes that facilitate data transformation, manage data structures, metadata, dependencies, and workload management.
• Collaborate with business users to understand functional and data requirements, contributing to the enhancement of data models and pipelines.
• Apply expert-level analytical and problem-solving skills to troubleshoot and resolve technical issues.
• Develop, maintain, and continuously enhance scalable data pipelines, while also developing new data source integrations to support the growing volume and complexity of data.
• Proactively maintain and tune SQL code.
• Identify and capture lessons learned, best practices, and information gained during performance of tasks.
• Be part of a 24x7 on-call rotation for after-hour and weekend production support.

Requirements:

• Bachelor’s degree (B. A.) from four-year college or university; or 8+ years related experience and/training; or equivalent combination of education and experience.
• 2+ years’ experience extracting and summarizing data from a variety of data source types using ETL tools.
• Experience in writing complex SQL statement to extract and analyze data.
• Experience interfacing with business users and understanding their requirements.
• Experience with Tableau and Cognos a plus.