Data Engineer - 1668

City: Santa Monica, CA/ Burbank, CA or Glendale, CA

Onsite / Hybrid / Remote: Hybrid. Onsite Monday through Thursday. Remote Friday.

Duration: 6 months - Contract to Hire

Rate Range: Up to $92.50/hr on w2

Work Authorization: GC, USC, All valid EADs except OPT, CPT, H1B

Must Have:

• 4+ years of Data Engineering experience.

• Strong SQL skills, including complex joins, window functions, and analytical queries.

• Hands-on production experience with PySpark and/or Spark SQL.

• Databricks experience, including Delta Lake and Unity Catalog.

• Strong understanding of ETL/ELT pipelines, data modeling, and distributed processing.

Responsibilities:

• Develop and maintain ETL/ELT pipelines using Databricks, PySpark, and SQL for marketing acquisition reporting.

• Migrate existing Snowflake SQL scripts and transformations into Databricks Unity Catalog.

• Build ingestion pipelines for external marketing vendor data.

• Perform data parsing, normalization, transformation, and validation.

• Implement data quality checks, monitoring alerts, and issue resolution workflows.

• Troubleshoot pipeline failures and improve processing performance.

• Support SLA monitoring, logging improvements, and pipeline reliability.

• Collaborate with analytics teams to ensure accurate reporting datasets.

• Participate in code reviews, documentation, and engineering best practices.

Qualifications:

• Minimum 4 years of professional Data Engineering experience or equivalent.

• Experience building production pipelines in Databricks.

• Strong understanding of Delta Lake, Unity Catalog, Lakehouse architecture, and data governance.

• Experience with AWS services such as S3, IAM, EC2, Glue, or Lambda.

• Experience with Apache Airflow or similar orchestration tools.

• Experience processing JSON, Parquet, CSV, and other semi-structured data.

• Experience with Git/GitHub, CI/CD, and modern DevOps practices.

Nice to Have:

• Experience migrating SQL transformations from Snowflake to Databricks.

• Experience working with marketing acquisition or advertising data.

• Experience implementing data quality monitoring and pipeline reliability improvements.