Snowflake Data/Analytics Engineer 1

Capgemini; Sunnyvale (CA); On-site; USD 59,000 - 94,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Retirement benefits

Job summary

Capgemini is seeking a hands-on Snowflake Data/Analytics Engineer 1 for an onsite contract in Sunnyvale, CA. The role centers on driving the analytics lifecycle, from ingesting data sources to delivering production-ready assets and semantic models for enterprise reporting, leveraging Snowflake, dbt, and Power BI.

You will build scalable data solutions, create robust dbt models, and design dashboards for executives while addressing data quality and production issues across Snowflake, dbt, and

Qualifications

• Hands-on Snowflake data engineering experience.
• Proven ability to build and productionize dbt models.
• Advanced Power BI capabilities including semantic modeling and DAX.
• Ability to balance new projects with rapid production support.

Responsibilities

• Transform data using dbt within Bronze-Silver-Gold layers.
• Develop semantic models in Power BI and create DAX measures.
• Build dashboards for executive audiences.
• Oversee end-to-end analytics project delivery from ingestion to reporting.
• Troubleshoot data quality and production issues across Snowflake, dbt, and Power BI.

Skills

Data engineering

dbt proficiency

Power BI expertise

Analytical mindset

Tools

Snowflake

dbt

Power BI

DAX

Job description

Capgemini is seeking a hands-on Snowflake Data/Analytics Engineer 1 for an onsite contract in Sunnyvale, CA. The role centers on driving the complete analytics lifecycle, from ingesting data sources to delivering production-ready assets and semantic models for enterprise reporting, leveraging Snowflake, dbt, and Power BI. The position offers an hourly rate of USD 43 to 68 and a focus on building scalable data solutions for business insights.

Responsibilities

• Data transformation: Develop and adapt dbt models within a Bronze-Silver-Gold layering framework to support robust analytics.
• Semantic layer: Create and refine semantic models in Power BI and implement complex DAX measures for accurate insights.
• Visualization: Design and enhance dashboards suitable for executive audiences using Power BI.
• Operations & support: Oversee end-to-end project delivery from source ingestion to final reporting.
• Troubleshooting: Identify root causes and resolve production issues and data quality problems across Snowflake, dbt, and Power BI.

Requirements

• Snowflake data engineering: Strong hands-on experience designing pipelines, optimizing performance, and managing storage and compute within Snowflake.
• dbt mastery: Proven ability to build and manage modular dbt models in production environments.
• Power BI stack: Advanced proficiency in dashboards, semantic modeling, and DAX.
• Versatility: Demonstrated ability to balance fresh projects with rapid, production-oriented support.

Technologies

• Snowflake
• dbt
• Power BI
• DAX

Benefits

• Medical benefits
• Dental benefits
• Vision benefits
• Retirement benefits