Data Analyst/Report Writer 2

Company: Abacus Service Corporation
Location: Austin
Posted on: May 28, 2023

Job Description:

IT STAFFING SERVICES SOLICITATION UNDER
DEPARTMENT OF INFORMATION RESOURCES
IT STAFF AUGMENTATION CONTRACT (ITSAC)
RFO DIR-CPO-TMP-445



Solicitation Reference Number: 70123042
Working Title: Analyst for Data Validation and Migration
Title/Level: Data Analyst/Report Writer 2


Category: Data/Database Administration
Full Time
-





I. DESCRIPTION OF SERVICES

Texas Education Agency requires the services of 1 Data Analyst/Report Writer 2, hereafter referred to as Candidate(s), who meets the general qualifications of Data Analyst/Report Writer 2, Data/Database Administration and the specifications outlined in this document for the Texas Education Agency.

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).

Data reporting analysts transform data into information that can be utilized to make business decisions and actions. Their work involves acquiring data from other sources, creating reports on a regular basis, correcting any code issues, and ensuring that databases remain error-free and organized.

-

Projects include:

-

Validate and transform Accountability System for Educator Preparation data found in Word, PDF, Excel, and PowerBI dashboards to confirm accuracy of historic data set.

-

Write, Review, troubleshoot, and document PowerBI, SAS program code, and compiled reports to explore inconsistencies in data reporting on the Accountability System for Educator Preparation dashboards.

-

Create and organize SharePoint folders, roles, and permissions for storing data and documents. Migrate and document data and other files.

-

Gather, document, and use user requirements to migrate data for a team.

Create, update, and maintain Smartsheets for tracking work.

-

The analyst works under general supervision with limited latitude for the use of initiative and independent judgment.


II. CANDIDATE SKILLS AND 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


6
Required
Data Validation


6
Required
Microsoft Excel


4
Required
SAS


4
Required
Creating and Maintaining Documentation


4
Required
PowerBI


2
Required
Sharepoint Experience with Permissions


2
Required
Adobe Acrobat


2
Required
SmartSheets


2
Preferred
Education Data


1
Preferred
State of Texas Agency Experience




III. TERMS OF SERVICE


Services are expected to start 05/19/2023 and are expected to complete by 08/31/2023. Total estimated hours per Candidate shall not exceed 752 hours. This service may be amended, renewed, and/or extended providing both parties agree to do so in writing.
IV. WORK HOURS AND LOCATION


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 William B. Travis State Building, 1701 North Congress Avenue, Austin, Texas 78701 (100% Remote iWork s Allowable within the United States). 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.
V. OTHER SPECIAL REQUIREMENTS

NOTE: This is for Full-time work until hours reach zero or when the end of the fiscal year, August 31, 2023, is reached; whichever comes first.

-

Prior work with Education Data and / or at at Texas State Agency preferred

VI. ADDITIONAL TERMS AND CONDITIONS

TERMS AND CONDITIONS (Required):

A. Acceptance of Purchase Order (PO) constitutes vendors agreement to the following Work Order terms and

conditions. No other written notification/acceptance is required.

B. Work Order start date shall not begin prior to the start date on the Purchase Order (PO).

C. Work Order end date will be either when the hours reach zero or when the end of the fiscal year, August 31, 2023, is

reached; whichever comes first.

D. Work Order hours shall not exceed amount listed for each project the Purchase Order (PO).

E. Work Order title, level and rate shall remain the same during the current period and any renewal periods.

F. Work Order may be renewed for up to three (3) additional fiscal years at the same title, level and rate.

Renewal Period 1: September 1, 2023 - August 31, 2024.

Renewal Period 2: September 1, 2024 - August 31, 2025.

Renewal Period 3: September 1, 2025 - August 31, 2026.

G. Work Order hours/projects may be amended or terminated at any time for any reason.

H. Hours per week will be assigned by the manager each week. Hours may vary based on the workload for the week.

I. Services shall be provided during normal business hours unless otherwise coordinated through the TEA. Normal

business hours are Monday through Friday from 8:00 AM through 5:00 PM, excluding State holidays when the

agency is closed.

J. The primary work location will be in the William B. Travis State Building, 1701 North Congress Avenue, Austin, Texas

78701. Any and all travel, per diem, parking, and/or living expenses shall be at the Worker's and/or Vendor's

expense. Remote work may be allowed and should be coordinated with the manager.

K. Vendor acknowledges the term of services are estimates only, not a guarantee, and TEA will only pay for actual

approved time worked.

L. If TEA requires travel, TEA will provide pre-approval written authorization. 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.

M. The Worker 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 listed and must be coordinated and preapproved

through TEA.

N. All work products resulting from the project shall be considered works made for hire and are the property of the

TEA.

O. Worker's Vendor is responsible for validating Worker's credentials.

P. Worker's Vendor acknowledges that this is a time and materials request and that TEA is responsible for assigning

work, monitoring assigned work, validating accuracy and quality of work, and acceptance of work products.

Q. Worker is required to use TEA's timesheet that is required to be completed and turned in no later than the close of

business the last business day of each month. TEA records time based on calendar months. TEA records time in

fifteen-minute increments notated by .25, .50, or .75.

R. TEA reserves the right to approve or reject any Worker throughout the duration of the Work Order.

S. Worker's Vendor shall immediately remove any Worker after notification (by telephone, e-mail, or a memo) from

TEA.

T. Worker's Vendor shall have a commercially reasonable time to replace a removed worker and must notify TEA of the

expected time frame.

U. Worker shall abide by all TEA workplace rules and procedures including completing any required forms and training.

Upon arrival, each Worker should read and reach a general understanding of all applicable principles of TEA's official

procedures. Failure to abide by the TEA's procedures will result in a request to remove the Worker.

V. Worker must limit usage of software tools to those specifically approved by TEA. Worker may not download or

install any other productivity or development tools.

W. TEA has no obligation to provide technical or technology training to any Worker. To the best of its ability, TEA may

provide overview or training sessions on application usage or requirements to the Worker.

Solicitation Reference Number
70123042

Customer Name
Texas Education Agency

Category
Data/Database Administration

Title
Data Analyst/Report Writer

Level
Data Analyst/Report Writer 2

Estimated Hours
752

Number of Positions
1

Status
New

# of Resumes Allowed
1

Full/Part Time
Full Time

Keywords: Abacus Service Corporation, Austin , Data Analyst/Report Writer 2, Advertising , Austin, Texas