V.L.S. Systems - Denver, CO
posted 9 days ago
Full-time - Mid Level
Remote - Denver, CO
Professional, Scientific, and Technical Services
About the position
The Database Analyst (Cloud Solution Analyst) role is focused on enhancing data management and reporting capabilities within a cloud environment. The position requires a highly experienced Data Specialist who will work on refining data warehouse models, improving ETL processes, and collaborating with business teams to meet data reporting requirements. This role is essential for ensuring data integrity and optimizing data workflows in a hybrid work setting.
Responsibilities
- Refine Data Warehouse Model.
- Improve existing Python ETL (Extract, Transform, Load) code.
- Work with business teams to identify data reporting requirements.
Requirements
- Data Modeling experience.
- 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 is a plus.
Benefits
- Remote work: Hybrid
- Flexibility in working hours
