Regal Rexnord Corp
Business Intelligence Engineer Lead
Regal Rexnord Corp, Milwaukee, Wisconsin, United States, 53244
We are seeking an experienced and proactive Lead BI Engineer to join our dynamic team. As a Lead BI Engineer, you will be responsible for day-to-day tasks involving Extract, Transform, Load (ETL) processes, data integration, data modeling, and analytical skills, mentoring junior developers.Scope of Role:This person will help bring discipline in day-to-day operations & production support
Ability to work in a fast-paced, high-energy environment and bring sense of urgency & attention to details skills to the table
Coordinates closely with other BI team members to help ensure meaningful prioritization
Escalates potential issues in timely fashion and seeks paths for resolution
Excellent communication skills and ability to manage expectations
ResponsibilitiesETL Processes:
Design, develop, and maintain ETL processes using Informatica IICS (Integration Cloud Services) and IDMC (Intelligent Data Management Cloud)
Ensure efficient data extraction, transformation, and loading from various source systems
Data Modeling and Warehousing:
Work with modern data warehousing platforms, including Snowflake. Build schemas, SCDs, hierarchy flattening, profiling etc.
SQL Expertise:
Write complex SQL queries to extract, transform, and load data efficiently
Big Data Technologies:
Collaborate with data engineers and data scientists, leveraging platforms like Databricks for data exploration, transformation, and machine learning
Business Intelligence:
Create advanced Power BI dashboards and reports to visualize data insights
AI/ML Integration:
Explore opportunities to integrate AI/ML models into BI solutions for predictive analytics
Resource Management:
Lead and mentor ETL developers, ensuring efficient scheduling and load balancing
Coordinate with business stakeholders and cross-functional teams for design, testing, and validations
Required Skills and ExperiencesBachelor's degree in Computer Science, Engineering, Business or related fields, or equivalent years of experience
Minimum 7+ years of experience in BI development and data analytics
Proven track record of successful project delivery
Strong Experience with cloud-based data solutions
Proficiency in SQL and ETL processes
Proficiency in IICS/IDMC
Familiarity with Snowflake and/or Databricks, and Power BI
Understanding of AI/ML concepts
Strong customer facing, conflict resolution, and negotiation skills
Strong analytical stills
Preferred Skills:Familiarity with SAP, BW and/or Oracle ERP
Knowledge of SAP BODS, Alteryx ETL tools
Have worked in Manufacturing industry
Strong leadership skills.
Strong work ethic
Excellent communication, facilitation and presentation skills - both verbal and written
Excellent collaborator who can effectively function in a matrix and team environment
Strong developer of talent and culture
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 $6.5B 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 Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex/gender, sexual orientation, gender identity, age, ancestry, national origin, 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 or policy statement, please email Recruiting@RegalRexnord.com. 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 Recruiting@RegalRexnord.com.Equal Employment Opportunity PostersNotification to Agencies : Please note that Regal Rexnord Corporation and its affiliates and subsidiaries ("Regal Rexnord") do not accept unsolicited resumes or calls from third-party recruiters or employment agencies. In the absence of a signed Master Service Agreement or similar contract and approval from HR to submit resumes for a specific requisition, Regal Rexnord will not consider or approve payment to any third-parties for hires made.
Ability to work in a fast-paced, high-energy environment and bring sense of urgency & attention to details skills to the table
Coordinates closely with other BI team members to help ensure meaningful prioritization
Escalates potential issues in timely fashion and seeks paths for resolution
Excellent communication skills and ability to manage expectations
ResponsibilitiesETL Processes:
Design, develop, and maintain ETL processes using Informatica IICS (Integration Cloud Services) and IDMC (Intelligent Data Management Cloud)
Ensure efficient data extraction, transformation, and loading from various source systems
Data Modeling and Warehousing:
Work with modern data warehousing platforms, including Snowflake. Build schemas, SCDs, hierarchy flattening, profiling etc.
SQL Expertise:
Write complex SQL queries to extract, transform, and load data efficiently
Big Data Technologies:
Collaborate with data engineers and data scientists, leveraging platforms like Databricks for data exploration, transformation, and machine learning
Business Intelligence:
Create advanced Power BI dashboards and reports to visualize data insights
AI/ML Integration:
Explore opportunities to integrate AI/ML models into BI solutions for predictive analytics
Resource Management:
Lead and mentor ETL developers, ensuring efficient scheduling and load balancing
Coordinate with business stakeholders and cross-functional teams for design, testing, and validations
Required Skills and ExperiencesBachelor's degree in Computer Science, Engineering, Business or related fields, or equivalent years of experience
Minimum 7+ years of experience in BI development and data analytics
Proven track record of successful project delivery
Strong Experience with cloud-based data solutions
Proficiency in SQL and ETL processes
Proficiency in IICS/IDMC
Familiarity with Snowflake and/or Databricks, and Power BI
Understanding of AI/ML concepts
Strong customer facing, conflict resolution, and negotiation skills
Strong analytical stills
Preferred Skills:Familiarity with SAP, BW and/or Oracle ERP
Knowledge of SAP BODS, Alteryx ETL tools
Have worked in Manufacturing industry
Strong leadership skills.
Strong work ethic
Excellent communication, facilitation and presentation skills - both verbal and written
Excellent collaborator who can effectively function in a matrix and team environment
Strong developer of talent and culture
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 $6.5B 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 Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex/gender, sexual orientation, gender identity, age, ancestry, national origin, 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 or policy statement, please email Recruiting@RegalRexnord.com. 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 Recruiting@RegalRexnord.com.Equal Employment Opportunity PostersNotification to Agencies : Please note that Regal Rexnord Corporation and its affiliates and subsidiaries ("Regal Rexnord") do not accept unsolicited resumes or calls from third-party recruiters or employment agencies. In the absence of a signed Master Service Agreement or similar contract and approval from HR to submit resumes for a specific requisition, Regal Rexnord will not consider or approve payment to any third-parties for hires made.