Full-Time

Data Engineer

Data Integration & Analytics

Confirmed live in the last 24 hours

SunSource

SunSource

1,001-5,000 employees

Distributes fluid power components and systems

Automotive & Transportation
Industrial & Manufacturing

Senior

Elmhurst, IL, USA

Position requires onsite presence in Addison, IL.

Category
Data Analysis
Data Engineering
Data & Analytics
Required Skills
Python
Apache Spark
SQL
Databricks
Requirements
  • Bachelor’s degree in computer science, Engineering or Information Systems
  • 5+ years of relevant experience with at least 2 years of Integration / ETL experience
  • Strong experience with ETL techniques, data processing concepts, and programming in Python (e.g., change data capture, slowly changing dimensions, data partitioning in Spark)
  • Experience in data modeling and entity relationship diagram conventions and various data modeling patterns (e.g. – dimensional model, 3rd normal form)
  • Experience with relational databases, including an understanding of SQL Server Database Management Systems (RDBMS) concepts
  • Minimum of 2 years of experience working in a large organization
  • Able to work flexible hours as required by business priorities
  • Limited travel may be required
Responsibilities
  • Perform BI solution development activities including requirements gathering, technical specifications, ETL design & development, unit & integration testing
  • Develop and support backend data models and ETL workflows on Databricks, with a focus on building scalable data processing pipelines using Python and Spark
  • Support data integration between supplier partners to provide accurate and up to date information to our internal and external customers
  • Review, interpret, and debug complex code. Develop maintainable code via proper structures, comments, and design
  • Generate automated, repeatable and stable processes to support data transformation, data load, data movement, and data synchronizations
  • Contribute toward the continuous improvement of our internal data capabilities
  • Perform source data analysis – data profiling, validation, conceptual and logical data modeling, etc. – to determine the suitability of the source data for meeting the reporting requirements
  • Facilitate and lead senior IT and business teams through challenging data issues
  • Meet with subject matter experts in different areas of the business, be able to quickly learn the concepts and business language relevant to their line of business, and develop an understanding of how their data supports their business processes
  • Assist in developing the roadmap for Analytics and Advanced Analytics across the company to enable the business strategy
  • Participate in information architecture strategies such as data management, data governance, master data management and metadata management
Desired Qualifications
  • Relevant certifications preferred
  • Power BI Experience
  • Experience with Advanced Analytics – Optimization, Machine Learning and/or Predictive Analytics
  • Experience with the latest technology trends in cloud data platforms
  • Experience with SSIS based ETL

SunSource distributes fluid power components and systems for industries such as OEM, MRO, and mobile equipment. Their services include design and engineering support, supply chain optimization, and repair capabilities. By focusing on customer service and technical support, SunSource helps clients reduce maintenance costs and improve productivity. Unlike competitors, SunSource combines a national reach with a strong local presence, ensuring tailored solutions for customers. The company's goal is to provide high-quality products and services that drive growth and meet customer needs.

Company Stage

N/A

Total Funding

N/A

Headquarters

Windsor, California

Founded

2001

Simplify Jobs

Simplify's Take

What believers are saying

  • Growing demand for energy-efficient hydraulic systems boosts SunSource's market potential.
  • IoT integration enhances predictive maintenance, reducing downtime and improving efficiency.
  • Rise of electric and hybrid equipment creates new opportunities for component supply.

What critics are saying

  • Competition from online marketplaces like Amazon Business threatens traditional distributors.
  • Electric and hybrid equipment may reduce demand for traditional fluid power components.
  • Supply chain vulnerabilities could impact SunSource's ability to meet customer demands.

What makes SunSource unique

  • SunSource offers comprehensive services including design, engineering, and supply chain optimization.
  • The company has over 85 years of experience in the fluid power sector.
  • SunSource emphasizes associate development and strong customer-supplier relationships.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Health Insurance

Dental Insurance

Vision Insurance

Life Insurance

Paid Vacation

Paid Sick Leave

Paid Holidays

401(k) Company Match

Tuition Reimbursement