Job DescriptionThe RoleNVA is seeking a Principal Data Analyst to support the Procurement Department's analytics and reporting initiatives. This role is responsible for developing, maintaining, and enhancing reporting solutions, data assets, and business intelligence tools that provide actionable insights to Procurement and cross-functional stakeholders.
The ideal candidate has 4-7 years of experience transforming complex data into meaningful reporting and analytics solutions within large organizations. This individual combines strong analytical and technical capabilities with the ability to independently engage business stakeholders, gather requirements, and deliver self-service reporting solutions that drive informed decision-making.
The Principal Data Analyst will work extensively in Microsoft Fabric, Azure, Oracle Fusion Data Intelligence (FDI), Oracle Analytics, Power BI, SQL, and enterprise procurement systems to develop scalable datasets, dashboards, and self-service reporting tools. This role offers the opportunity to help shape Procurement's analytics strategy within a rapidly growing organization at the forefront of veterinary care.
Key Responsibilities- Data Management & Engineering
- Design and improve automated data preparation and transformation processes using Oracle Fusion, Microsoft Fabric, Azure, Python, Power Query, SQL, and related technologies.
- Develop, monitor, and maintain API-based data integrations between internal and external systems to support centralized reporting and analytics.
- Ensure the accuracy, consistency, and integrity of data across multiple sources.
- Manage and maintain data assets to support enterprise reporting and analytics.
- Develop and follow data management standards, processes, and documentation.
- Maintain version control and establish data lineage policies to augment governance of critical datasets.
- Partner with business and technical teams to onboard new data sources and ensure reliable data ingestion processes.
- Support the development of scalable data models, pipelines, and reporting datasets that enable self-service analytics.
- Reporting & Business Intelligence
- Design, develop, and maintain dashboards, reports, and analytics solutions using Power BI, Microsoft Fabric, Oracle Fusion Data Intelligence (FDI), and Oracle Analytics.
- Create and optimize reporting datasets, semantic models, measures, and KPIs.
- Analyze procurement, supplier, and spend data to identify trends, opportunities, and business insights.
- Integrate data from APIs, enterprise applications, and third-party platforms into reporting solutions and data models.
- Develop and maintain documentation, business logic, and data definitions to ensure consistent reporting.
- Recommend enhancements to reporting architecture, visualization standards, and analytical processes.
- Serve as a representative of Procurement interests and data needs in partnership with the Business Intelligence team.
Skills and Specifications- Demonstrated ability to independently lead stakeholder discussions, gather requirements, and manage reporting projects.
- Advanced proficiency in Oracle FDI/OTBI, Power BI, SQL, Excel, and enterprise reporting platforms.
- Professional-level skills with DAX, Power Query, and SQL development.
- Experience designing scalable datasets, semantic models, dashboards, and self-service reporting solutions.
- Expertise developing analytics and reporting solutions within Microsoft Fabric, Azure, and Oracle Fusion Data Intelligence (FDI).
- Strong understanding of data engineering and business intelligence concepts, including ETL/ELT processes, data modeling, data transformation, data governance, and API-based data integration.
- Experience developing, supporting, and troubleshooting API integrations and automated data ingestion processes from enterprise and third-party applications.
- Experience working with large, complex datasets and multiple enterprise data sources.
- Proficiency in Python, R, VBA, or other reporting automation tools is preferred.
- Strong analytical skills with the ability to identify trends, patterns, and opportunities within large datasets.
- Working knowledge of financial concepts, including GL coding, fiscal reporting, spend analysis, and year-over-year comparisons.
- Excellent organizational, problem-solving, and time-management skills.
- Strong written and verbal communication skills with the ability to work effectively with business leaders and operational teams.
- Advanced proficiency in Microsoft Office applications, including Excel, PowerPoint, Outlook, Word, and Teams.
Qualifications- Master's degree in data Analytics, Data Engineering, Finance, Statistics, Computer Science, Business Analytics, Marketing, Mathematics, Healthcare Administration, or equivalent work experience
- Minimum of 4-7 years of experience in an analyst role or related responsibilities
- Excellent communication skills and collaborative attitude
Animal Health Experience is a plus!
Compensation: $90,000 - $100,000
FSLA Status: Exempt
NVA offers a comprehensive benefits program including medical, dental, vision, a 401k with employer match, and paid time off (including sick time) for all eligible employees. The team can provide more information about compensation and benefits for your specific location during the process. For positions based in Colorado, NVA provides eligible employees with paid sick and safe leave and public health emergency leave in accordance with the requirements of Colorado's Healthy Families and Workplaces Act.