Data Analyst/Report Writer 2
Company: Abacus Service Corporation
Posted on: May 28, 2023
IT STAFFING SERVICES SOLICITATION UNDER
DEPARTMENT OF INFORMATION RESOURCES
IT STAFF AUGMENTATION CONTRACT (ITSAC)
Solicitation Reference Number: 70123042
Working Title: Analyst for Data Validation and Migration
Title/Level: Data Analyst/Report Writer 2
Category: Data/Database Administration
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.
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
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.
Creating and Maintaining Documentation
Sharepoint Experience with Permissions
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
N. All work products resulting from the project shall be considered works made for hire and are the property of the
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
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
Texas Education Agency
Data Analyst/Report Writer
Data Analyst/Report Writer 2
Number of Positions
# of Resumes Allowed
IT STAFFING SERVICES SOLICITATION UNDER
Keywords: Abacus Service Corporation, Austin , Data Analyst/Report Writer 2, Advertising , Austin, Texas
here to apply!