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:
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