What are the responsibilities and job description for the PowerBI Developer position at Allied Consultants, Inc.?
Overview
Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced PowerBI Developer to be a key resource on a technical services team.
Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background checkAllied Consultants is an equal opportunities employer.
Responsibilities
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
- (4) 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
Other Experiences:
- Prior work with Education Data
- Prior work at a Texas State agency
- Prior work with Ed-Fi data standard
**Location of job: Remote**
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
PowerBI (or other dashboard application)
8
Required
SAS
4
Required
Data Gateways
4
Required
SQL
4
Required
Creating and Maintaining Documentation
2
Required
SmartSheets
2
Required
ArcGIS
4
Preferred
Use of Relational Database
2
Preferred
Education Data
2
Preferred
State of Texas Agency Experience
2
Preferred
Ed-Fi Data Standard
