Consultant, Data Engineer
McLean, VA
- Pay
$75,000–120,000/yearAnnual period assumed — pay source
Background in financial services, healthcare or media data. Infinitive is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $75,000 - $120,000.00. Infinitive is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
Read the full posting- Work setting
Hybrid stated — work setting source
**This is a hybrid role and requires work on-site with our clients. About Infinitive: Infinitive is a data and AI consultancy that enables its clients to modernize, monetize and operationalize their data to create lasting and substantial value. We possess deep industry and technology expertise to drive and sustain adoption of new capabilities. We match our people and personalities to our clients' culture while bringing the right mix of talent and skills to enable high return on investment.
Read the full posting- Employment
- Not stated
Before you apply
- Sponsorship
Visa sponsorship not confirmed — sponsorship source
Authorization to work in the United States [confirm sponsorship policy].
Read the full posting
What you’ll work on
Full postingBuild and maintain batch and incremental ETL pipelines in Databricks
Ingest data from databases, APIs, files and cloud storage into Delta Lake
Implement bronze, silver and gold medallion layers
Add data quality checks and troubleshoot failed jobs
Tune Spark jobs for performance and cost
From the employer’s posting
Build and maintain batch and incremental ETL pipelines in Databricks using Python, PySpark and Spark SQL.
Ingest data from relational databases, APIs, flat files and cloud storage (Amazon S3, Azure Data Lake Storage) into Delta Lake tables.
Implement bronze, silver and gold layers following medallion architecture patterns.
Add data quality checks, handle schema changes and troubleshoot failed jobs.
Tune Spark jobs for performance and cost, including partitioning, file sizing and cluster configuration.
What you’ll bring
All qualificationsCore experience
- 1 to 3 years of professional experience in data engineering, software engineering or a related technical role.
- Experience with Delta Lake features such as MERGE and time travel, or with Lakeflow Declarative Pipelines (formerly Delta Live Tables).
- Bachelor's degree in computer science, information systems, engineering, mathematics or a related field, or equivalent experience.
- Experience with Terraform or CI/CD tools such as GitHub Actions or Azure DevOps.
- Hands-on experience with Databricks on a professional or substantial academic project.
- Experience building transformations with Apache Spark and PySpark (DataFrames and Spark SQL).
Qualification wording
1 to 3 years of professional experience in data engineering, software engineering or a related technical role.
Experience with Delta Lake features such as MERGE and time travel, or with Lakeflow Declarative Pipelines (formerly Delta Live Tables).
Bachelor's degree in computer science, information systems, engineering, mathematics or a related field, or equivalent experience.
Experience with Terraform or CI/CD tools such as GitHub Actions or Azure DevOps.
Hands-on experience with Databricks on a professional or substantial academic project.
Experience building transformations with Apache Spark and PySpark (DataFrames and Spark SQL).
Education & alternatives
- 1 to 3 years of professional experience in data engineering, software engineering or a related technical role. - Bachelor's degree in computer science, information systems, engineering, mathematics or a related field, or equivalent experience. - Hands-on experience with Databricks on a professional or substantial academic project.
Tools in this posting
- Python
- SQL
- AWS
- Azure
- Databricks
- dbt
- Delta
- S3
- Spark
- Terraform
- Airflow
- PySpark
- Google Cloud (GCP)
Source — Tool mentions in context
Infinitive has been named “Best Small Firms to Work For” by Consulting Magazine 9 times most recently in 2026. Infinitive has also been named a Washington Post “Top Workplace”, Washington Business Journal “Best Places to Work”, and Virginia Business “Best Places to Work.” About the role As a Consultant, Data Engineer, you will build and maintain data pipelines on Databricks for Infinitive clients. You will work on project teams with senior engineers, architects and business analysts, writing production Python, PySpark and SQL code that moves data from source systems into tables the client's analysts and data scientists use every day. The role is ideal for an engineer with one to three years of experience who wants client-facing work and regular exposure to new data platforms and industries. The client location is McLean, Virginia.What you will do - Build and maintain batch and incremental ETL pipelines in Databricks using Python, PySpark and Spark SQL.
As a Consultant, Data Engineer, you will build and maintain data pipelines on Databricks for Infinitive clients. You will work on project teams with senior engineers, architects and business analysts, writing production Python, PySpark and SQL code that moves data from source systems into tables the client's analysts and data scientists use every day. The role is ideal for an engineer with one to three years of experience who wants client-facing work and regular exposure to new data platforms and industries. The client location is McLean, Virginia.What you will do - Build and maintain batch and incremental ETL pipelines in Databricks using Python, PySpark and Spark SQL. - Ingest data from relational databases, APIs, flat files and cloud storage (Amazon S3, Azure Data Lake Storage) into Delta Lake tables.
- Hands-on experience with Databricks on a professional or substantial academic project. - Working proficiency in Python for data processing. - Experience building transformations with Apache Spark and PySpark (DataFrames and Spark SQL).
- Implement bronze, silver and gold layers following medallion architecture patterns. - Write and tune SQL for transformations, data validation and reporting tables. - Add data quality checks, handle schema changes and troubleshoot failed jobs.
- Working proficiency in Python for data processing. - Experience building transformations with Apache Spark and PySpark (DataFrames and Spark SQL). - Strong SQL, including joins, window functions, CTEs and aggregations.
- Experience building transformations with Apache Spark and PySpark (DataFrames and Spark SQL). - Strong SQL, including joins, window functions, CTEs and aggregations. - Understanding of ETL concepts such as incremental loads, slowly changing dimensions, dimensional modeling and data quality checks.
- Understanding of ETL concepts such as incremental loads, slowly changing dimensions, dimensional modeling and data quality checks. - Familiarity with at least one cloud platform (AWS, Azure or Google Cloud). - Clear written and verbal communication, and comfort explaining technical work to non-technical stakeholders.
- Build and maintain batch and incremental ETL pipelines in Databricks using Python, PySpark and Spark SQL. - Ingest data from relational databases, APIs, flat files and cloud storage (Amazon S3, Azure Data Lake Storage) into Delta Lake tables. - Implement bronze, silver and gold layers following medallion architecture patterns.
- Experience with Delta Lake features such as MERGE and time travel, or with Lakeflow Declarative Pipelines (formerly Delta Live Tables). - Exposure to Unity Catalog, dbt, Apache Airflow or Azure Data Factory. - Experience with Terraform or CI/CD tools such as GitHub Actions or Azure DevOps.
- Exposure to Unity Catalog, dbt, Apache Airflow or Azure Data Factory. - Experience with Terraform or CI/CD tools such as GitHub Actions or Azure DevOps. - Prior consulting or client-facing experience.
- Add data quality checks, handle schema changes and troubleshoot failed jobs. - Schedule and monitor workloads with Databricks Workflows, working within Unity Catalog permissions. - Tune Spark jobs for performance and cost, including partitioning, file sizing and cluster configuration.
- Bachelor's degree in computer science, information systems, engineering, mathematics or a related field, or equivalent experience. - Hands-on experience with Databricks on a professional or substantial academic project. - Working proficiency in Python for data processing.
Nice to have - Databricks Certified Data Engineer Associate certification. - Experience with Delta Lake features such as MERGE and time travel, or with Lakeflow Declarative Pipelines (formerly Delta Live Tables).
- Databricks Certified Data Engineer Associate certification. - Experience with Delta Lake features such as MERGE and time travel, or with Lakeflow Declarative Pipelines (formerly Delta Live Tables). - Exposure to Unity Catalog, dbt, Apache Airflow or Azure Data Factory.
- Schedule and monitor workloads with Databricks Workflows, working within Unity Catalog permissions. - Tune Spark jobs for performance and cost, including partitioning, file sizing and cluster configuration. - Use Git for version control, take part in code reviews and contribute to CI/CD pipelines.
Posting record
Report an error- Status in our records
- Live
- First seen by us
- Oct 17, 2026 · today
- Recorded sightings
- 1
These dates show when we found the listing. Check the employer’s website to confirm it is still accepting applications.
Your next step
- Have your resume and examples of relevant work ready.
- Check the listed location, eligibility and core experience before starting.
Complete your application on infinitive.applytojob.com. The employer’s form will show what is required.
Already applied? Track this application
Job description
**This is a hybrid role and requires work on-site with our clients.
About Infinitive:
Infinitive is a data and AI consultancy that enables its clients to modernize, monetize and operationalize their data to create lasting and substantial value. We possess deep industry and technology expertise to drive and sustain adoption of new capabilities. We match our people and personalities to our clients' culture while bringing the right mix of talent and skills to enable high return on investment.
Infinitive has been named “Best Small Firms to Work For” by Consulting Magazine 9 times most recently in 2026. Infinitive has also been named a Washington Post “Top Workplace”, Washington Business Journal “Best Places to Work”, and Virginia Business “Best Places to Work.”
About the roleAs a Consultant, Data Engineer, you will build and maintain data pipelines on Databricks for Infinitive clients. You will work on project teams with senior engineers, architects and business analysts, writing production Python, PySpark and SQL code that moves data from source systems into tables the client's analysts and data scientists use every day. The role is ideal for an engineer with one to three years of experience who wants client-facing work and regular exposure to new data platforms and industries. The client location is McLean, Virginia.What you will do
Infinitive is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $75,000 - $120,000.00.
Infinitive is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
About Infinitive:
Infinitive is a data and AI consultancy that enables its clients to modernize, monetize and operationalize their data to create lasting and substantial value. We possess deep industry and technology expertise to drive and sustain adoption of new capabilities. We match our people and personalities to our clients' culture while bringing the right mix of talent and skills to enable high return on investment.
Infinitive has been named “Best Small Firms to Work For” by Consulting Magazine 9 times most recently in 2026. Infinitive has also been named a Washington Post “Top Workplace”, Washington Business Journal “Best Places to Work”, and Virginia Business “Best Places to Work.”
About the roleAs a Consultant, Data Engineer, you will build and maintain data pipelines on Databricks for Infinitive clients. You will work on project teams with senior engineers, architects and business analysts, writing production Python, PySpark and SQL code that moves data from source systems into tables the client's analysts and data scientists use every day. The role is ideal for an engineer with one to three years of experience who wants client-facing work and regular exposure to new data platforms and industries. The client location is McLean, Virginia.What you will do
- Build and maintain batch and incremental ETL pipelines in Databricks using Python, PySpark and Spark SQL.
- Ingest data from relational databases, APIs, flat files and cloud storage (Amazon S3, Azure Data Lake Storage) into Delta Lake tables.
- Implement bronze, silver and gold layers following medallion architecture patterns.
- Write and tune SQL for transformations, data validation and reporting tables.
- Add data quality checks, handle schema changes and troubleshoot failed jobs.
- Schedule and monitor workloads with Databricks Workflows, working within Unity Catalog permissions.
- Tune Spark jobs for performance and cost, including partitioning, file sizing and cluster configuration.
- Use Git for version control, take part in code reviews and contribute to CI/CD pipelines.
- Document pipelines, source-to-target mappings and runbooks so client teams can run what you build.
- Join client meetings to clarify requirements, report status and walk through your work.
- 1 to 3 years of professional experience in data engineering, software engineering or a related technical role.
- Bachelor's degree in computer science, information systems, engineering, mathematics or a related field, or equivalent experience.
- Hands-on experience with Databricks on a professional or substantial academic project.
- Working proficiency in Python for data processing.
- Experience building transformations with Apache Spark and PySpark (DataFrames and Spark SQL).
- Strong SQL, including joins, window functions, CTEs and aggregations.
- Understanding of ETL concepts such as incremental loads, slowly changing dimensions, dimensional modeling and data quality checks.
- Familiarity with at least one cloud platform (AWS, Azure or Google Cloud).
- Clear written and verbal communication, and comfort explaining technical work to non-technical stakeholders.
- Authorization to work in the United States [confirm sponsorship policy].
- Databricks Certified Data Engineer Associate certification.
- Experience with Delta Lake features such as MERGE and time travel, or with Lakeflow Declarative Pipelines (formerly Delta Live Tables).
- Exposure to Unity Catalog, dbt, Apache Airflow or Azure Data Factory.
- Experience with Terraform or CI/CD tools such as GitHub Actions or Azure DevOps.
- Prior consulting or client-facing experience.
- Background in financial services, healthcare or media data.
Infinitive is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $75,000 - $120,000.00.
Infinitive is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
Background in financial services, healthcare or media data. Infinitive is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $75,000 - $120,000.00. Infinitive is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
- Location & working pattern
McLean, VA
**This is a hybrid role and requires work on-site with our clients. About Infinitive: Infinitive is a data and AI consultancy that enables its clients to modernize, monetize and operationalize their data to create lasting and substantial value. We possess deep industry and technology expertise to drive and sustain adoption of new capabilities. We match our people and personalities to our clients' culture while bringing the right mix of talent and skills to enable high return on investment.
- Work authorization
- Clear written and verbal communication, and comfort explaining technical work to non-technical stakeholders. - Authorization to work in the United States [confirm sponsorship policy]. Nice to have
See how this role fits your experience
Add your resume to compare the role’s scope, tools and requirements with your experience.