Job Title: BigQuery/SQL Developer
Job Description:
This role is in support of the State of TNs TN DATA platform that utilizes multiple use case related to Education Higher Education Children Services Human Services data etc. following the complete data lifecycle of ingestion cleaning ensuring data quality to the presentation layer. This is specifically in the GCP platform.
Work Schedule:
Mon Fri with occasional weekend coverage (work over 37.5 hours in a week may be approved and necessary)
| Location Requirements | |
| Candidate must be local in Tennessee. | | Candidate must be within 50 miles | |
| Background Verification | |
| Minimum Verification Requirements | All candidates require an InfoCubic background check. Please order the following report: TN Package w/ TN Counties Fingerprinting is not required on every contract Check the Fingerprinting Field (Yes/No) under Custom Fields in the requisition or proposal TN Package with TN Counties Background Check - Global Monitor Check
- US Criminal Record Locator w/ Alias
- Federal Criminal History (7 years)
- County Criminal History (7 years)
- National Sex Offender Registry
Some contractors require both fingerprinting and an InfoCubic report. IF Fingerprinting is Yes then please follow these instructions: -
-
- Go to
- Select the State of Tennessee.
- Click on the Digital Fingerprinting option.
- Select the Schedule a New Appointment option.
- Select Dont Know Your Service Code.
- For the Agency Name select Other.
- For Applicant Type select Information Resources.
- Enter the ORI Number TN920795Z.
| |
| Fingerprinting | |
| Fingerprinting | | yes | |
| Requisition QA Session | |
| Covendis can facilitate a Q&A session between a designated hiring manager and interested suppliers. Check the box if you would like to be contacted about hosting a Q&A session. | | | |
| Break Out Invoice By | |
| Breakout Invoice By PO | | | |
| Type | | Category | | Qualification | | Description | | Competency | | Required | | |
| Skills | | Languages | | Python | | Experience with Python scripting for data manipulation and processing. | | Proficient (46 Years) | | No | |
| Skills | | Languages | | SQL | | SQL Expertise: Strong skills in SQL query optimization and backend data preparation for integration with frontend tools like Tableau and Power BI. | | Proficient (46 Years) | | Yes | |
| Skills | | Others | | SQL Development | | Experience as an SQL Developer | | Proficient (46 Years) | | Yes | |
| Skills | | Others | | CI/CD Tools | | Experience with Continuous Integration and Continuous Deployment tools and practices. | | Novice (13 Years) | | No | |
| Skills | | Others | | ETL/ELT Tools | | Familiarity with ETL/ELT processes; knowledge of Informatica is a plus. | | Proficient (46 Years) | | No | |
| Skills | | Others | | Google Cloud Platform (GCP) | | Proficient in using GCP services particularly BigQuery and Dataflow. | | Novice (13 Years) | | Yes | |