Business Intelligence Developer at Crown Equipment · New Bremen

Job Posting External

Job Responsibilities:

The Senior PowerBI Developer is a critical role within InfoLink, Crown’s global fleet management software solution. 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 and is expected to perform as an expert in business intelligence (BI) reporting. May mentor other Business Intelligence Developer and/or Report Developers. Use tools, methodologies, and processes to transform and consolidate large amounts unformatted data into a visual format, in the form of dashboards, reports, etc.

• Data Model/ Extraction/ Integration - Build, enhance, and support data modeling and extraction of data elements using Python 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. May provide context analysis and suggestions based on items discovered during data review.
• Report Creation - Use complex logic to create, test, implement and maintain complicated 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 an expert 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 and 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.

Remote Work: Crown offers hybrid remote work for this position. A reasonable commute to the New Bremen, OH office is necessary since some onsite work is required.

Minimum Qualifications:

• Bachelor’s degree in Information Technology, Computer Science, MIS, or related field, with at least 5 or more years of related work experience (salary will be commensurate with experience)
• Expert level PowerBI experience
• Experience with Python and/or PowerShell scripting.
• Good written, verbal, analytical and interpersonal skills
• Ability to occasionally travel with overnight stays (0-5%)

Preferred Qualifications:

• PowerBI administration experience and comprehension of the capacity to embed reports within other applications.
• Experience developing custom and complex queries in SQL for reporting needs and familiarity with creating custom DAX expressions/functions.
• Understanding of ETL development with Microsoft SQL Server and SSIS.
• Knowledge of REST APIs and API-based integrations.
• Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI.