Cloud Database Solutions Analyst

$124,800 - $137,280/Yr

Sohanit - Denver, CO

Full-time - Mid Level

Denver, CO

Professional, Scientific, and Technical Services

About the position

The Cloud Database Solutions Analyst role is a contract position focused on enhancing data management and reporting capabilities within a hybrid work environment. The analyst will leverage their extensive experience in SQL, data warehousing, and Python ETL processes to refine data models and improve existing code, while collaborating with business teams to meet reporting requirements.

Responsibilities

• Refine Data Warehouse Model.
• Improve existing Python ETL (Extract, Transform, Load) code.
• Work with business teams to identify data reporting requirements.

Requirements

• 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.

Nice-to-haves

• 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.

Benefits

• Flexible working hours to accommodate different time zones or project deadlines.