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 request for new or modified program, 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 user to identify current operating procedures and clarify program objectives. They formulate plans outlining steps required to develop program, 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.