Job Title: Data Engineer with Databricks
Location: Alabany, NY
Duration: 12 Months + Extension
Bill Rate: $87/hour
Job Type: C2C/1099 Contract
Client: To Be Discussed Later
Work Authorization:
Job Description:
We are looking for an experienced Data Engineer with strong hands-on expertise in Databricks, PySpark, Python, and SQL. The candidate will be responsible for designing, developing, and optimizing scalable data pipelines and data-processing solutions in a cloud-based data environment.
The candidate should be a hands-on Data Engineer who has personally built and supported Databricks solutions, rather than someone with only theoretical exposure. They should be able to explain real examples of PySpark transformations, ETL/ELT pipelines, Delta Lake implementations, performance optimization, data-quality controls, and production troubleshooting.
Responsibilities:
- Design and develop scalable ETL/ELT data pipelines using Databricks.
- Develop data-processing and transformation solutions using PySpark and Python.
- Write complex SQL queries for data transformation, validation, and analysis.
- Build and maintain solutions using Delta Lake and Lakehouse architecture.
- Integrate data from multiple sources, including databases, APIs, files, and cloud storage.
- Optimize Spark jobs, Databricks workloads, and SQL queries for performance and cost efficiency.
- Implement data-quality, validation, reconciliation, monitoring, and error-handling mechanisms.
- Troubleshoot production data issues and perform root-cause analysis.
- Collaborate with business analysts, architects, and application teams to translate business requirements into technical solutions.
- Follow engineering best practices for testing, source control, CI/CD, documentation, and production deployment.
Required Skills & Experience:
- 5 8 years of overall Data Engineering experience.
- Strong hands-on experience with Databricks.
- Strong hands-on development experience using PySpark / Apache Spark.
- Strong Python programming skills and advanced SQL skills.
- Experience developing production-grade ETL/ELT pipelines.
- Experience with Delta Lake and Lakehouse concepts.
- Experience processing large-volume and complex datasets.
- Good understanding of data modeling, data quality, and data governance principles.
- Strong troubleshooting and performance-tuning skills.
- Experience with at least one cloud platform: Microsoft Azure, AWS, or Google Cloud.
- Experience with Git and CI/CD practices.
Equal Opportunity Employer: We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.
