BI Role for Global Sourcing

About the role

The Business Intelligence Advisor will utilize analytical, statistical, and programming skills to collect, analyze, and interpret large volume data sets and use this information to develop data-driven solutions for addressing difficult business challenges. Monitor, analyze and report business performance, financial results and other KPIs defined by business.

Responsibilities

• Analyze spending patterns, identify cost-savings opportunities, and provide actionable insights to improve decision making.
• Collaborate with cross-functional teams, interpret data trends, and develop dashboards or reports to communicate findings.
• Understand user requirements, translate complex data into user-friendly reports ensuring data accuracy.
• Create visually compelling and insightful reports, interactive dashboards connecting Tableau or Power BI to SQL and Snowflake.
• Lead or participate in multiple analytical projects or ad-hoc analysis by completing and updating project documentation, managing project scope, adjusting schedules when necessary, determining daily priorities, ensuring efficient and on-time delivery of project tasks and milestones.
• Perform exploratory data analysis (EDA) to uncover trends, patterns, and insights.
• Apply statistical techniques and advanced analytical methods to solve business problems.
• Utilize Python libraries such as Pandas, NumPy, Matplotlib for data analysis, visualization, and modeling.
• Automate data processing and analysis workflows using Python.
• Perform Spend analysis by gathering, cleansing, classifying, transforming procurement spend data, providing spend visibility, to facilitate category and spend management.
• Data enrichment/gap fill, standardization, normalization, and categorization of Spend data via research through different sources like internet, specific websites, database etc.
• Data quality check and correction, process, clean, and verify the integrity of data used for analysis.
• Stay updated on industry trends and optimize BI tools for efficient performance.
• Write optimized SQL & Snowflake queries for data extraction as well as integration with other applications.
• Design workflows in Alteryx Designer to develop models using data modeling techniques as per requirements.
• Create automated anomaly detection systems and constant tracking of its performance.
• Create and maintain the documentation of the architecture, data models and maintenance activities.
• Continuous process improvement and efficiency gain using automation or any other process standardization techniques.

Technical Skills & Competencies

• Must have experience working on business analytics or spend analytics projects as well as handling day-to-day operational requests from the business.
• Ability to successfully manage multiple tasks at any given point, strong relationship building skills & communication skills.
• High proficiency with Microsoft Excel.
• Visualization capabilities Power BI / Tableau.
• Knowledge about Alteryx Designer tool and Snowflake is preferred.
• Experience in requirements gathering and analysis and defining the implementation roadmap.
• Ability to work remotely with key stakeholders and business partners.
• Preferred to have skills of Project coordination & management.
• Self-motivated with a high degree of learning agility and a team player.

Experience & Education

• Bachelor’s degree in information science, Computer Science, Mathematics, Statistics, or a quantitative discipline in science. Advanced degree preferred.
• Minimum 10-15 years of work experience in the fields of data management and analysis.
• At least 5 years of work experience in procurement data management, spend analysis, RFP/RPQ/quote analysis.
• Demonstrated experience with data architecture, data integration/ETL, data warehousing, and/or business intelligence deployed in a complex environment.
• Demonstrated experience in Python programming for data manipulation, analysis, and visualization.
• Prior experience working on Reporting/Visualization Tools such as Power BI, Tableau.
• Must have excellent presentation & communication (written and verbal) skills.
• Good research and logical skills. Strong data collection, consolidation, and cleansing skills.
• Ability to scope, plan and execute assigned projects in a fast-paced environment.