Data Engineer - 1668

aKube

  • Santa Monica, California
  • 5 days ago

    Highlights

    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.

    Numbers & Facts

    LocationSanta Monica, California
    Websiteakubeinc.com

    Description

    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.



    Similar Jobs