Abacus
Data Analyst/Report Writer 2
Abacus, Austin, Texas, us, 78716
IT STAFFING SERVICES SOLICITATION UNDERDEPARTMENT OF INFORMATION RESOURCESIT 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 Dat 1 Preferred State of Texas Agency ExperienceIII. 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 REQUIREMENTSNOTE: 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 CONDITIONSTERMS 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 Number70123042
Customer NameTexas Education Agency
CategoryData/Database Administration
TitleData Analyst/Report Writer
LevelData Analyst/Report Writer 2
Estimated Hours752
Number of Positions1
StatusNew
# of Resumes Allowed1
Full/Part TimeFull Time
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 Dat 1 Preferred State of Texas Agency ExperienceIII. 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 REQUIREMENTSNOTE: 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 CONDITIONSTERMS 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 Number70123042
Customer NameTexas Education Agency
CategoryData/Database Administration
TitleData Analyst/Report Writer
LevelData Analyst/Report Writer 2
Estimated Hours752
Number of Positions1
StatusNew
# of Resumes Allowed1
Full/Part TimeFull Time