Senior Business Intelligence (BI) Analyst

Allied Consultants, Inc. • Austin, TX

23h

About The Position

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. The Division of Integrated District Supports is seeking a strategic and detail-oriented System Analyst (Data Integration and Business Analyst) to lead the discovery, documentation, and design of data and business requirements that support the development of OnePlan. This role will 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.

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

Nice To Haves

• 1 year of Experience working with state agencies, education sector, related fields

Responsibilities

• 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.

Benefits

• Medical insurance (with employer cost sharing)
• Life insurance
• A 401(K) plan with company match
• Flexible spending through a cafeteria plan

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed