Business Intelligence & Data Analytics Specialist

AllSTEM Connections is actively recruiting on behalf of one of our valued clients—a leading organization known for innovation and excellence in the digital product space. We are excited to share this opportunity with professionals who are passionate about design systems, user experience, and collaborative product development. If the role aligns with your background and career goals, we encourage you to apply and take the next step toward joining a dynamic and forward-thinking team. Role: Business Intelligence & Data Analytics Specialist Contract End Date: 03/31/2028 Location: Upper Gwynedd, PA (Preferred) or Rahway, NJ Work Arrangement: Onsite or Hybrid (3 days onsite, Tuesday through Thursday) Hourly Pay Rate W2 : $52 Business Intelligence & Data Analytics Specialist Location Preferred: Upper Gwynedd, PA (UG, PA) Alternate: Rahway, NJ Work Model: Onsite or Hybrid (3 days onsite, Tuesday-Thursday) Position Overview We are seeking a highly analytical and detail-oriented Business Intelligence & Data Analytics Specialist to support the Animal Health Global Supplier Management (AH-GSM) organization. This role will drive procurement analytics, supplier data management, reporting, and data governance initiatives while supporting the ongoing evolution of the organization's data infrastructure. The ideal candidate will possess strong expertise in Power BI, Databricks, SQL, Excel, and data governance practices, along with a solid understanding of procurement operations and supplier management processes. This individual will partner with category leaders and business stakeholders to deliver actionable insights, improve data quality, and establish a reliable source of truth across procurement data assets. Key Responsibilities Procurement Analytics & Business Intelligence • Conduct spend analysis, price analysis, volume-versus-price assessments, and other procurement-focused analytical projects. • Support category management teams through detailed data investigations and actionable business insights. • Develop, maintain, test, and enhance Power BI dashboards and reporting solutions. • Deliver high-impact analytical "quick wins" that support strategic procurement decisions. Data Governance & Documentation • Build and maintain comprehensive data dictionaries and metadata documentation. • Establish and support a centralized, trusted source of truth for procurement and supplier data. • Document data structures, business definitions, and reporting logic for business stakeholders. Databricks & Data Management • Manage Databricks schemas, tables, and data models to support evolving business requirements. • Perform schema updates, column alignment, renaming activities, and data audits. • Write and execute basic SQL queries to validate, analyze, and maintain data integrity. • Support migration and transformation efforts related to data infrastructure modernization. Data Quality & Standardization • Cleanse and standardize supplier, spend, and procurement datasets. • Maintain consistent taxonomies, categories, and classification structures across data assets. • Identify and resolve data quality issues to improve reporting accuracy and usability. Process Improvement & Automation • Leverage AI-powered productivity tools such as Microsoft Copilot, Gemini, and prompt engineering techniques to streamline workflows and automate routine documentation tasks. • Recommend improvements to reporting, analytics processes, and data management practices. Required Qualifications • Bachelor's degree in Business, Information Systems, Data Analytics, Engineering, or a related field. • Minimum of 3 years of experience in business analysis, data analytics, project management, systems implementation, or a related discipline. • Strong experience with Power BI, including dashboard development, testing, enhancement, and reporting. • Working knowledge of Databricks, data models, schema management, and table maintenance. • Proficiency in SQL, including writing basic queries and supporting data validation activities. • Advanced Microsoft Excel skills, including: • Pivot Tables • VLOOKUP/XLOOKUP • Power Query • Large dataset analysis and manipulation • Experience performing procurement analytics, including spend and price analysis. • Strong understanding of data governance, data documentation, and master data management concepts. • Excellent communication, presentation, and technical documentation skills. • Ability to translate complex data structures and analytical findings into clear business insights. • Familiarity with AI-driven productivity tools and prompt engineering methodologies. Preferred Qualifications • Experience supporting procurement, sourcing, supplier management, or category management functions. • Knowledge of supplier master data and spend taxonomy management. • Experience developing data standards and governance frameworks. • Exposure to enterprise-scale data migration or transformation initiatives. Key Skills • Power BI Reporting & Dashboard Development • Procurement Analytics • Spend & Price Analysis • Databricks & SQL • Data Governance & Data Dictionaries • Data Cleansing & Standardization • Advanced Excel & Power Query • Business Analysis • Technical Documentation • AI Productivity Tools (Microsoft Copilot, Gemini) • Stakeholder Communication & Collaboration