Kilcoy Global Foods North America ยท 7 hours ago
Business Intelligence Engineer
Mundelein,IL,US
Full-time
Onsite
Senior Level
5+ years expKilcoy Global Foods North America is seeking a Business Intelligence Engineer to oversee the strategy, design, implementation, and administration of their data warehousing and reporting systems. The role involves enhancing existing reporting solutions and transitioning to a cloud-based data warehouse while collaborating with end users and IT teams.
Food and BeverageManufacturingMeat and PoultryRetailWholesale
Responsibilities
Ensures high availability and end user self-service of reporting and data solutions
Designs and implements a migration strategy to move towards a cloud based BI data warehouse
Builds, supports and enhances exiting Power BI, Crystal Reports and excel solutions based on business requirements identified by key stakeholders and end users
Designs, implements and maintains all data connectors for cloud data warehouse ingestion
Automates report creation and push notifications / exceptions around data and business intelligence
Manages and maintains multiple SQL databases for performance, security and quality
Gathers requirements needed to support report/solution creation by collaboratively engaging with local and offsite stakeholders
Manage third-party service vendors and report progress to IT management
Conducts casual and formal training on best practices with end users
Primary contact and ownership for data, reporting and BI in the event of after-hour emergencies
Qualification
Required
Bachelor's degree in information systems, Engineering, Business, or related field/equivalent experience
5-10 years of relevant data reporting systems experience and toolset
2+ years of cloud based data warehouse / business intelligence tools
Power BI/ Fabric experience with DAX as Must
Extensive experience with SQL Server and SSAS (Tabular) databases required
Ability to design, support and implement new versions and report enhancements of MS-excel, Power BI and Crystal Reports
Demonstrated ability to perform advanced TSQL queries/joins (CRUD operations) as well as SQL database management and normalization of different databases and repositories
Create SSIS packages to ingest new data into the data warehouse
Ability to investigate data/tables/schemas and reverse engineer data dictionary mappings and relationships
Demonstrated ability to manage, profile and troubleshoot SQL database issues queries and performance
Demonstrated ability in ETL package creation/automation and data replication/shipping
Demonstrated ability to translate business domain subject matter and perform data analysis and reports against business databases and/or applications
Excellent time management skills with ability to handle multiple tasks concurrently as well as prioritization
Ability to think holistically to create standardized solutions from multiple different requests and datasets
Ability to act as a liaison between end users and technical staff to help align scope and provide solutions to address business and stakeholders' data and reporting needs
Must be attentive to detail
Ability to think critically, both quantitatively and qualitatively
Ability to stand or sit for an extended period of time
Ability to frequently reach, grasp, stoop, bend, push, pull, kneel, squat, and twist to store or retrieve materials
Dexterity of hand and fingers to operate a computer keyboard
Vision: Must possess vision (which may be corrected) to read small print and computer screens
Speech and Hearing: Must possess hearing (which may be corrected) to use a telephone and to hear discussions and questions. The individual is required to speak clearly and distinctly
Ability to lift up to 40 lbs
Stand and walk in cold temperatures (38 degrees) for several hours, when needed
Preferred
Understanding of Generally accepted accounting principles (GAAP) preferred
Experience with data warehousing of ERP systems preferred
Food Service Commercial product industry experience preferred
Experience with Microsoft Azure preferred
Experience with SQL advanced toolsets such as REDGATE SQL Toolbelt preferred
Experience operating in Agile/SCRUM teams preferred
Familiarity with Accounting, Sales, and Supply Chain business functions a plus
Company
Kilcoy Global Foods North America
Our roots run deep, first taking hold in Chicago's fabled meatpacking district in 1860.
201-500 employees
H1B Sponsorship
Kilcoy Global Foods North America has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (1)
2022 (2)
2020 (1)
Funding
Current Stage
Growth StageLeadership Team
Lupe Roznowski
Human Resources Business Partner
Samantha Lehnert
HR Business Partner
Company data provided by crunchbase