As the Senior Data Engineer, you will have the opportunity to make a significant impact on the success and growth of KeHE by engaging with internal business stakeholders of all levels. You will become an enabler by providing support & guidance in defining and delivering their data engineering and analytics needs by turning data into actionable information leveraging on-prem and cloud technologies.

RESPONSIBILITIES:

Demonstrated ability to partner with internal product stakeholders to help define requirements and outcomes for data-focused initiatives
Ability to decompose large problems and execute smaller, manageable bodies of work to demonstrate continuous architecture delivery
Architecting and managing scalable data pipelines across on-premise and cloud data repositories
Create data flow diagrams, and document source to target mapping
Utilizing their business acumen, analytical mindset, and strong communication/people skills to extract business requirements and translating them into actionable tasks
Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning, aggregations etc.
Create user-facing dashboards that provide key insights at a glance for its specific audience
Recognize and adopt best practices and cost-effective solutions in developing analytical insights on prem and in the cloud
Provide guidance and mentor junior team members
Keep current with Business Intelligence data trends and technological innovations
Execute on POC’s with new technologies, drive innovation, and new ideas

REQUIREMENTS:

4 Year College Degree from an accredited university in one of the following: Finance, Computer Science Information Systems, Operations Research, Mathematics, Statistics, or related technical field
7+ years leveraging Microsoft and its associated array of offerings (SQL, PL/SQL, SSIS, SSRS, SSAS, PowerBI, etc.)
5+ years leveraging AWS and its associated array of offerings (Glue, Redshift, Athena, S3, Spectrum, PySpark etc.)
You have deep expertise in Python and C#
You have collaborated with a development team with established source control (git).
Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
Strong experience with business intelligence and data warehousing design principles and industry best practices including multi-dimensional modelling (star schemas, snowflakes, de-normalized models, handling “slow-changing” dimensions)

Job Type: Full-time

Pay: $104,901.19 - $124,375.63 per year

Benefits:

401(k)
Dental insurance
Employee assistance program
Health insurance
Life insurance
Paid time off
Retirement plan

Schedule:

Monday to Friday

Application Question(s):

What is your compensation requirement?
Do you require any form of sponsorship?
Are you willing to take a coding test?

Experience:

Python: 5 years (Preferred)
SQL: 5 years (Preferred)
PySpark: 5 years (Preferred)
AWS Lambda: 5 years (Preferred)
AWS S3: 5 years (Preferred)
AWS Redshift: 5 years (Preferred)

Ability to Relocate:

Naperville, IL 60563: Relocate before starting work (Required)

Work Location: Hybrid remote in Naperville, IL 60563

KeHE Distributors jobs

Senior Data Engineer