Hobart Service, an Illinois Tool Works Company, has been in business for over 120 years and is the trusted source for Commercial Food Equipment Service Solutions. We have over 1,700 associates nationwide who serve as valued partners to our customers. Our employees are dedicated to providing the best customer service, give back to the communities where they live and work, and demonstrate the ITW values of Integrity, Simplicity, Trust, Respect and Shared Risk.
The Business Intelligence Analyst will be responsible for delivering timely and high-quality data, accurate reports and analytics. Through collaboration with internal partners and senior management, the analyst will provide support in all phases of the reporting life cycle. The successful candidate will also assist in the development of advanced methods of predictive modeling that will assist with the reactive and proactive support of the business. The Analyst is expected to be highly motivated, detail oriented, analytical, and able to prioritize multiple deadlines. This position requires analytical and problem-solving aptitude along with a wide range of technical, design and multitasking skills.
ESSENTIAL DUTIES AND RESPONSIBILITIES
These are the most significant job duties performed. The size, scope and complexity of assigned duties and responsibilities are dependent on the level and experience of the incumbent. To perform this job successfully, an individual must be able to perform each assigned essential duty satisfactorily. Other responsibilities or special projects not specifically listed below may also be assigned.
Delivering timely and high-quality data, accurate reports and analytics to support decision making.
Training end-users on new reports and dashboards
Using TSQL & Data Cube to extract data and create reports as per the user's specifications.
Preparing reports, dashboards & KPI for the management stating trends, patterns, and predictions using relevant data
The candidate will also regularly interact with the users ranging from the end user to management team to understand, document and communicate their needs, perform requirements analysis, develop, and deliver Data Models, reports, and data visualization
The requirements listed below are representative of the knowledge, skill, and/or ability required to perform this job successfully. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Proficient in data analysis, with ability to write queries to retrieve and analyze data from relational data sources.
Proficient with Microsoft Office Products to include Outlook, Word, Excel, Power Pivot, MSQuery and PowerPoint.
TSQL knowledge.
Inquisitive, detail disposition with strong quantitative analytical skills.
This position requires analytical and problem-solving aptitude along with a wide range of technical development, design, and multitasking skills.
Excellent communication and interpersonal skills.
Exceptional organizational skills to prioritize work and ability to balance maintenance and project work.
Ability to work independently or as a team member.
Green Card or US citizenship.
Education and Work Experience
Bachelor's Degree in MIS, Computer Science, or related field.
2+ Yrs. of recent experience in Data Analyst role
Desired Education/Experience
Experience in Microsoft SQL Server BI Suite including Data Cube/Mart, PowerBI, relational data modeling.
Understanding of key business metrics, such as, Net Sales, Gross Margin, Profit Margin, Variable Margin, Operating Profit, etc.
Ability to understand and foresee implications of new information for current and future problem solving.
Ability to learn quickly and adapt to new technologies, tools, and techniques.
Job -Specific Knowledge
To perform this job successfully, the individual needs to demonstrate knowledge of these areas as they relate to the primary functions of the job.
Microsoft Office Products to include Outlook, Word, Excel, Power Pivot, MSQuery and PowerPoint.
TSQL
Ability to analyze large datasets.
Ability to write comprehensive reports.
COMPETENCIES
To perform the job successfully, an individual should demonstrate the following competencies.
Ability to work independently or as a team member.
Establishes and maintains effective, collaborative work relationships both internally and externally.
Must be dependable, have good attendance, be punctual, and have a positive attitude.
Prioritizes regular workload, special tasks and concurrent projects, allocating time and resources to ensure that work is completed accurately and efficiently within established time frame.
Ability to switch gears quickly without sacrificing quality in a high volume, task-oriented environment
Demonstrated ability to communicate orally with individuals from within and outside of the organization.
An analytical mind and inclination for problem-solving.
Attention to detail.
Physical Demands:
While performing the duties of this Job, the employee is:
Lifting 75 lbs. with or without assistance
Climbing up to 10 ft with ladder
Occasional roof access may be necessary
Extensive walking 3-5 miles / day
Extensive driving 5-6 hours/day
Kneeling, squatting, bending, pushing/pulling
Moving in different positions to accomplish tasks in various environments including tight and confined spaces
Operating motor vehicles or heavy equipment
Operating machinery and/or power tools
Why work for us?
Competitive pay
Great insurance options with low premiums
Paid vacation and holidays
401K with company match
Extensive on-the-job, online, and classroom training
Service vehicle, uniforms, and safety equipment provided
Safety-conscious work environment
Hobart Service is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.
ITW and Hobart Service are committed to providing a healthy and safe environment for all employees. To demonstrate this commitment, Hobart Service is tobacco-free (including e-cigarettes) on campuses and within company vehicles and maintains a drug-free workplace.
If you are a qualified individual with a disability and are unable or limited in your ability to use or access the online application system process due to your disability, please contact Human Resources at service.hr@hobartservice.com to request assistance. No other requests will be acknowledged.
ITW is an equal opportunity employer. We value our colleagues' unique perspectives, experiences and ideas and create workplaces where everyone can develop their careers and perform to their full potential.
As an equal employment opportunity employer, ITW is committed to equal employment opportunity and fair treatment for employees, beginning with the hiring process and continuing through all aspects of the employment relationship.
All qualified applicants will receive consideration for employment without regard to race, color, sex, gender identity, sexual orientation, religion, national origin, age, disability, protected Veteran status or any other characteristic protected by applicable federal, state, or local laws.
ITW is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law.
