Senior Business Intelligence (BI) Analyst

Overview

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.

At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including:

• Highly competitive pay rates
• Local support staff for responsive, personal service
• Comprehensive benefits package, including:
• Medical insurance (with employer cost sharing)
• Life insurance
• A 401(K) plan with company match
• Flexible spending through a cafeteria plan

Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks.

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.

Responsibilities

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.

• 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

Minimum Requirements

Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

8

Required

business requirements gathering, functional requirements documentation, and business process mapping

8

Required

data mapping, data analysis, data quality assessment, data governance, and data integration.

3

Required

documenting system integrations, APIs, ETL processes, and data flows.

3

Required

proficiency with Microsoft Excel, Microsoft Visio (or equivalent), and Microsoft Office Suite.

3

Required

proficiency with SQL and business intelligence tools such as Microsoft Power BI.

2

Required

proficiency with requirements management and project tools (e.g., DevOps, Jira, Modern Requirements)

2

Required

Proficiency with the Ed-Fi Data Standard/data interoperability frameworks

1

Preferred

Experience working with state agencies, education sector, related fields