Data Analyst 2 (2-4 years)

We are looking for a commercially minded Data Analyst to support procurement decision-making within a major real estate environment in Chicago, Illinois. This Long-term Contract position focuses on turning complex procurement and supplier data into practical insights that improve sourcing strategy, performance visibility, and cost control. The role works standard Eastern Hours and partners closely with procurement, finance, and business stakeholders to strengthen reporting, automation, and data quality across the function.

Responsibilities:

• Create and refine Power BI dashboards that provide clear visibility into spend patterns, supplier results, contract activity, and key procurement measures.
• Examine procurement data across areas such as property services, facilities, construction, fit-out, and specialized services to uncover trends and improvement opportunities.
• Perform detailed spend and benchmarking analysis to highlight savings potential, strengthen category strategies, and support more informed purchasing decisions.
• Track compliance-related metrics, identify off-contract purchasing behavior, and prepare reporting that supports governance across procurement activities.
• Build and maintain scalable data workflows using Microsoft technologies, including Fabric, Data Factory, Dataflows Gen2, Databricks, and related cloud-based tools.
• Develop unified procurement datasets by combining information from enterprise platforms, contract systems, and supplier sources into reliable analytical models.
• Use SQL, Python, and PySpark to clean, structure, and transform large volumes of data for reporting and advanced analysis.
• Design automation solutions with Power Automate to reduce manual effort, improve accuracy, and increase team productivity.
• Work with procurement leaders, finance partners, and other stakeholders to translate business questions into meaningful analysis and present findings in a clear, business-focused way.
• Maintain documentation for data definitions, reporting logic, and governance standards while promoting data quality and self-service reporting adoption within the team.