Back to Job Search

Business Intelligence Solution Architect

  • Location: Morton Grove, Illinois, 60053
  • Job Type:Permanent

Posted 11 days ago

Intake call 3/25 at 1:30 PM
  • Position has been open one month. Received 40-50 resumes. No one worth interviewing.
  • Tenure is important to Bob
  • Looking for 10 years of IT experience but will consider 7+
  • Target salary $110-140k
  • Bob is a new Director to Bunzl. When he joined, the very hands on Manager of DW left. Backfilling his position with hands on position (no direct reports).
  • 3 people on team
  • Must have skills:
    • Power BI
    • Azure Data Factory
    • SQL Server 2012-2016
    • SSRS - 700 reports in production
    • ETL - any tool is ok
  • Huge plus if they have JD Edwards or any kind of ERP experience.
  • 100% remote right now but will go back hybrid at some point. Must be willing to do 2-3 days onsite.
  • Wants us to focus on Chicagoland at first but may be open to other locations if we are struggling.
  • Selling points
    • Very stable company who supplies to retail like Walmart, Target, Amazon, etc
    • No COVID layoffs. Company is healthy financially and investing in technology.
    • Moving from on prem to cloud
    • New CIO brought into to modernize
    • Room to advance BI maturity - no data visualization at this point and they want to move to that and self service reporting for external clients. 
  • Location:  Morton Grove
  • We are still remote, not sure when that will change or how, rumors say it may be a hybrid approach.




The BI Solutions Architect will drive and influence all aspects of data consumption, transformation, and presentation. The role will entail gathering requirements and guiding the activities of the development team. It will require excellent attention to detail and a passion for data-driven solutions. The BI Solution Architect frequently examines functional specifications for translation into system guidelines that shape product development. This role will frequently research existing systems to align projects and devise solutions suitable to those systems. They may also meet directly with clients to demonstrate solutions, answer questions regarding software capabilities and requirements, and work to resolve issues that arise during the development cycle. The overall goal of the Business Intelligence team is to discover and build meaningful presentations of data and to streamline/simplify the efforts required to achieve the results. The goal of the BI Solution architect is to help guide the team to be success.


+ Gather requirements and specifications from clients and users during the project development lifecycle. + Develop project specifications using familiarity with functional requirements and knowledge of existing systems. + Create detailed designs for database, ETL and reports. + Train and coach developers on best practices with Power BI and SQL Server tools. + Support project development lifecycle by developing schedules and test plans, preparing documentation based on analyst reports, and assembling documents for presenting project guidelines and milestones to team members. + Determine/Refine Project Scope before developers begin any major work. This may require that the Solution Architect conduct extra research on a client's existing systems and configurations to determine whether additional time, work and/or solutions are necessary to align the project with enterprise-level systems. + Engage directly with clients to provide feedback and updates (via calls, meetings, reports, presentations and demonstrations) on projects throughout the development lifecycle. + Coordinate with external vendors to develop and implement specific aspects of the software solution considering cost and timeline to ensure that vendors meet deadlines for deliverables and project elements. + Hands-on use of tools to prototype or proof-of-concept potential solutions. + Follow and in some cases enhance change management procedures for BI solutions. + Be passionate about solving business problems with data-driven solutions

+ Quality Outcomes

+ Independently and consistently delivers projects on time and within budget, with proactive communication throughout

+ Application support

+ Low defect rates on implemented coding + Continued improvement in application support tickets + Outside vendors managed effectively (deadlines met, budget not exceeded, quality of delivered work high, etc.)


+ Bachelor's degree in Information technology or related field or equivalent work experience + 10 years of progressive roles within information solutions departments + 8 years of experience designing and developing DW/BI applications in Microsoft SQL Server + 3 years of experience designing and building reports using Power BI + 3 years of experience building reporting applications sourced from JD Edwards ERP + 3 years of experience of architecting solutions for business intelligence applications + 3 years of experience developing reports using SSRS + 3 years of experience using SSMS, Visual Studio, or comparable tool. + Data management and data governance experience + ETL & ELT tool exposure such as Informatica, SSIS, Azure Data Factory + Experience working on I series (AS/400) + Knowledge of Azure, AWS or other cloud data warehouse solutions and services + Understanding of ERP processes + Thorough knowledge of Software Lifecycle + Strong critical thinking, analytical, and problem-solving skills + Strong exposure to sales, logistics, and financial reporting + High level of maturity and confidence necessary to interact with internal and external clients + Strong leadership and customer service skills with the ability to ensure that a high level of service and quality is maintained + Product knowledge with clear technical understanding of services to be able to effectively communicate to customer + Excellent project management, organizational and planning skills with ability to prioritize multiple tasks, projects and meet deadlines + Outstanding attention to detail, flexibility and creativity + Persistence coupled with the ability to communicate effectively with individuals at all levels of the organization + Ability to exercise discretion and good judgment, work with minimal supervision and maintain confidentiality of shared information and/or assignments

**So, what are you waiting for? A new career awaits you with endless opportunities.**

Bunzl is a global leader in the Cleaning & Hygiene, Food Processing, Grocery, Health Care, Non-Food Retail, and Safety industries. We have grown both organically and through acquisitions to sales in excess of $10 billion. Bunzl North America is headquartered in St. Louis, Missouri. Bunzl North America owns and operates more than 100 warehouses and serves all 50 states, Puerto Rico, Canada and parts of the Caribbean and Mexico. With more than 5,000 employees and 400,000 plus supplies, Bunzl is regarded as a leading supplier in North America.

_Bunzl Distribution offers competitive salaries, a comfortable work environment, and a full range of benefits including a 401k with a company_ _match._

_Bunzl Distribution has a tradition of commitment to equal employment opportunity. It is the established policy to attract and retain the best qualified people without regard to race, color, religion, national origin, sex/gender (including pregnancy), sexual orientation, age, disability or veteran status as provided by law._

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)




Morton Grove, IL
60053 USA



View all jobs at BUNZLReport Job