Business Data Analyst

Job Summary:

The Business Data Analyst role will function as the expert reporting and analytical specialist for Empire’s Product Support organization.  The position will report directly to the Business Insights Manager in the Product Support Business Transformation team with direct responsibility for providing advanced skills in data extraction, data visualization, business intelligence programs, presentations, statistical analysis, toolset development, and project management to support business decisions.  Areas of focus include data relating to parts, service, and sales business utilizing predictive and prescriptive analytics to determine process and profitability improvement opportunities.

Essential Functions:

1. Research, extract, verify, analyze, and produce complex data relating to Empire’s assigned operational team and external clients. 
2. Develop and maintain operations databases, dashboard, reports, and metrics which can include validating data accuracy and integrity, identifying, and researching problematic areas and advising department leaders on necessary process improvements and updates.
3. Develop and maintain analysis tools and dashboards for use by the operational team that combines the use of data and statistical analysis with advanced modeling and visualization.
4. Develop and maintain complex models for predictive analysis of business needs using various databases and sources.
5. Develop intricate metrics to measure effectiveness and efficiency of business decisions to ensure expected results are achieved.
6. Work with all levels of leadership in assigned organization to identify and specify complex business requirements and processes.
7. Provide support in development of other analysis as directed by the leadership.
8. Act as a liaison between the assigned operational team and Information Systems.
9. Understanding of multiple areas of the business and partnering with solutions.
10. Cooperate with personnel in other work centers to build high levels of cross-departmental teamwork and support.
11. Comply with all company policies, procedures, and standards. Work safely at all times and adhere to all applicable safety policies. 

Additional Responsibilities:

1. Achieve a high level of client satisfaction.
2. Provide high level technical support as needed to assigned personnel and support resources.
3. Provide current and future process maps for all areas of responsibility.
4. Train users and ensure data entry and processes are operationally consistent for reliable data retrieval.
5. Document and communicate issues that may impact client satisfaction and raise awareness of market conditions.
6. Perform other related duties as may be required.
7. Work within and promote corporate values.

Additional Level Requirements

Knowledge Skills and Abilities:

1. Expert in SQL, Excel, Dax, Data Visualization (Power BI, Tableau, etc.), statistical analysis and other internal systems. Proficiency in process, algorithms, or other tools preferred.
2. Ability to create and manage relationships between datasets, as an example master tables in Power BI.
3. Skilled in transformations and creating large relational datasets across multiple applications and sources.
4. Must be detail oriented and highly skilled in constructing and analyzing complex data, models and forecasting from multiple data sources.
5. Must be able to document the process and procedures on the analysis and tools used for other owners and users.
6. Must have general business acumen that provides the ability to analyze and solve complex business issues.
7. Must have or be able to gain an understanding of Empire’s various business systems and how to extract data and information.
8. Must have excellent verbal and written communication skills and the ability to multi-task effectively with minimal supervision.
9. Must be a self-motivated, self-starter, work well in groups and demonstrate excellent client service.
10. Must have advanced knowledge and experience in process improvement methodologies and/or project management.
11. Must have acceptable attendance to meet all company standards and requirements.

Education and Experience:

1. Required Bachelor’s degree, preferred emphasis in Business Analytics and Communication, Business Data Analytics, Engineering, Mathematics, or equivalent related experience.
2. Minimum of five years’ experience in data analysis, data mining and model building or advanced education.
3. Expert user of MS Office Suite.
4. Caterpillar and/or Dealer experience is a plus.
5. Must be able to communicate (speak, read, comprehend, write) in English.

Physical Demands:

The Physical Demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

1. While performing the duties of this job, the employee is regularly required to sit and use hands.
2. The employee frequently is required to talk and hear.
3. The employee is occasionally required to stand, walk, reach, and bend.
4. The employee must occasionally lift and/or move up to 10 lbs.
5. The vision requirements of this position are ability to adjust focus and close vision.

Work Environment:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

1. While performing the duties of this job, the employee is regularly exposed to indoor conditions.
2. The employee is occasionally exposed to wet, heat, cold and outdoor conditions.
3. The noise level in the work environment is quiet.

Disclaimer:

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification.  They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.  The roles and objectives of this job do not include setting corporate policy and does not constitute a managing agent of the company.