Solicitation Reference Number 302CSD2504 Customer Name Office of the Attorney General of Texas Category Data/Database Administration Customer Entity Name ttorney General, Office of the Title Data Scientist (Big Data Engineer)

Level Data Scientist (Big Data Engineer) 2 Estimated Hours 1,000 SSR Status Posted Number of Positions 2 Status New # of Resumes Allowed 1 Candidates Submitted Full/Part Time Full Time

IT STAFFING SERVICES SOLICITATION UNDER DEPARTMENT OF INFORMATION RESOURCES IT STAFF AUGMENTATION CONTRACT (ITSAC) Solicitation Reference Number: 302CSD2504 Working Title: Data Scientist Title/Level: Data Scientist (Big Data Engineer) 2 Category: Data/Database Administration Full Time

I. Description Of Services

Office of the Attorney General of Texas

requires the services of

2 Data Scientist (Big Data Engineer) 2 , hereafter referred to as Candidate(s), who meets the general qualifications of

Data Scientist (Big Data Engineer) 2, Data/Database Administration

and the specifications outlined in this document for the

Office of the Attorney General of Texas .

ll work products resulting from the project shall be considered "works made for hire " and are the property of the

Office of the Attorney General of Texas

and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law.

Office of the Attorney General of Texas

will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).

The Office of the Attorney General's Chief Data Office (CDO) is seeking a dynamic and visionary Data Scientist to join our team and support our System Modernization efforts for the Child Support Division. This individual must be able to work in a heavily technical environment, preparing and optimizing data for Snowflake and utilizing SAS Viya to build comprehensive federal and state reports. You will play a pivotal role in transforming, analyzing, and leveraging our data assets to drive strategic initiatives and business outcomes. You must be comfortable analyzing data, developing predictive modeling algorithms, and can communicate your findings through visualizations enabling the discovery of solutions to business problems. As a Data Scientist your role will be impactful, visible, and rewarding.

Responsibilities will include: Data Conversion and Reporting Support

for System Modernization Efforts

Data Transformation and Integration : Prepare and optimize data for migration to Snowflake and SAS Viya platforms, ensuring seamless integration and functionality by creating data transformation processes using ETL, SQL, Python, and R.

Develop Federal and State Reports : Build comprehensive reports that meet federal and state requirements using Snowflake and SAS Viya, ensuring accuracy and compliance.

Scrum Team Collaboration : Work as a member of an agile team to deliver new features and functions, delivering best-in-class value-based technology solutions.

Data Quality Management:

Develop and implement databases, ETL processes, data collection systems, and data quality strategies that optimize statistical efficiency, accuracy, and quality.

Problem Examination and Resolution : Examine problems within the Data Intelligence space using ETL, Lambda, and Glue, and implement necessary changes to ensure data quality improvement.

Data Analytics and Insights:

Utilize advanced data analytics techniques to support strategic decision-making, ensuring data integrity, quality, and timeliness of results.

The above job description and requirements are general in nature and may be subject to change based on the specific needs and requirements of the organization and project.

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 4 Required Proven experience in data conversion and report building using Snowflake and SAS Viya. 4 Required Demonstrated experience in data transformation processes using ETL, SQL, Python, and R. 4 Required Experience working with data analytics and business intelligence tools. 4 Required Experience working in a Scrum or Agile development environment. 4 Required Proficiency in ETL processes and tools such as AWS Glue and Lambda. 4 Required Strong knowledge of database management and data warehousing concepts. 4 Required Expertise in SQL for data querying and manipulation. 4 Required Proven experience in data conversion and report building using Snowflake and SAS Viya. 4 Required Demonstrated experience in data transformation processes using ETL, SQL, Python, and R. 4 Required Experience working with data analytics and business intelligence tools. 4 Required Experience working in a Scrum or Agile development environment. 4 Required Proficiency in ETL processes and tools such as AWS Glue and Lambda. III. TERMS OF SERVICE

Services are expected to start

11/12/2024

and are expected to complete by

08/31/2025 . Total estimated hours per Candidate shall not exceed

1000

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

Office of the Attorney General of Texas . 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

OAG State Office located at 5500 E. Oltorf St, Austin, TX 78741 . The working position is

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

Office of the Attorney General of Texas

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

Office of the Attorney General of Texas . V. OTHER SPECIAL REQUIREMENTS

The candidate(s) will be subject to a criminal background check that includes a DPS/FBI background check and fingerprinting.