Solutions Consultant – Data Engineering Generalist

Job Title: Solutions Consultant – Data Engineering Generalist

Client Type: Product-Based Company

Location: California (Remote – must work in PST time zone)

Duration: 10 Months

Visa Status: Open to all visa types

 

Position Overview:

We are seeking two experienced Data Engineering Solutions Consultants to support a leading product-based client. These roles focus on delivering high-quality data engineering solutions leveraging Databricks, Apache Spark, and related tools. The ideal candidates will have at least 2+ years of data engineering experience, solid consulting background, and strong hands-on exposure to Databricks environments.

 

Key Responsibilities:

  • Deliver hands-on implementation and consulting support for Databricks-based data engineering solutions.
  • Build, optimize, and deploy data pipelines using Apache Spark and Databricks on cloud platforms.
  • Work with large datasets and contribute to data processing, transformation, and performance tuning.
  • Collaborate with clients to understand requirements and deliver scalable solutions aligned with business goals.
  • Support development and enhancement of SQL-based data models and ETL pipelines across platforms like BigQuery, Synapse, or Redshift.
  • Use Python and Databricks-supported languages (Scala) to develop data workflows and transformations.
  • Apply best practices in CI/CD, code versioning, and testing for pipeline deployments.
  • Participate in solution design discussions and contribute to data architecture and process improvements.
  • Work across cross-functional teams in an Agile/consultative environment, often engaging with stakeholders.

 

Required Qualifications:

  • 2+ years of Data Engineering experience.
  • 3+ years of consulting experience in a professional services or product environment.
  • Completed Data Engineering Associate certification (Databricks).
  • At least 1 project delivered with hands-on implementation experience in Databricks.
  • Strong understanding of Apache Spark programming on Databricks.
  • Familiarity with SQL and common data warehouse tools (e.g., BigQuery, Synapse, Redshift).
  • Proficiency in Python, and working knowledge of Scala or other Databricks-compatible languages.
  • Experience working in remote environments and across multiple time zones, especially PST.

 

Preferred Skills:

  • Knowledge of Databricks Data Engineering and Optimizing Apache Spark courses (completed or in-progress).
  • Experience in data lake, Delta Lake, and multi-hop pipeline architecture.
  • Familiarity with cloud platforms (Azure, AWS, or GCP).