Business Intelligence Specialist

JOB DESCRIPTION Position Summary 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 rigor and discipline in day-to-day operations & production supports 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. Qualifications Required Skills and Experiences Bachelor's degree in computer science, Engineering, Business, or related fields. Minimum 10+ 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: Master's degree in Computer Science, Engineering, Business, or related fields.