BI Analyst
Job Summary:
Key Responsibilities:
- 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.
- 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.
- 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.