Data Engineer

W.S. Darley & Co is hiring a Data Engineer onsite in Itasca, IL to build trusted data systems that enable decisions, automation, and AI use.

Responsibilities

• Build and maintain SQL- and Python-based data pipelines to ingest, validate, and transform data from business systems, APIs, files, and approved external sources.
• Support warehouse structures and dimensional models, including reusable tables, documented relationships, and consistent business definitions.
• Partner with infrastructure teams on secure connectivity, access, environments, scheduling, monitoring, and recovery requirements.
• Implement data quality checks, reconciliation, error handling, version control, and documentation to keep data products reliable and maintainable.
• Collaborate with reporting teams to deliver curated data sets and semantic models for dashboards and self-service analytics.
• Convert business questions into data requirements and prioritize solutions that are useful and achievable with stakeholders.
• Work with external specialists on architecture and implementation patterns, then maintain and extend solutions internally.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Data Science, Mathematics, Statistics, or a related field; advanced degree preferred.
• Equivalent combination of education, technical training, and relevant experience may be considered.
• 2–5 years of experience in data engineering, data integration, business intelligence, analytics engineering, or a related field.
• Experience building and maintaining production data pipelines.
• Experience integrating data from ERP, CRM, manufacturing, financial, operational, and third-party systems.
• Experience working with business stakeholders to translate requirements into scalable data solutions.
• Experience supporting reporting, analytics, or AI initiatives preferred.
• Strong SQL skills, including query optimization, data transformation, and database design.
• Proficiency in Python for data processing, automation, and ETL/ELT development.
• Knowledge of data warehousing concepts, dimensional modeling, and semantic data structures.
• Data quality management experience: validation, cleansing, reconciliation, and monitoring techniques.
• Experience with APIs, flat files, and structured or semi-structured data sets.
• Understanding of data governance, security, and access management principles.
• Strong analytical and problem-solving skills; ability to identify trends, anomalies, and data quality issues.
• Ability to prioritize competing requests and deliver practical solutions.
• Strong communication skills with technical and non-technical audiences.
• Ability to document technical solutions and establish repeatable processes.
• Customer-service mindset when supporting internal stakeholders.
• Ability to work cross-functionally and influence decisions through data expertise.
• Commitment to continuous learning in emerging data and AI technologies.

Technologies

• SQL
• Python
• ETL/ELT
• ERP
• CRM
• APIs
• Flat files

Benefits

• PTO
• Paid Holidays
• Tuition Reimbursement
• Health & Wellness Reimbursement
• Medical
• Dental
• Vision
• Life & Disability insurance
• HSA with Darley contribution
• FSA
• 401K/Roth with match and profit sharing

Travel

• Regular travel not required.
• Occasional travel may be requested to customer sites, OEMs, Darley sites, management meetings, or training events.

Job Details

• Full-time role working from the Itasca, IL office 4–5 days per week (onsite).
• Monday through Friday, 8:00 a.m. to 4:30 p.m. or as required to meet business needs.
• Occasional evening and weekend work may be required to support sales events, customer needs, and critical incidents.

Compensation

• $75,000–$95,000 annual base salary