Data Engineer | Onsite | Sunnyvale, California

Photon Interactive Services Inc.
Sunnyvale, CA, United States
11 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Compensation
$48,000 - $168,000
Working hours
Regular working hours

Tech stack

Query Performance Airflow Amazon Web Services Bash Shell Data Validation Information Engineering Data Files Data Governance Extract Transform Load (ETL) Data Warehousing Dimensional Modeling Python (Programming Language)
+9 more
Performance Tuning SQL Databases Workflow Management Systems Scripting Sql Optimization Snowflake Star Schema Data Management Data Pipelines

Job description

  • Design, build, and operate batch and incremental data pipelines using Python and SQL.
  • Develop and optimize data models and transformations in Snowflake.
  • Write automation and operational scripts to orchestrate, monitor, and troubleshoot data workflows.
  • Implement data quality checks, validation, lineage, and alerting.
  • Tune query performance and manage warehouse cost and resource usage.
  • Collaborate with analysts, data scientists, and application teams to understand requirements and deliver datasets.
  • Document pipelines, schemas, and data contracts.

Requirements

Data Sets, Snowflake Schema, Data Management, Data Warehousing, Python Programming/Scripting Language, SQL (Structured Query Language), Data Modeling, Identify Issues, Scripting (Scripting Languages), Data Quality, * 7+ years of experience in data engineering or a closely related field.

  • Strong Python skills and experience with scripting languages (for example Bash).
  • Advanced SQL, including complex joins, window functions, and performance tuning.
  • Hands-on experience with Snowflake (warehouses, stages, tasks, streams, role-based access).
  • Solid understanding of data warehousing, dimensional modeling, and ETL/ELT patterns., * Experience with orchestration tools (for example Airflow) and transformation frameworks (for example dbt).
  • Familiarity with AWS or GCP data services.
  • Exposure to data governance, security, and privacy practices.

Compensation, Benefits and Duration

Benefits & conditions

Minimum Compensation: USD 48,000

Maximum Compensation: USD 168,000

Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.

Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.

This position is available for independent contractors

No applications will be considered if received more than 120 days after the date of this post.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…