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