BI Analyst

Job Summary:
We are seeking a detail-oriented and analytical Business Intelligence (BI) Analyst to join our team. The BI Analyst will be responsible for transforming data into insights that drive business decisions. This role involves analyzing complex datasets, creating reports, developing dashboards, and supporting the quality audit process for Supply Chain and Product while working with a cross-functional team. The ideal candidate will have a strong understanding of data analysis, data visualization tools, AI and ML generative models, and the ability to translate business needs into technical requirements. Experience with integrating data from multiple sources via APIs, advanced reporting in Power BI, and working with Salesforce.com and AI/ML models is essential.

Key Responsibilities:

• Data Integration: Connect and integrate data from multiple sources, including APIs and Salesforce.com, into a centralized data model in Power BI.
• Data Analysis: Collect, analyze, and interpret large datasets to provide actionable insights and recommendations to stakeholders.
• AI & ML Integration: Leverage AI and ML generative models to enhance data analysis and build predictive analytics capabilities. Experience with prompting language and integrating these models into BI tools is required.
• Reporting: Develop and maintain comprehensive reports and dashboards using Power BI, ensuring they reflect accurate and up-to-date data from various sources.
• Data Visualization: Design and implement advanced data visualizations in Power BI that clearly communicate insights to business users.
• Quality Audits: Participate in the quality audit process for Supply Chain and Product, using data analysis to support audit findings and recommendations.
• BI Tool Development: Utilize experience with Cognos, QlikView, Looker, Salesforce.com, and other BI tools to develop, enhance, and support BI solutions across different platforms.
• Database Management: Leverage strong knowledge of SQL, relational databases, data warehousing, and data modeling to manage and analyze data effectively.
• Advanced Excel Skills: Utilize advanced Excel functions, data analysis tools, and automation techniques to support data-driven decision-making.
• Collaboration: Work closely with cross-functional teams, including finance, marketing, operations, IT, and quality audit teams, to understand business requirements and provide data-driven solutions.
• Data Integrity: Ensure the accuracy, quality, and integrity of data by conducting regular audits and troubleshooting discrepancies. Build effective processes to identify inaccuracies.
• Trend Analysis: Identify trends, patterns, and anomalies in data that can inform strategic decision-making.
• Process Improvement: Propose and implement improvements to existing BI processes, including data collection methods and analysis techniques.
• Documentation: Maintain clear and organized documentation of data models, methodologies, and processes.

Qualifications:

• Education: MBA a plus, with a focus on Data Science, Business Analytics, Information Systems, or a related field.
• Experience: 3+ years of experience in business intelligence, data analysis, or a similar role.
• Proficiency in BI tools (e.g., Power BI, Cognos, QlikView, Looker, Salesforce.com).
• Advanced experience in integrating data from multiple sources via APIs.
• Strong proficiency in SQL and relational database management.
• Experience with data warehousing platforms such as Snowflake, Amazon Redshift, Google BigQuery, or Microsoft Azure Synapse Analytics.
• Experience with AI and ML generative models, including prompt engineering and integrating these models with BI tools.
• Advanced Excel skills, including data analysis, Power Query, and automation techniques.
• Reporting Skills: Proven ability to generate advanced BI reports in Power BI, connecting and compiling data from various sources.
• Analytical Skills: Strong analytical and problem-solving abilities with a keen eye for detail.
• Communication Skills: Excellent verbal and written communication skills, with the ability to present complex data in a clear and concise manner.
• Time Management: Ability to manage multiple tasks and prioritize effectively in a fast-paced environment.
• Attention to Detail: High level of accuracy and attention to detail in work products.
• Business Acumen: Understanding of business processes and how data analysis can impact decision-making.