Overview:
We are looking for a highly experienced Data Specialist with hands-on experience in SQL (ideally MS Sql Server/Google Big Query), Data Warehousing, and designing and writing code for ETL processes in Python.
Primary Responsibilities:
Refine Data Warehouse Model.
Improve existing Python ETL (Extract, Transform, Load) code.
Work with business teams to identify data reporting requirements.
Required Experience:
Data Modeling
Proficiency in SQL, ideally with experience in MS SQL Server and Google BigQuery.
Hands-on experience in Python ETL coding.
Familiarity with Python libraries such as Pandas, SqlAlchemy, etc.
Experience with ETL tools such as Airflow, NiFi, dbt, or similar.
Desired Experience:
Knowledge of Google Cloud Platform (GCP) services.
Familiarity with Data Warehouse methodologies like Inmon, Kimball, or Data Vault.
Experience with Continuous Integration/Continuous Deployment (CI/CD) tools such as Git, Terraform, etc.
Proficiency in reporting tools like Tableau or R Shiny.
Experience working with public health data is a plus.
A keen interest in code and quality assurance.
Additional Details:
This is a long-term contract position.
The ideal candidate should have strong problem-solving skills and the ability to communicate effectively with both technical and non-technical stakeholders.
The work may involve collaboration with cross-functional teams and the ability to adapt to evolving project requirements.
The candidate should demonstrate a proactive approach to learning and keeping up with advancements in technology and industry best practices.
Work Environment:
Remote work
Flexibility in working hours may be required to accommodate different time zones or project deadlines.
Location Requirements | ||||
Candidate must be local. | Candidate Must Be Local | |||
Additional Location Details (City, State) : | The must candidate to be local- be able to drive in 1 day a week if needed. Candidates willing to move to Colorado will not be considered. | |||
Background Verification | ||||
Minimum Verification Requirements | Please complete the following verifications with Info Cubic upon candidate's selection. Additional verifications may be identified by the agency. State Criminal Record verification (past 7 years covering each State in which the candidate has resided)
Federal Criminal Records Verification (past 7 years) SSN Name Search Global Monitor Check (formerly Patriot/OFAC/Terrorist) |
Bachelor's degree