Business Intelligence Specialist

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. You will help bring rigor and discipline in day-to-day operations & production supports. It is essential to have the ability to work in a fast-paced, high-energy environment and bring a sense of urgency & attention to detail to the table. Coordinating closely with other BI team members to help ensure meaningful prioritization is a key aspect of this role. You will be expected to escalate potential issues in a timely fashion and seek paths for resolution. Excellent communication skills and the ability to manage expectations are crucial for success in this position. Responsibilities will include designing, developing, and maintaining ETL processes using Informatica IICS (Integration Cloud Services) and IDMC (Intelligent Data Management Cloud). Ensuring efficient data extraction, transformation, and loading from various source systems is a primary task. Working with modern data warehousing platforms, including Snowflake, to build schemas, SCDs, hierarchy flattening, and profiling will be part of your role. Writing complex SQL queries to extract, transform, and load data efficiently is a core requirement. Collaboration with data engineers and data scientists, leveraging platforms like Databricks for data exploration, transformation, and machine learning is essential. Creating advanced Power BI dashboards and reports to visualize data insights and exploring opportunities to integrate AI/ML models into BI solutions for predictive analytics are also part of the responsibilities. Leading and mentoring ETL developers, ensuring efficient scheduling, and load balancing will be a key aspect of resource management. Coordinating with business stakeholders and cross-functional teams for design, testing, and validations will also be a part of the role. 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 skills. Preferred Skills: - Masters degree in Computer Science, Engineering, Business, or related fields.,