Business Intelligence Developer 1 – Supply Chain

Company Description:

Crown Equipment Corporation is a leading innovator in world-class forklift and material handling equipment and technology. As one of the world’s largest lift truck manufacturers, we are committed to providing the customer with the safest, most efficient and ergonomic lift truck possible to lower their total cost of ownership.

Job Purpose:

Support business operations or customers by transforming the company’s data into meaningful and useful information for business purposes.  Modify existing or create new reports and dashboards to assist in the planning and decision process. This position is a technical position.  Use tools, methodologies, and processes to transform and consolidate large amounts unformatted data into a visual format, in the form of dashboards, reports, etc.  This position reports to the Supply Chain Manager – Analytic Risk and sits in our Supply Chain group.

Job Responsibilities:

• Report Creation – Create, test, implement and maintain reports and ad-hoc queries providing actionable information necessary to support business or customer requirement.  Identify data needed to provide the desired output.  Design and develop analytic and reporting solutions appropriate for Business Intelligence platform.  Fine tune reports and dashboards for optimal performance.  Assist with issue resolution and end user support. Be efficient with BI reporting tools.  Use the latest techniques in the industry to make the reporting process efficient which includes but is not limited to automation, speed, aesthetic designs and reducing complexity.
• Business Analysis – Work with the business to analyze data and understand business and reporting needs.  Translate the requirement into technical specifications.  Communicate status reports/important findings to management and decision-makers.  Work to achieve standardized business reports and data across the organization or for customers.  Perform data analysis on analytical and reporting requirements and recommend solutions for development. 
• Data Model / Extraction / Integration – With guidance from BI Dev 2 and BI Dev 3, build, enhance, and support data modeling and extraction of data elements from multiple internal or external databases to meet business or customer reporting requirements.   Design and build data load process taking all dependencies into consideration.  Support data loading and extraction processes including ensuring optimal performance.  Recommend and develop new metrics that may benefit the company or customers.
• Research, Training, and Self-Study – Perform on going self-study of job-related issues.  Conduct and/or attend both formal and informal departmental and computer training.  Perform other duties as assigned.

Minimum Qualifications:

• Less than 2 years related experience
• Bachelor’s degree (Computer Science, MIS or related field)

                     Non-degree considered if 12+ years of related experience along with a high school diploma or GED

• This position is ONSITE, 5 days a week, in New Bremen, Ohio.

Preferred Qualifications:

Good written, verbal, analytical and interpersonal skills.  May expect experience with SAP system configuration and administration desired or with advanced visualization tools such as SSRS, Tableau or Power BI.  May develop custom and complex queries in SQL for reporting needs.   May need the understanding of Microsoft SQL Server and SSIS development.  Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.  May need good understanding of SQL familiarity with creating custom DAX expressions/functions.

Work Authorization:

Crown will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas or who need sponsorship for work authorization now or in the future, are not eligible for hire.

No agency calls please.

Compensation and Benefits:

Crown offers an excellent wage and benefits package for full-time employees including Health/Dental/Vision/Prescription Drug Plan, Flexible Benefits Plan, 401K Retirement Savings Plan, Life and Disability Benefits, Paid Holidays, Paid Vacation, Tuition Reimbursement, and much more.

EO/AA Employer Minorities/Females/Protected Veterans/Disabled