Business Intelligence Analyst

Merck & Co.; Schaumburg (IL); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, Dental, Vision

Life Insurance

401k

Paid Time Off

Job summary

FUJIFILM North America Corporation is seeking a Business Intelligence Analyst to manage BI reporting across Sales, Purchasing and Inventory. You will merge data sources, analyze trends, create dashboards, and support data-driven decisions for various regions including U.S., Canada, and Latin/South America.

The role involves collaborating with multiple departments, building insights, and providing G2-level analytics to improve performance and reduce costs.

Qualifications

• Bachelor's degree in data-related field or equivalent
• 5+ years in data analysis, reporting, and DB management
• Strong SQL and data visualization experience
• Advanced SAP BI/R3 proficiency
• Excellent written and verbal communication skills
• Ability to translate data into actionable business insights
• Experience presenting to mixed technical/business audiences
• Ability to work independently and in cross-functional teams
• Proficiency in Excel (macros, VLOOKUPs, data imports)
• Awareness of budgeting, resource planning, and KPI management

Responsibilities

• Compile monthly/quarterly/annual BID management reports across Sales, Purchasing and Inventory
• Gather, analyze, and visualize data to identify trends and KPIs using SQL, Tableau or Power BI
• Collaborate with stakeholders to define reporting requirements and dashboard specs
• Provide ad hoc management reporting and actionable recommendations
• Deliver master data files to IT for BID applications and processes
• Document file systems and reporting procedures as needed
• Train users on report production, refresh and usage
• Interface with IT to implement new reports and enhancements
• Address report automation to improve timing and reduce manual effort
• Support cross-functional teams with data analytics and insights
• Perform QA and user acceptance testing for upgrades
• Related duties as assigned by manager

Skills

SQL data analysis

Tableau

Power BI

Excel advanced

Data storytelling

Communication

Problem solving

Education

Bachelor's degree in Data Science/Computer Science

Tools

SQL 2017+

SAP BI/R3

Power BI

Job description

Position Overview

The Business Intelligence Analyst is responsible for Sales/Purchasing/Inventory management reporting on all Business Innovation Division businesses (U.S., Canada, Mexico, Latin and South America) with ability to merge multiple data resources to produce accurate results. This position also has ability to analyze the resulting data and determine where the company can improve and reduce costs. This role will analyze data trends, create reports, and develop dashboards to help stakeholders understand performance metrics and identify opportunities for growth. Collaborate with various departments to support data analysis and reporting initiatives.

Our current office is located in Hanover Park; we will be moving to Schaumburg in October. This position will sit in Hanover Park until the move is complete.

Company Overview

At FUJIFILM North America Corporation, we are many things to both consumers and business customers. We're looking for passionate, mission-driven people to help us continue to innovate.

With five operating divisions, there's a lot of opportunity to find your niche and make an impact. Perhaps you'll click with our Imaging Division that provides one-time-use cameras, digital printing equipment, and instax™. Maybe you'll get charged up about our Electronic Imaging Division that markets digital cameras, lenses, and accessories for content creators. Or, you might have your eye on our Optical Devices Division, which provides optical lenses for the broadcast, cinematography, videography, and industrial markets. You could be drawn to our Business Innovation Division-they develop office and commercial print solutions and enable digital transformation. And if you're interested in tape, check out our Industrial Products Division-they develop data storage solutions.

The Business Innovation Division of FUJIFILM North America Corporation is the largest graphic distributor in the US. We deliver world-class state-of-the-art solutions for Digital Printing, Production Toner Solutions, Office A3/A4 MFP Products, Packaging, and a full range of traditional Offset printing products. In addition, we are the industry leader in Color Standardization and G7 implementation.

We offer a collegial culture and a flexible work environment. Our headquarters is in Valhalla, New York, a quaint town just one hour north of New York City.

Fujifilm is globally headquartered in Tokyo with over 70,000 employees across four key business segments of healthcare, electronics, business innovation, and imaging. We are guided and united by our Group Purpose of "giving our world more smiles." Visit: https://www.fujifilm.com/us/en/about/region/careers

Job Description

Responsibilities

• Compile monthly/quarterly/annual BID management/user reports involving Sales, Purchasing and Inventory
• Gather, analyze, and visualize data to identify trends and monitor key performance indicators (KPIs) using tools like SQL, Tableau, or Power BI
• Communicate with Management for requirements gathering and analyze for solution proposals
• Partner with business stakeholders to understand reporting requirements and translate them into dashboard specifications
• Perform complex data analysis, on time, to deliver analytics that will help better business decisions and monitor and improve KPIs
• Provide Ad Hoc management reporting (frequent) and analyze results with recommendations for improvement
• Provide master data files to IT for use in extended BID applications and Web form processes (daily, weekly, monthly)
• Document file system and reporting procedures (as needed)
• Instruct/Train key users on report production, refresh and use.
• Manage File structures and application upgrades as well as Backup/Recovery provisions (as needed)
• Work with cross-functional teams to understand their data needs and provide relevant analytical support
• Implement data and file changes based on Business initiatives
• Interface with IT group to implement new reports/processes as well as changes and enhancements
• Address report automation needs to improve timing and reduce manual efforts
• Provide user acceptance testing for upgrades to current business systems
• Related duties as assigned by manager

Required Skills/Education

• Bachelor's degree in related fields such as Data Science or Computer Science, or work equivalent
• Five or more years of experience in a related area e.g. data analysis, reporting, and database management
• Extensive knowledge of databases and reporting tools, in particular SQL 2017 or above
• Advanced Proficiency with SAP BI/R3
• Ability to analyze complex data sets and translate findings into actionable business strategies
• Excellent verbal and written communication skills to present data insights to non-technical stakeholders
• Excellent problem-solving skills
• Ability to write clear data documentation and metric definitions
• Comfortable presenting findings to mixed audiences of technical and business stakeholders
• Skilled at identifying when stakeholders are asking the wrong question and redirecting constructively
• Ability to work independently and collaborate with team members
• Excellent interpersonal, communication, listening, and presentation skills
• Good time management skills and multi-tasking abilities
• Advanced proficiency in Microsoft Excel (Macro Building, Vlookups, Data Imports)
• An understanding of budgeting procedures, methods, evaluation criteria, and resource planning
• Ability to work outside of normally scheduled hours including Weekends or Holidays approximately 10% of the time

Desired Skills

• Microsoft SQL certification
• Microsoft Access knowledge
• Data Visualization Platforms (Power BI)
• Experience in Sales company environment

Benefits:

• Medical, Dental, Vision
• Life Insurance
• 401k
• Paid Time Off

#LI- Hybrid

EEO Information

Fujifilm is committed to providing equal opportunities in hiring, promotion and advancement, compensation, benefits, and training regardless of nationality, age, gender, sexual orientation or gender identity, race, ethnicity, religion, political creed, ideology, national, or social origin, disability, veteran status, etc.

ADA Information

If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to our HR Department ([e-mail]).