Data Engineer

Socket.dev; White House (TN); On-site; USD 90,000 - 130,000; Full time

Job summary

VantageWorks is seeking a Data Engineer to build and support the data infrastructure powering our growing organization. You'll develop data pipelines, improve data quality, and create scalable solutions for reporting, BI, and future AI initiatives.

Join an environment that values curiosity, independence, and collaboration, with opportunities to influence the data ecosystem and work directly with leadership.

Qualifications

• 1–3 years of relevant data engineering experience.
• Strong SQL skills for writing, debugging, and optimizing queries.
• Python (Pandas) for data work.
• Experience with cloud data platforms such as Fabric, Databricks, Snowflake, or Synapse.
• Experience building ETL/ELT pipelines.
• Experience integrating APIs and flat-file data.
• Strong analytical and problem-solving skills.
• Ability to work independently and collaboratively.

Responsibilities

• Design, build, and maintain scalable ETL/ELT data pipelines.
• Integrate data from APIs, flat files, cloud platforms, and 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 proficiency

Python data processing

Analytical thinking

Independent work

Communication

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.