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

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 One Plan. 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 One Plan 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, One System, and others.

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.

• 8 years required: business requirements gathering, functional requirements documentation, and business process mapping.
• 8 years required: data mapping, data analysis, data quality assessment, data governance, and data integration.
• 3 years required: documenting system integrations, APIs, ETL processes, and data flows.
• 3 years required: proficiency with Microsoft Excel, Microsoft Visio (or equivalent), and Microsoft Office Suite.
• 3 years required: proficiency with SQL and business intelligence tools such as Microsoft Power BI.
• 2 years required: proficiency with requirements management and project tools (e.g., Dev Ops, Jira, Modern Requirements).
• 2 years required:
  Proficiency with the Ed-Fi Data Standard/data interoperability frameworks.
• 1 year preferred:
  Experience working with state agencies, education sector, related fields.