Senior BI Engineer (Database Administration) at KeHE Distributors

| West Suburbs
Sorry, this job was removed at 7:08 a.m. (CST) on Thursday, October 14, 2021
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Overview

Where KeHE goes, goodness follows.

KeHE has grown tremendously over the years by exceeding expectations and bringing goodness in all we do. We're now bringing that same goodness to our workforce by creating friction-free processes.

We're focused on simple and intuitive ways to work. We're building systems where our employees come together each day and do what truly makes us human; collaborate, share, and connect.

You'll have the opportunity to expand and apply your skills in new and interesting ways. And you'll have fun doing it. Join a team where our collective intelligence, collective effort, and collective passion is brought together to do something worth doing!

The KeHE tech teams ensure each person has the tools, proper connectivity, and a comfortable remote/work-from-home setup for qualifying roles. Even as we begin safely welcoming employees back to our HQ office in Naperville, 100% remote work will continue to be an option for this position. At this time, we are not providing visa sponsorship for this position. All qualified applicants must be authorized to work in the U.S. without sponsorship.

Primary Responsibilities

As the Senior BI Engineer, (Database Administration) 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 consult with them, provide support & guidance in defining and delivering their BI needs by turning data into actionable information leveraging AI - Machine learning.

  • Architecting scalable data pipelines across on-premise and cloud data repositories
  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning, aggregations etc.
  • 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
  • Create user-facing dashboards that provide key insights at a glance for its specific audience
  • Assist in optimal database design that helps report and dashboard query performance
  • Analyze reporting queries and optimize their design
  • 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, optimization techniques, drive innovation, and new ideas

Essential Functions

See above.

Minimum Requirements, Qualifications, Additional Skills, Aptitude

  • 4 Year College Degree from an accredited university in one of the following: Computer Science Information Systems, Operations Research, Mathematics, Statistics, or related technical field
  • 7+ years of direct experience using databases, including Oracle, MySQL, or SQL Server
  • 5+ years hands-on experience developing with SQL, PL/SQL, SSIS, SSAS (Tabular), PowerBI, PowerApps
  • Hands-on experience in database management activities such as partitioning, replication, performance tuning and index management
  • 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 "slowly-changing" dimensions)
  • Ability to learn and apply new technologies to business problems

You would be a great fit if:

  • You love a challenge and problem solving
  • Enjoy learning and working with new technologies
  • You are extremely articulate and concise
  • You are proactive and resourceful with a drive to match
  • You have an intrinsic curiosity for tinkering with data products
  • You recognize the importance of data storytelling
  • You have excellent written and verbal skills
  • You are hardworking and have a strong work ethic
  • You are a quick learner and able to apply new technologies to business problems

Requisition ID

2021-12691
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
    • .NETLanguages
    • C#Languages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • Twitter BootstrapLibraries
    • RxJSLibraries
    • AngularFrameworks
    • NgRxFrameworks
    • IonicFrameworks
    • DB2Databases
    • Microsoft SQL ServerDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • AxureDesign
    • BalsamiqDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • JIRAManagement

Location

Easy commute off of I-88 | Walking distance to variety of cuisine options | LA Fitness in the complex (where you get a major discount) | ample parking

An Insider's view of KeHE Distributors

What’s the vibe like in the office?

KeHE is the perfect blend of hard work and diverse culture while maintaining a vibe that is fun and collaborative. It's not just a group of professionals paid to do the work, but instead everyone is part of a team working towards a common goal.

Moe Khan

Sr. Software Automation Engineer

How do you collaborate with other teams in the company?

As the Manager of UI/UX Design, we work alongside & collaborate daily with engineers, product managers, and KeHE stakeholders to advocate UX & consistency across applications. The most exciting part about working for KeHE, besides the great people, is innovation - leading us to deliver high quality digital solutions transforming the food industry.

Ashley Plumb

User Experience Manager

What are some things you learned at the company?

Engineering isn't just about writing code. Understanding the needs of our users and translating those needs into a better product is a huge part of our day-to-day. Writing clean, performant code is fun and exciting, but if we don't deliver a functional product to our users at the end of the day, none of that matters.

Daniel

Lead Engineer

What are some social events your company does?

This year, the IT department at KeHE held their inaugural hackathon. It gave us the opportunity to collaborate and strengthen friendships in the spirit of friendly competition, as well as work with new and emerging technology. I cannot wait to see what is in store for next year’s hackathon!

Anthony Gacek

Software Engineer

What are KeHE Distributors Perks + Benefits

KeHE Distributors Benefits Overview

We are proud of our comprehensive benefits package - one that protects our employees and their families. Some benefits are provided automatically at no cost. Other benefits are available by choice. The benefits we offer are an important part of our total rewards which includes pay, benefits, and long-term career growth. Unique to being an employee-owned company, our team members are eligible to receive shares in the company through our Employee Stock Ownership Plan. For our tech teams, remote work will continue to be an option.

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Diversity manifesto
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
-Company-paid STD policy at 60% of weekly earnings -Company-paid LTD at 50% of weekly earnings
Dental Benefits
Vision Benefits
Health Insurance Benefits
3 Medical Options: - BCBS Health Care Plan (Full FSA allowed) - BCBS Health Savings Plan (Limited FSA & HSA allowed) - BCBS Value Plan (Limited FSA & HSA allowed Company pays majority of premium
Life Insurance
Company-paid policy 1.5 x annualized salary.
Wellness Programs
-Virgin Pulse (Opportunity to earn up to $300 incentive yearly. -Marketplace Care Partners -EAP through ComPsych -Free biometric screenings
Mental Health Benefits
-Marketplace Care Partners -EAP through ComPsych
Retirement & Stock Options Benefits
401(K)
Company Equity
What is an ESOP? An ESOP is a retirement plan known as an “employee stock ownership” plan. Under this type of Plan, the Company makes contributions into employees’ accounts.
Performance Bonus
Match charitable contributions
KeHE may match charitable contributions for our "KeHE Cares" partners for special circumstances.
Child Care & Parental Leave Benefits
Child Care Benefits
Through KeHE's Flexible Spending Account option, employees can set aside pre-tax dollars towards child care expenses.
Flexible Work Schedule
For corporate and sales, we offer in-office flex, hybrid, and 100% remote opportunities that are position-specific.
Remote Work Program
A select number of positions in corporate and sales offer the ability to work 100% remote.
Family Medical Leave
In addition to FMLA, KeHE offers an additional 12 weeks of medical leave (unpaid) with supporting medical documentation.
Company sponsored family events
Vacation & Time Off Benefits
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Company Outings
Parking
Fitness Subsidies
Gym discounts nationwide.
Home Office Stipend for Remote Employees
Monthly earnings of $20-60/mo. for remote positions meant to subsidize cell phone and/or internet coverage.
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
We offer $2500 annually for continuing education.
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Mentorship program
Time allotted for learning
Online course subscriptions available

Additional Perks + Benefits

Employee Stock Ownership Plan (ESOP)
In addition to the 401(k) Retirement Savings Plan, KeHE also provides you with the opportunity to share in the company’s financial success through an Employee Stock Ownership Plan. KeHE will make contributions on your
behalf to the ESOP. You do not contribute any of your own money.

ESOP Highlights:
• The plan provides eligible employees an opportunity to share in the profitability and growth of KeHE and to earn additional income for retirement.
• The plan provides a stake in the company’s success.
• The ESOP is not directly affected by the ups and downs of the stock market.
• What we do each day and how the company performs directly impacts the ESOP.

More Jobs at KeHE Distributors37 open jobs
All Jobs
Finance
Data + Analytics
Dev + Engineer
HR + Recruiting
Internships
Marketing
Operations
Project Mgmt
Sales
Internships
new
West Suburbs
Operations
new
West Suburbs
Marketing
new
West Suburbs
HR + Recruiting
new
West Suburbs
Operations
new
West Suburbs
Data + Analytics
new
West Suburbs
Operations
new
West Suburbs
Data + Analytics
new
West Suburbs
Developer
new
West Suburbs
Developer
new
West Suburbs
Operations
new
West Suburbs
Project Mgmt
new
West Suburbs
Sales
new
West Suburbs
Internships
new
West Suburbs
Internships
new
West Suburbs
Internships
new
West Suburbs
Internships
new
West Suburbs
Internships
new
West Suburbs
Internships
new
West Suburbs
Developer
new
West Suburbs
Data + Analytics
new
Remote
Data + Analytics
new
West Suburbs
Developer
new
West Suburbs
Operations
new
West Suburbs
Developer
new
West Suburbs
Data + Analytics
new
West Suburbs
Marketing
new
Chicago
HR + Recruiting
new
West Suburbs
Operations
new
West Suburbs
Developer
new
West Suburbs
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView KeHE Distributors's full profileSee more KeHE Distributors jobs