Data Engineer - 1668

aKube; Santa Monica (CA); Hybrid; USD 105,000 - 150,000; Full time

Job summary

aKube in Santa Monica, CA is seeking a Data Engineer to design and maintain ETL/ELT pipelines using Databricks, PySpark, and SQL for marketing analytics. This hybrid role requires onsite presence Monday–Thursday with remote work on Fridays, and offers a rate range up to $92.50/hr on W2.

You will migrate Snowflake scripts to Databricks Unity Catalog, implement data quality checks, and collaborate with analytics teams to ensure accurate reporting datasets while supporting pipeline reliability and

Qualifications

• 4+ years of professional Data Engineering experience.
• Strong SQL skills with complex joins, window functions, 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.
• Perform data parsing, normalization, transformation, and validation.
• Implement data quality checks, monitoring alerts, and issue resolution workflows.

Skills

SQL

PySpark

Spark SQL

Databricks

Delta Lake

Unity Catalog

ETL/ELT

Data modeling

AWS S3

Airflow

GitHub

CI/CD

JSON/Parquet

Tools

Databricks

Unity Catalog

Delta Lake

AWS

S3

Airflow

Job description

Santa Monica, United States

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