

Developer/Programmer Power BI Analyst 3
Overview:
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.
PROJECT 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.
EXPERIENCE-
Required Qualifications & Skills:
8 Years: PowerBi (or other dashboard application).
8 Years: SAS.
4 Years: Data Gateways
4 Years: SQL
4 Years: Creating and Maintaining Documentation
2 Years: SmartSheets
2 Years:ArcGIS
4 Years: Use of Relational Database
2 Years: Education Data
2 Years: State of Texas Agency Experience.
2 Years: Ed-Fi Data Standard.
Contract Details:
The primary work location(s) will be at 100% Remote, Work Location With-in the United States.
The primary work location will be in the William B. Travis State Building, 1701 North Congress Avenue, Austin, Texas 78701.
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.
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.
S# 70125033
Job Types: Full-time, Contract
Pay: $50.00 - $55.00 per hour
Schedule:
8 hour shift
Monday to Friday
Experience:
PowerBi (or other dashboard application): 8 years (Required)
SAS: 8 years (Required)
Data Gateways: 4 years (Required)
SQL: 4 years (Required)
Creating and Maintaining Documentation: 4 years (Required)
SmartSheets: 2 years (Required)
ArcGIS: 2 years (Required)
Use of Relational Database: 4 years (Required)
Education Data: 2 years (Required)
State of Texas Agency: 2 years (Required)
Ed-Fi Data Standard: 2 years (Required)
Location:
Austin, TX 78701 (Required)
Work Location: Hybrid remote in Austin, TX 78701