Business Intelligence Engineer Lead

Regal Rexnord Corp
paid time off, tuition assistance, 401(k), retirement plan
United States, Wisconsin, Milwaukee
Oct 23, 2024
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 Responsibilities ETL 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 Experiences Bachelor'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 Posters Notification 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.