Data Engineer

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

Job summary

The Providence Groups, LLC, through VantageWorks, is seeking a Data Engineer to build and support scalable data infrastructure. You will design and maintain ETL/ELT pipelines, integrate APIs and file data, and develop Python automation to enable reporting, BI, and future AI initiatives.

You will collaborate with stakeholders, ensure data quality, and contribute to cloud-based architecture while growing a modern data platform from the ground up.

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

1–3 years of relevant experience

Strong SQL skills

Python (Pandas or similar)

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.

Requirements

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.