Business Intelligence Engineer

API Delevan, Inc.; Town of Grafton (WI); On-site; USD 97,000 - 132,000; Full time

Benefits offered by this job

Medical, Dental, Vision and Rx

HSA/FSA options

Paid Time Off

401k with match

Life and AD&D insurance

Tuition assistance

Job summary

Regal Rexnord in Wisconsin is seeking a Business Intelligence Engineer to design and develop BI dashboards and data models from the Enterprise Datawarehouse. You will work cross-functionally to capture analytics requirements and deliver reports that meet business needs.

Responsibilities include end-to-end analytics tool development, testing, training, and go-live coordination, with hybrid work on-site and some remote days. Expertise in Informatica, Snowflake, OBIEE, and Power BI is required.

Qualifications

• Master’s degree in CS or related field plus BI experience.
• Experience designing BI dashboards and visualizations from a Enterprise Datawarehouse.
• Experience with Informatica, Snowflake, OBIEE and Power BI.
• End-to-end development of analytics tools and end-user training/go-live.

Responsibilities

• Design and develop BI dashboards and visualizations using dimensional data from the Enterprise Datawarehouse.
• Work cross-functionally to understand analytics requirements and build dashboards and reports.
• Analyze requirements, design data models, and maintain OBIEE and Power BI assets.
• Perform testing, user training, and go-live coordination for BI tools.
• Run reports and manage user access; optimize slow-running dashboards.

Skills

BI dashboards

Data analysis

Cross-functional collaboration

Education

Master's degree in Computer Science or related field

Tools

Informatica

Snowflake

OBIEE

Power BI

Job description

Work Model

You’ll work in a hybrid model, onsite at your designated Regal Rexnord location at least 3 days per week (Monday–Thursday), with flexibility to work remotely up to 2 days, including Friday.

Job Location

1051 Cheyenne Ave, Grafton, WI 53024

Job Title

Business Intelligence Engineer

Duties

• Regal Rexnord Corporation seeks a Business Intelligence Engineer in Grafton, Wisconsin to conduct Business Intelligence (BI) analysis.
• Design and develop BI analytic dashboards and visualizations using dimensional data from the Enterprise Datawarehouse.
• Utilize Informatica and Snowflake.
• Work cross-functionally with businesses to understand analytics requirements and develop dashboards and reporting that meet the needs of the business.
• Analyze requirements, design, develop, and maintain Oracle Business Intelligence Enterprise Edition (OBIEE) and Power BI data models, dashboards, reports, and visualizations.
• Perform end-to-end development of business analytics tools, including testing after implementation, and coordination of end user training and go-live.
• Run reports and support user access of BI tools.
• Analyze and resolve issues with BI dashboard and reports.
• Optimize slow-running reports and data visualizations including query optimization, data defragmentation, and increasing memory.
• Integrate data from multiple ERPs.
• Build views on top of Oracle ERP tables and create reports on top of the views.
• Create and implement technical tests and cutover plans which outline all steps required to transition from the current enterprise system to a new one.

Salary

$96,970 - $131,600/year.

Minimum Requirements

• Requires a Master’s Degree in Computer Science or a related field plus one year of Business Intelligence (BI) experience.
• Must have at least one year of experience in each of the following: 1. Designing and developing BI analytic dashboards and visualizations using dimensional data from the Enterprise Datawarehouse;
• 2. Utilizing Informatica and Snowflake;
• 3. Analyzing requirements, designing, developing, and maintaining Oracle Business Intelligence Enterprise Edition (OBIEE) and Power BI data models, dashboards, reports, and visualizations;
• 4. Performing end-to-end development of business analytics tools, including testing after implementation, and coordination of end user training and go-live;
• 5. Building views on top of Oracle ERP tables and create reports on top of the views.

Benefits

• Medical, Dental, Vision and Prescription Drug Coverage
• Spending accounts (HSA, Health Care FSA and Dependent Care FSA)
• Paid Time Off and Holidays
• 401k Retirement Plan with Matching Employer Contributions
• Life and Accidental Death & Dismemberment (AD&D) Insurance
• Paid Leaves
• Tuition Assistance

About Regal Rexnord

Regal Rexnord is a publicly held global industrial manufacturer with 30,000 associates around the world who help create a better tomorrow by providing sustainable solutions that power, transmit and control motion. The Company’s electric motors and air moving subsystems provide the power to create motion. A portfolio of highly engineered power transmission components and subsystems efficiently transmits motion to power industrial applications. The Company’s automation offering, comprised of controls, actuators, drives, and precision motors, controls motion in applications ranging from factory automation to precision control in surgical tools. The Company’s end markets benefit from meaningful secular demand tailwinds, and include factory automation, food & beverage, aerospace, medical, data center, warehouse, alternative energy, residential and commercial buildings, general industrial, construction, metals and mining, and agriculture. Regal Rexnord is comprised of three operating segments: Industrial Powertrain Solutions, Power Efficiency Solutions, and Automation & Motion Control. Regal Rexnord has offices and manufacturing, sales and service facilities worldwide. For more information, including a copy of our Sustainability Report, visit RegalRexnord.com.

Equal Employment Opportunity Statement

Equal Employment Opportunity Statement Regal Rexnord is an Equal Opportunity and Aff… We are committed to building a team that represents diverse and inclusive backgrounds, perspectives, and skills. If you’d like to view a copy of the company’s affirmative action plan for protected veterans/individuals with disabilities or policy statement, please email [e-mail]. If you have a disability and you believe you need a reasonable accommodation in order to search for a job opening or to submit an online application, please e-mail [e-mail].

Values

• Integrity Responsibility Diversity, Engagement & Inclusion Customer Success Innovation with Purpose Continuous Improvement Performance Passion to Win ….with a Sense of Urgency