About the Role
Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience Senior Business Intelligence (BI) Analyst to play a key role within a high-impact technical services team.
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.
Requirements
- 8 years of experience in business requirements gathering, functional requirements documentation, and business process mapping.
- 8 years of experience in data mapping, data analysis, data quality assessment, data governance, and data integration.
- 3 years of experience documenting system integrations, APIs, ETL processes, and data flows.
- 3 years of proficiency with Microsoft Excel, Microsoft Visio (or equivalent), and Microsoft Office Suite.
- 3 years of proficiency with SQL and business intelligence tools such as Microsoft Power BI.
- 2 years of proficiency with requirements management and project tools (e.g., DevOps, Jira, Modern Requirements).
- 2 years of Proficiency with the Ed-Fi Data Standard/data interoperability frameworks.
- 1 year of experience working with state agencies, education sector, related fields.
Skills
- Business Intelligence (BI)
- Data Integration
- Business Analysis
- Data Mapping
- Data Quality Assessment
- Data Governance
- Data Integration
- System Integrations
- APIs
- ETL Processes
- Data Flows
- Microsoft Excel
- Microsoft Visio
- Microsoft Office Suite
- SQL
- Microsoft Power BI
- DevOps
- Jira
- Modern Requirements
- Ed-Fi Data Standard
- Data Interoperability Frameworks
Location
- Austin
Work Type
- Full-time
Experience Level
- Senior
- 8 years
- 3 years
- 2 years
- 1 year
Benefits
- Highly competitive pay rates
- Local support staff for responsive, personal service
- Medical insurance (with employer cost sharing)
- Life insurance
- A 401(K) plan with company match
- Flexible spending through a cafeteria plan
About the Company
- Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies.
Equal Opportunity
- Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
