Data Analyst

AI2IO helps organizations manage technology solutions, including IT services, software integration, automation, and AI implementations. The Data Analyst will translate business needs into validated requirements for the enterprise data warehouse and reporting environment, define and govern KPIs, research source data, validate platform designs, and manage BI delivery operations including Azure DevOps stories, UAT, and release documentation.

Responsibilities:

• Define Business Requirements: Work directly with business stakeholders to gather, clarify, and document reporting and analytics requirements
• Support KPI Certification: Research and document metric definitions, formulas, business owners, and source systems as part of the KPI Governance Council’s certification process
• Maintain the Business Glossary & KPI Dictionary: Keep shared definitions current and consistent as new metrics are certified or existing ones are revised
• Profile Source Data: Research and profile data across source systems (including Deltek Vantagepoint, SQL views, and Power BI semantic models) to understand how a reported number is actually calculated end-to-end
• Validate Platform Design: Test and validate that new data warehouse structures and reports match agreed-upon business definitions before release
• Flag Data Quality and Governance Issues: Identify inconsistencies, stale logic, or undocumented assumptions in existing reporting and raise them to the Director of Business Intelligence and the Governance Council
• Manage the Azure DevOps Backlog: Create and maintain well-defined user stories in Azure DevOps, supporting the BI team’s two-week sprint cadence and intake process
• Coordinate UAT: Plan and coordinate user acceptance testing with business stakeholders for new reports, KPIs, and platform changes
• Maintain Release Documentation: Author and maintain release notes and change management documentation so stakeholders always know what changed and why
• Completion of Assigned Tasks and Deliverables on Time and on Budget
• Performs Other Related Duties as Assigned

Requirements:

• Strong analytical skills with the ability to translate ambiguous business questions into clear, testable requirements
• Working knowledge of SQL sufficient to independently query and investigate source data across multiple systems
• Familiarity with Power BI reports and semantic models
• Excellent written and verbal communication skills, with the ability to work effectively with both business and technical stakeholders
• Strong attention to detail and comfort with detailed, sometimes repetitive validation work
• Ability to work independently with minimal supervision while managing multiple concurrent requests
• Demonstrated aptitude for learning new technology and adapting to evolving requirements
• Bachelor's degree in Business Analytics, Information Systems, Statistics, Finance, or related discipline
• 4+ years of experience in a data analyst, business analyst, or reporting analyst role
• experience reading or writing DAX is a plus
• Experience with Azure DevOps or a similar backlog/work-tracking tool
• Prior experience with Deltek Vantagepoint or similar professional services ERP systems is a plus
• Experience supporting an enterprise data warehouse, BI platform, or reporting modernization effort is strongly preferred