Data Analyst
About The Position
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.
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
Nice To Haves
- Experience reading or writing DAX
- Prior experience with Deltek Vantagepoint or similar professional services ERP systems
- Experience supporting an enterprise data warehouse, BI platform, or reporting modernization effort is strongly preferred
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
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
