Senior Engineer, Data & Analytics

Kehe Food Distributors • Naperville, IL

139d • $95,700 - $130,000

About The Position

At KeHE, we're obsessed with creating solutions, unboxing potential, and serving others - and it all starts with you. As an employee-owned distributor of natural and organic, specialty, and fresh products, we're committed to making a positive impact and scaling our success together. With a culture that fosters development and opportunity, you'll be embarking on a career that's moving forward. When you join KeHE, you're becoming part of a team that is a force for good.

Requirements

• Bachelor's degree in Finance, Computer Science, Information Systems, Operations Research, Mathematics, Statistics, or related 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.)
• Strong understanding of data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
• Strong knowledge 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).
• Ability to work with stakeholders and changing priorities.
• Ability to learn and apply new technologies to business problems.
• Strong communication skills both verbally and written.
• Ability to work independently and in a team environment.
• Ability to multitask tasks.
• Expert knowledge of Python and C#.

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.
• Architects and manages scalable data pipelines across on-premises and cloud data repositories.
• Creates data flow diagrams, and document source to target mapping.
• Utilizes their business acumen, analytical mindset, and strong communication/people skills to extract business requirements and translates them into actionable tasks.
• Maintains the data warehouse performance by optimizing batch processing through parallelization, performance tuning, aggregations etc.
• Creates user-facing dashboards that provide key insights for its specific audience.
• Recognizes and adopts best practices and cost-effective solutions in developing analytical insights on prem and in the cloud.
• Provides guidance and mentors junior team members.
• Keeps current with Business Intelligence data trends and technological innovations.
• Executes on POC's with new technologies, drive innovation, and new ideas.
• Other duties and projects as assigned.

Benefits

• Health/Rx
• Dental
• Vision
• Flexible and health spending accounts (FSA/HSA)
• Supplemental life insurance
• 401(k)
• Paid time off
• Paid sick time
• Short term & long term disability coverage (STD/LTD)
• Employee stock ownership (ESOP)
• Holiday pay for company designated holidays

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Industry: Merchant Wholesalers, Nondurable Goods
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees