Data Engineer
Company: KeHE Distributors
Location: Naperville
Posted on: April 18, 2024
|
|
Job Description:
Why Work for KeHE?Full-time
Pay Range: $75,000.00/Yr. - $105,000.00/Yr.
Shift Days: , Shift Time:
Benefits on Day 1
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 OverviewGood people,
working with good people, for our common good.Sound good?KeHE-a
natural, organic, specialty and fresh food distributor-is all about
\"good\" and is growing, so there's never been a more exciting time
to join our team. If you're enthusiastic about working in an
environment with a people-first culture and an organization
committed to good living, good food and good service, we'd love to
talk to you! Primary ResponsibilitiesAs an 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 across the business, consult with them, and provide
support & guidance in defining and delivering their BI needs by
turning data into actionable information.You will also be
responsible for the design of the data warehouse data/information
architecture, which maps to the data warehouse architecture and
balances the need for access against security and performance
requirements.This position provides strategic enterprise data
technical vision (3-5 years out) while directing immediate tactical
data architecture initiatives. Additionally, the position will
ensure the overall quality of technology data implementations
across multiple domains, including data management, data
integration, data quality, data reporting, and data analytics
supporting multiple business units, development and operations
managers, and their teams. Essential FunctionsOwns the Solution
Architecture and ensures best practices and internal processes are
followed when solutions are designed and implementedAbility to work
on multiple projects and tasks with overlapping time frames and
facilitate construction of 90 day forecastCollaborate with
cross-functional teams for effective management of the DW/BI
environment.Perform full lifecycle Business Intelligence (BI)
development, working closely with stakeholders Identify data
sources, provide data flow diagrams, and document source to target
mapping and process.Design and develop SQL for large complex ETL
jobs and conduct related database maintenancePropose innovative SQL
Server Analysis Services tabular models for solving ambiguous
business problemsDevelop data models and data pipelines in AWS
cloud environment leveraging data lake and RedshiftMaintain the
data warehouse performance by optimizing batch processing through
parallelization, performance tuning, aggregations etc.Design,
develop, and maintain intuitive, scalable reports, dashboards, and
metrics using Microsoft reporting platformRecognize and adopt best
practices in developing analytical insights including data
integrity, analysis, test design, validation, and
documentation.Proactively promotes data quality and security
through recommended approaches and practicesLead and coordinate
implementation activitiesProvide guidance and mentor junior team
members Keep current with Business Intelligence data trends and
technological innovationsExecute on POC's with new technologies,
drive innovation, and new ideas Minimum Requirements,
Qualifications, Additional Skills, Aptitude4 Year College Degree;
Computer Science or related discipline or equivalent experience10+
years of direct experience using databases, including Oracle,
MySQL, or SQL Server10+ years hands-on experience developing with
SQL, PL/SQL, SSIS, SSAS (Tabular), PowerBIAbility and experience in
leading teamsStrong 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)Cloud architecture experience,
preferably in AWS (Azure or Google will also be
considered)Effective problem-solving and analytical skills. Ability
to manage and prioritize multiple projects and report
simultaneously across different stakeholders.Expert knowledge on
T-SQL / DAX Strong communication skills, both verbally, and
writtenStrong work ethic and ability to work in a dynamic
environmentAbility to learn and apply new technologies to business
problemsAbility to learn and adapt quickly to changing BI
LandscapePreferred Requirements:Knowledge of modern development
techniques: Agile (Scrum, Kanban)Experience with automation using
but not limited to Java, C#, Python, Pyspark Requisition
ID2024-22906 Equal Employer Opportunity StatementKeHE Distributors
provides equal employment opportunities to all employees and
applicants for employment and prohibits all forms of discrimination
and harassment on the basis of race, color, religion or faith, sex,
gender, age, ancestry, national origin, mental or physical
disability or medical condition, sexual orientation, gender
identity or expression, marital status, military or veteran status,
genetic information, or any other category protected under federal,
state, or local law. This policy applies to all terms and
conditions of employment, including recruiting, hiring, placement,
promotion, termination, layoff, recall, transfer, leaves of
absence, compensation and training as well as the administration of
all Human Resources and Talent Acquisition processes.
Keywords: KeHE Distributors, Carol Stream , Data Engineer, Engineering , Naperville, Illinois
Click
here to apply!
|