Allied Consultants

Senior Business Intelligence (BI) Analyst

Allied Consultants$90K — $120K *
Education, Government & Non-Profit
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of experience in business requirements gathering and functional documentation.
  • 8+ years of experience in data mapping, analysis, quality assessment, and governance.
  • 3+ years of experience with documenting system integrations, APIs, and ETL processes.
  • Proficient in Microsoft Excel, Visio, and Office Suite for data management tasks.
  • Proficient in SQL and business intelligence tools, ideally Microsoft Power BI.
  • Experienced with requirements management and project tools like DevOps and Jira.
  • Familiarity with Ed-Fi Data Standard and data interoperability frameworks preferred.

Responsibilities

  • Develop a comprehensive data map detailing client and external data systems.
  • Assess data quality, identifying gaps and recommending strategies for cleansing and validation.
  • Design scalable data integration strategies to enhance data accessibility and sustainability.
  • Gather and document business and system requirements for OnePlan, translating them into functional requirements for vendors.
  • Contribute to various IDS teamwork streams such as LASO and OneSystem.

Benefits

  • Opportunity to work in a high-impact technical services team.
  • Engagement with strategic initiatives that bridge business and technology.
  • Access to professional development opportunities in data integration.
  • Collaboration with diverse teams across state agencies and the education sector.
Full Job Description
Overview

We are currently seeking an experience Senior Business Intelligence (BI) Analyst to play a key role within a high-impact technical services team.

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.
  1. 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.
  2. Assess data quality across systems by identifying gaps, inconsistencies, duplications, and standardization needs, and recommend data cleansing and validation strategies.
  3. 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
  4. 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.
  5. 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

About Allied Consultants

Allied Universal is an American provider of security systems and services; janitorial services; and staffing. The company was formed in 2016 by the merger of Santa Ana, California-based security and janitorial services company Universal Services of America, and Conshohocken, Pennsylvania-based security firm AlliedBarton Security Services. At the time of the merger, the combined company was reportedly the largest provider of security guards in the United States, with 140,000 trained officers between the two companies. In October 2021, Allied Universal completed a $5.1 billion takeover of British security firm G4S, creating a combined company of 800,000 employees, with revenues of more than $18 billion USD. The company maintains two corporate headquarters, one is in Santa Ana, California and the main headquarters is in Conshohocken, Pennsylvania.
Learn more about Allied Consultants

More Jobs at Allied Consultants

More Education, Government & Non-Profit Jobs

Find similar Senior Business Intelligence (BI) Analyst jobs: