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.