Data Engineer

The-Providence-Groups; White House (TN); On-site; USD 90,000 - 120,000; Full time

Job summary

VantageWorks, a data-focused partner to The Providence Groups, seeks a Data Engineer to design scalable ETL/ELT pipelines and data infrastructure supporting reporting, BI, and AI initiatives. You will integrate diverse data sources, ensure quality, and optimize data flows for a growing organization.

You will work with cloud data platforms, contribute to a modern data platform, and collaborate with executives to shape data strategy across industries.

Qualifications

• 1-3 years of relevant experience.
• Strong SQL skills- writing, debugging, and optimizing queries against real business data.
• Python (Pandas or similar) for data work.
• Experience with a cloud data platform such as Microsoft Fabric, Databricks, Snowflake, Azure Synapse, or equivalent.
• Experience building ETL/ELT pipelines.
• Experience integrating APIs and flat-file data.
• Strong analytical and problem-solving skills.
• Ability to work independently and collaboratively
• Ability to work with real-world data: profiling, cleaning, validating, documenting

Responsibilities

• Design, build, and maintain scalable ETL/ELT data pipelines.
• Integrate data from APIs, flat files, cloud platforms, and operational systems.
• Clean, validate, transform, and document data.
• Write, optimize, and troubleshoot SQL queries.
• Develop Python scripts for automation and data transformation.
• Collaborate with business stakeholders.
• Support data quality and governance.
• Contribute to cloud-based data architecture.
• Partner with external consultants.
• Help establish the foundation for AI and advanced analytics.

Skills

SQL queries

Python

Data analysis

Problem-solving

Independent work

Collaboration

Data profiling

Tools

Microsoft Fabric

Databricks

Snowflake

Azure Synapse

Job description

Description

About VantageWorks

VantageWorks, LLC on behalf of The Providence Groups, LLC, is a managed services provider (MSP) that partners with entrepreneurial business owners to provide turnkey solutions across operations, finance, human resources, technology, and strategic services. We help businesses scale with confidence by building the people, processes, and technology that drive long-term success.

Position Summary

VantageWorks is seeking a Data Engineer to help build and support the data infrastructure that powers our growing organization. You'll develop data pipelines, improve data quality, and create scalable solutions that support reporting, business intelligence, and future AI initiatives. This is an excellent opportunity for someone who enjoys solving complex problems and wants to help build a modern data platform from the ground up.

Key Responsibilities

• Design, build, and maintain scalable ETL/ELT data pipelines.
• Integrate data from APIs, flat files, cloud platforms, and operational systems.
• Clean, validate, transform, and document data.
• Write, optimize, and troubleshoot SQL queries.
• Develop Python scripts for automation and data transformation.
• Collaborate with business stakeholders.
• Support data quality and governance.
• Contribute to cloud-based data architecture.
• Partner with external consultants.
• Help establish the foundation for AI and advanced analytics.

Why Join Our Team?

• Be an early member of a growing technology function.
• Influence the future of our data ecosystem.
• Collaborate directly with executive leadership.
• Receive mentorship from experienced data professionals.
• Work across diverse industries.
• Grow with an organization investing in data and AI.

Required Qualifications

• 1-3 years of relevant experience.
• Strong SQL skills- writing, debugging, and optimizing queries against real business data
• Python (Pandas or similar) for data work.
• Experience with a cloud data platform such as Microsoft Fabric, Databricks, Snowflake, Azure Synapse, or equivalent.
• Experience building ETL/ELT pipelines.
• Experience integrating APIs and flat-file data.
• Strong analytical and problem-solving skills.
• Ability to work independently and collaboratively
• Ability to work with real-world data: profiling, cleaning, validating, documenting

Preferred Experience

• 3-5 years of experience.
• Exposure to Lakehouse/Medallion architecture (bronze, silver, gold)
• ERP, Payroll/HCM, CRM, or EHR data.
• Power BI semantic models.
• Exposure to AI/LLM tooling (APIs, embeddings, retrieval)
• Git and version control

What Makes Someone Successful

• Curious and eager to solve business problems.
• Comfortable building new processes.
• Self-directed and proactive.
• Passionate about clean, scalable data.
• Strong communicator with technical and non-technical audiences.