Data Analyst

ai2io; United States; Remote; USD 70,000 - 100,000; Full time

Benefits offered by this job

Medical plans

Dental and vision

401k with match

Paid time off

Parental leave

Professional development

Job summary

AI2IO is seeking a Data Analyst to join its new BI function. You will translate business needs into validated data requirements for the enterprise data warehouse and reporting environment, working with stakeholders from finance, operations, and delivery to define KPIs and data definitions.

You will own BI delivery mechanics, manage Azure DevOps stories, coordinate UAT, and maintain release documentation, ensuring a well-governed cadence for BI initiatives.

Qualifications

• Bachelor’s degree in Business Analytics, Information Systems, Statistics, Finance, or related discipline.

Responsibilities

• Define and document reporting requirements with business stakeholders.
• Profile data across source systems to understand end-to-end calculations.
• Validate data warehouse designs against business definitions.
• Create and maintain Azure DevOps backlog and release notes.
• Coordinate UAT with stakeholders for new reports and KPIs.

Skills

Analytical thinking

SQL querying

Power BI

DAX knowledge

Communication skills

Attention to detail

Independent work

Deltek Vantagepoint

Learning new tech

Education

Bachelor’s degree in Business Analytics, Information Systems, Statistics, Finance, or related discipline

Tools

Azure DevOps

Deltek Vantagepoint

Job description

AI2IO helps organizations navigate the complex landscape of technology solutions, from foundational IT services and system support to advanced software integration, automation, and cutting-edge AI implementations. Our expertise spans IT infrastructure management, custom software development, seamless system integrations, and optimization of low-code business automation, empowering clients to maximize their existing technology investments.

Join us and be part of a team where your voice matters, your work makes an impact, and your growth is a shared priority.

Position Title

Data Analyst

Position Location

Remote – work virtually from anywhere in the United States

Salary

AI2IO recognizes salary ranges from job boards do not necessarily reflect our pay ranges. In many instances we out-compete those ranges for well-qualified candidates.

Job Summary

The Data Analyst is a foundational member of AI2IO’s new Business Intelligence function, responsible for translating business needs into clear, validated requirements that shape the Company’s enterprise data warehouse and reporting environment. This role works directly with business stakeholders across finance, operations, and delivery to define KPIs, research and profile underlying source data, and ensure that what gets built actually reflects how the business works.

This role sits at the intersection of the business and the technical platform: the Data Analyst partners closely with the Director of Business Intelligence and the Senior Fabric Engineer, providing the detailed business definitions, data profiling, and validation needed to shape the enterprise data warehouse architecture correctly. The Data Analyst also owns the operational mechanics of BI delivery — creating and managing Azure DevOps stories, coordinating user acceptance testing (UAT), and maintaining release documentation — so the BI function can run on a predictable, well-governed cadence.

Ideal candidates have prior experience supporting an enterprise data warehouse or BI modernization effort and are looking to grow into broader data stewardship and analytics responsibilities as the function matures.

Essential Functions

Requirements & KPI Definition

• 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

Data Research & Validation

• 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

Delivery & Operations

• 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

Position 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; experience reading or writing DAX is a plus
• Experience with Azure DevOps or a similar backlog/work-tracking tool
• 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
• Prior experience with Deltek Vantagepoint or similar professional services ERP systems is a plus
• Demonstrated aptitude for learning new technology and adapting to evolving requirements

Travel / Relocation Requirements

• Up to 5%, this may include travel to any or all 50 US states
• Travel is defined as physically leaving home on behalf of business activities including but not limited to client sites, meetings with other employees, meeting for business development purposes, running errands on behalf of the business, attending industry conferences, etc.

Education / Experience Requirements

• Bachelor’s degree in Business Analytics, Information Systems, Statistics, Finance, or related discipline

PLUS

• 4+ years of experience in a data analyst, business analyst, or reporting analyst role
• Experience supporting an enterprise data warehouse, BI platform, or reporting modernization effort is strongly preferred

Benefits

AI2IO offers a very competitive benefits package; highlights include

• Choice of comprehensive medical plans (including two PPO-style plans and a HDHP w/ HSA option)
• Flex spending accounts (FSA)
• Dental and vision plans
• Comprehensive medical, dental and vision benefits extended to spouse / domestic partner and dependent children up to age 26
• 401k with company match and self-directed brokerage account option
• PTO including additional paid time off during the last week of the year
• Company paid life insurance coverage for employees and their eligible dependents
• Short and long-term disability, AD&D coverage
• Professional development opportunities, tuition reimbursement and professional licensing assistance
• Paid parental leave after one year of employment

CO, CA, IL, NY, WA, and Washington DC residents only: In accordance with CO, CA, IL, NY, WA, and Washington DC law, the range provided is AI2IO's reasonable estimate of the base compensation for this role. The actual amount may differ based on non-discriminatory factors such as experience, knowledge, skills, abilities, and location.

AI2IO is an EEO/Affirmative Action Employer and participates in the E-Verify program with the Department of Homeland Security. We encourage diversity in our workforce.