Power BI Consultant for Texas Education Agency, Austin, Tx

Pedigo Staffing Services; Austin (TX); Remote; USD 60,000 - 100,000; Full time

Job summary

An innovative firm is seeking a skilled Power BI Programmer/Consultant to join their team remotely. This role involves transforming existing dashboards and creating new visualizations, ensuring data is accurately represented and accessible. You'll collaborate with users to identify needs and develop solutions that enhance data usability. With a focus on user acceptance testing and documentation, you'll play a crucial role in delivering impactful data insights. If you're passionate about data visualization and have extensive experience with Power BI and SAS, this is an exciting opportunity to make a difference in the education sector.

Qualifications

• 8+ years of experience in Power BI and SAS required.
• Strong skills in SQL and Data Gateways essential for the role.

Responsibilities

• Develop and document computer programs, ensuring user needs are met.
• Transform existing dashboards and create new maps in PowerBI.

Skills

Power BI

SAS

Data Gateways

SQL

Creating and Maintaining Documentation

SmartSheets

ArcGIS

Use of Relational Database

Education Data

State of Texas Agency Experience

Ed-Fi Data Standard

Job description

Title: Power BI Programmer/Consultant

Agency: Texas Education Agency

Solicitation: 70125033

Location: William B. Travis State Building, 1701 North Congress Avenue, Austin, Texas 7870

Duration: On-going, no ending date

Visa: Must be US Citizen, Green Card, EAD. No H1B

Telework Policy: The primary work location(s) will be at 100% Remote, Work Location With-in the United States.

JOB DETAILS:

REQUIRE/PREFERRED SKILLS:

• 8 years, Required - Power BI (or other dashboard application)
• 8 years, Required - SAS
• 4 years, Required - Data Gateways
• 4 years, Required - SQL
• 4 years, Required - Creating and Maintaining Documentation
• 2 years, Required - SmartSheets
• 2 years, Required - ArcGIS
• 4 years, Preferred - Use of Relational Database
• 2 years, Preferred - Education Data
• 2 years, Preferred - State of Texas Agency Experience
• 2 years, Preferred - Ed-Fi Data Standard

All work products resulting from the project shall be considered "works made for hire" and are the property of the Texas Education Agency and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Texas Education Agency will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).

Developers plan, develop, test, and document computer programs, applying knowledge of programming techniques and computer systems. They evaluate user requests for new or modified programs, such as for financial or human resource management systems, clinical research trial results, statistical study of traffic patterns, or analyzing and developing specifications for bridge design, to determine feasibility, cost and time required, compatibility with current system, and computer capabilities. Developers also consult with users to identify current operating procedures and clarify program objectives. They formulate plans outlining steps required to develop programs, using methodologies such as structured analysis and design or object-oriented development.

The projects for this developer include:

The first workstream is a PowerBI development cycle to transform existing Insight to Impact (I2I) dashboards from EPP-facing to public facing. This work involves:

• Consult users about the existing data sources, functionality, and deployment procedures for I2I database and the ASEP public facing dashboards
• Identify best solution for public-facing dashboards built from existing dashboards hosted in a secure environment
• Plan, develop, and test a procedure to extract, load, and deploy data between I2I database and PowerBI dashboards
• Plan, develop, and test a solution to adapt and deploy PowerBI dashboards from secure environment (Insight to Impact dashboards) in public-facing location
• Deploy full solution to production
• Integrate user acceptance testing feedback from EDRS team to improve final product
• Develop documentation to enable ongoing maintenance through additional data loads and dashboard updates

The second workstream focuses on the creation of a new EPP map in PowerBI based on an existing map in ArcGIS. This work requires:

• Consult users about the existing data sources, functionality, and deployment procedures for existing ArcGIS map of all Educator Preparation Programs in Texas
• Develop PowerBI map based on requirements
• Integrate user acceptance testing feedback from EDRS team to improve final product
• Develop documentation to enable ongoing maintenance

Services are expected to start 03/17/2025 and are expected to complete by 08/31/2025. Total estimated hours per Candidate shall not exceed 760 hours. This service may be amended, renewed, and/or extended providing both parties agree to do so in writing.

Services shall be provided during normal business hours unless otherwise coordinated through the Texas Education Agency. Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM, excluding State holidays when the agency is closed.

The primary work location(s) will be at 100% Remote, Work Location With-in the United States. The working position is Telework. Any and all travel, per diem, parking, and/or living expenses shall be at the Candidate's and/or Vendor's expense. Texas Education Agency will provide pre-approved, written authorization for travel for any services to be performed away from the primary work location(s). Pre-approved travel expenses are limited to the rates and comply with the rules prescribed by the State of Texas for travel by its classified employees, including any requirement for original receipts.

The Candidate(s) may be required to work outside the normal business hours on weekends, evenings and holidays, as requested. Payment for work over 40 hours will be at the hourly rate quoted and must be coordinated and pre-approved through Texas Education Agency.