Power BI Procurement Analyst

ProcureAbility; Auburn (CA); On-site; USD 90,000 - 125,000; Full time

Job summary

ProcureAbility is seeking a Business Intelligence Analyst/Senior Analyst to drive data-driven insights and deliver advanced BI solutions for internal and client initiatives.

You'll design data flows, build dashboards with Power BI, Tableau, or Qlik, and collaborate with cross-functional teams to ensure data accuracy and impactful analytics. A STEM or analytics background is valued for this client-focused practice.

Qualifications

• Bachelor’s degree in supply chain, analytics, or STEM.
• 3+ years of data-driven decision making experience.
• 2+ years BI tool experience (Power BI, Tableau, Qlik).
• Strong MS Excel skills.
• Excellent communication and collaboration with cross-functional teams.
• Data cleansing and standardization across multiple data sources.
• Ability to work independently with client teams.
• Attention to detail in requirements gathering.

Responsibilities

• Understand objectives with clients and secure necessary data.
• Design and document data extraction, preparation, and ingestion.
• Develop and maintain dashboards and BI solutions.
• Identify and resolve data challenges with stakeholders.
• Conduct design reviews and QA for information delivery applications.
• Develop validation processes to ensure data accuracy.
• Identify automation, optimization, and growth opportunities.
• Support product roadmap activities as assigned.

Skills

Data-driven decision making

Analytical thinking

Communication skills

Problem solving

Independent worker

Education

Bachelor’s degree in supply chain, analytics, or STEM

Tools

Power BI

Tableau

Qlik

SQL

Azure

Job description

As a Business Intelligence Analyst/Business Intelligence Senior Analyst (level based upon experience) at ProcureAbility, you will be responsible for executing internal and client-facing initiatives through advanced data analytics, targeted spend analysis, and leveraging new and emerging technologies. You will be part of a small but mighty digital practice focused on building a technology platform that is being built from a practitioner’s point of view.

What can you expect to do?

• Work with business clients and ProcureAbility staff to understand the analytical objectives for each project and secure the data necessary to achieve those objectives.
• Design and document data extraction, preparation, and ingestion tasks and data flow.
• Develop and maintain advanced reporting, analytics, dashboards, and other BI solutions using tools such as Excel, Power Query, Power BI, and Alteryx.
• Identify and resolve data challenges with internal and external stakeholders.
• Conduct design reviews and participate in QA functions for our information delivery application(s).
• Develop validation processes to ensure data accuracy across various dashboards and reports.
• Identify and provide recommendations for areas of automation, optimization, and growth.
• Support specific product roadmap development activities as assigned.

What is the experience needed to be successful in this role?

• Bachelor’s degree in the supply chain, analytics, or any STEM field.
• 3+ years of experience leveraging data to support fact-based decision-making.
• 2 years of experience utilizing BI solutions (Power BI, Tableau, Qlik, etc.).
• Strong skillset in MS Excel (VLOOKUP, INDEX, MATCH, Data Simulations, etc.).
• Proficient in MS PowerPoint
• Ability to work independently with client teams to support deliverables.
• Attention to detail helps in driving specificity in requirements gathering and delivery.
• Ability to work effectively and collaboratively with cross-functional teams and stakeholders.
• Strong exposure to data cleansing and standardization from multiple data sources.
• Strong written and verbal communication skills with the ability to convey information at all levels of the organization.
• Strong organizational skills with the ability to manage multiple tasks simultaneously with clear priorities.

Beyond the Requirements Above, What Would Make Me a Standout Candidate?

• A solid understanding of supply chain and procurement business, specifically data and spend categorization, is highly desirable.
• Solid understanding of relational databases and analytical data modeling.
• Experience designing, developing, and testing BI solutions that may include relational databases, data warehouses, ETL, reports, and dashboards.
• Experience with any flavor of SQL, writing lookup queries, stored procedures, and creating database schemas.
• Experience in object-oriented programming languages (Python, Java, C#).
• Familiarity with Azure services, or applicable (AWS, GCP).