Senior Business Intelligence (BI) Analyst
Allied Consultants, Inc. · Austin, TX · 6 days ago
AnalystFull-time
Responsibilities
- Lead the discovery, documentation, and design of data and business requirements that support the development of OnePlan.
- Bridge business and technical teams by establishing a comprehensive data foundation, defining integration strategies, and translating complex business needs into clear, actionable requirements for system design and vendor implementation.
- Develop a comprehensive, vendor-ready data map by inventorying client and external data systems and documenting data sources, ownership, formats, dependencies, and data integration requirements.
- Assess data quality across systems by identifying gaps, inconsistencies, duplications, and standardization needs, and recommend data cleansing and validation strategies.
- Design a scalable data integration strategy that improves data accessibility, interoperability, usability, and long-term sustainability across client systems aligned with client implementation of the Ed-Fi data standard.
- Serve as the Business Analyst for OnePlan by gathering, analyzing, and documenting business and system requirements (Modern Requirements format)—including process flows, skip logic, system interdependencies, and user interface mock-ups—and translating them into clear functional requirements for vendor design and development.
- Support with broader IDS teamwork-streams such as LASO, GSA, OneSystem, and others.
Qualifications
- 8+ years of experience required in business requirements gathering, functional requirements documentation, and business process mapping.
- 8+ years of experience required in data mapping, data analysis, data quality assessment, data governance, and data integration.
- 3+ years of experience required in documenting system integrations, APIs, ETL processes, and data flows.
- 3+ years of experience required in proficiency with Microsoft Excel, Microsoft Visio (or equivalent), and Microsoft Office Suite.
- 3+ years of experience required in proficiency with SQL and business intelligence tools such as Microsoft Power BI.
- 2+ years of experience required in proficiency with requirements management and project tools (e.g., DevOps, Jira, Modern Requirements).
- 2+ years of experience required in proficiency with the Ed-Fi Data Standard/data interoperability frameworks.