Data Engineer Consultant (Databricks)

Location: New York, United States

Salary: $120,000–$175,000 annually, plus potential annual discretionary bonus

Company

hirify.global delivers modern data engineering and cloud data solutions for enterprise clients.

What you will do

• Build and deploy production-grade data pipelines and Lakehouse modernization solutions for enterprise clients.
• Convert legacy Informatica, PL/SQL, and data warehouse systems into PySpark, Databricks SQL, and Delta Live Tables using Medallion Architecture.
• Develop modular, tested dbt models and advanced SQL transformations for trusted business-ready datasets.
• Provision AWS or GCP data infrastructure with Terraform and enforce governance through Unity Catalog.
• Build and monitor ELT/ETL workflows with Apache Airflow and Databricks Workflows while maintaining data quality, lineage, and SLA compliance.
• Participate in client engagements, code reviews, troubleshooting, query optimization, and cloud cost reduction.

Requirements

• Strong production experience with Python and advanced SQL.
• Hands-on experience with Databricks Lakehouse, Delta Lake, PySpark, Unity Catalog, and Workflows.
• Solid experience with dbt for transformation, testing, and documentation.
• Practical Terraform experience deploying AWS or GCP cloud data infrastructure.
• Proficiency with Git and CI/CD workflows, plus experience with schedulers such as Airflow.
• Ability to communicate technical decisions to clients and work effectively in a fast-paced consulting environment.

Nice to have

• Databricks, AWS, or dbt certifications.
• Experience migrating Teradata, Netezza, Snowflake, or Redshift warehouses to Databricks.
• Familiarity with Apache Kafka or change data capture pipelines.

Culture & Benefits

• Direct collaboration with technical client teams and global engineering squads.
• Embedded participation in client projects, daily standups, and code reviews.
• Work focused on delivering cloud-native data solutions in weeks rather than months.
• Potential eligibility for an annual discretionary bonus.