Business Intelligence Engineer

Regal Rexnord Corp; Town of Grafton (WI); Hybrid; USD 97,000 - 132,000; Full time

Benefits offered by this job

Medical, Dental, Vision

HSA & FSA

Paid Time Off

401k with matching

Life and AD&D

Tuition Assistance

Job summary

Regal Rexnord in Grafton, WI seeks a Business Intelligence Engineer to design and develop BI dashboards using data from the Enterprise Datawarehouse. You will use Informatica and Snowflake, and work with OBIEE and Power BI, translating analytics requirements into actionable insights.

End-to-end BI tool development, testing, user training and go-live support are included, with a hybrid work model and on-site requirements in Wisconsin. Salary range $96,970–$131,600/year.

Qualifications

• Master's Degree in Computer Science or related field plus one year BI experience.
• Experience designing and developing BI dashboards and visualizations using dimensional data from a data warehouse.
• Experience using Informatica and Snowflake; building OBIEE and Power BI data models, dashboards, and reports.
• End-to-end development of analytics tools, including testing and end-user training/go-live coordination.
• Experience building views on top of Oracle ERP tables and creating reports from those views.

Responsibilities

• Design and develop BI analytic dashboards and visualizations.
• Utilize Informatica and Snowflake for data integration and modeling.
• Develop OBIEE and Power BI data models, dashboards, reports, and visualizations.
• Perform end-to-end development of analytics tools, including testing and go-live coordination.
• Build views on Oracle ERP tables and create reports from the views.

Skills

BI analytics

Education

Master's Degree in Computer Science or related field

Tools

Informatica

Snowflake

OBIEE

Power BI

Oracle ERP

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 Title

Business Intelligence Engineer

Job Location

1051 Cheyenne Ave, Grafton, WI 53024

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. Local telecommuting permitted up to 2 days per week. 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; and 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

Regal Rexnord is an Equal Opportunity and Affluent Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex/gender, sexual orientation, gender identity, pregnancy, age, ancestry, national origin, genetic information, marital status, citizenship status (unless required by the applicable law or government contract), disability or protected veteran status or any other status or characteristic protected by law. Regal Rexnord is committed to a diverse and inclusive workforce. 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].