Senior Data Engineer

Vanco

Senior Data Engineer designing, building, and maintaining scalable cloud data solutions for Vanco. Collaborating with cross-functional teams to enhance data-driven decision-making initiatives.

Posted 5/8/2026full-timeRemote • Alabama, Arizona, California, Colorado, Connecticut, District of Columbia, Florida, Idaho, Illinois, Iowa, Kansas, Kentucky, Louisiana, Maryland, Massachusetts, Minnesota, Mississippi, Missouri, Montana, Nevada, New Hampshire, New Jersey, New York, North Carolina, Ohio, Oklahoma, Oregon, Pennsylvania, South Carolina, South Dakota, Tennessee, Texas, Utah, Virginia, Washington, West Virginia, Wisconsin • 🇺🇸 United StatesSenior💰 $110,000 - $140,000 per yearWebsite

Tech Stack

Tools & technologies

AWSAzureCloudETLKafkaPythonSQL

About the role

Key responsibilities & impact

Design, build, and maintain scalable Snowflake-based data warehouse architectures, ensuring performance, reliability, and extensibility for future growth.
Own data architecture and technical design decisions, including data models, integration patterns, and optimization strategies.
Transform raw source data from multiple internal and external systems into analytics-ready data models using industry best practices.
Lead and contribute to warehouse development using dimensional modeling techniques (e.g., star schemas, slowly changing dimensions).
Develop and manage data pipelines using Snowflake features such as Snowpipe, tasks, stored procedures, and performance optimization techniques.
Manage and monitor data integrations with internal systems via APIs, application calls, or custom code to ensure data accuracy and reliability.
Apply auditing, change tracking, error handling, and monitoring across large datasets to maintain high data quality standards.
Identify and resolve data quality issues and implement controls to distinguish valid vs. invalid data used in decision-making.
Leverage Python and application knowledge to interact with and extract data from other systems.
Provide technical leadership through coaching and mentoring junior and mid-level data engineers, including code reviews, design feedback, and best-practice guidance.
Contribute to and help define data engineering standards, best practices, and documentation across the team.
Collaborate across teams to support day-to-day operational data needs and continuously improve data pipelines and processes.

Requirements

What you’ll need

7+ Years of strong hands-on experience with Snowflake, including data modeling, performance tuning, tasks, stored procedures, and ingestion patterns.
7+ Years of advanced hands-on experience in SQL, with deep experience designing and optimizing queries in Snowflake.
Proficiency in Python and experience using Python in data engineering or integration workflows.
Experience working with APIs and application-based data integrations.
Strong understanding of data engineering principles, data warehousing, and cloud-based architectures.
Experience designing and implementing ETL/ELT processes at scale.
Familiarity with cloud environments and data ecosystems (Snowflake, AWS S3, Azure, etc.), with Snowflake being the primary platform.
Experience with data migration and integration tools (e.g., Stitch, Workato, Kafka, API-based ingestion).
Experience working with Salesforce data, including reporting and integration requirements.
Experience working with financial data and understanding of data governance considerations.
Solid understanding of data architecture and modeling methodologies (star schema, snowflake schema, Type 2 dimensions, etc.).
Ability to communicate complex data concepts clearly to technical and non-technical audiences.
Familiarity with Agile development methodologies.
Team-oriented mindset with the ability to work independently and take ownership without heavy oversight.
Strong documentation skills and commitment to maintaining clear, accurate technical artifacts.
Desire and ability to mentor others and learn and adopt new tools and methods.

Benefits

Comp & perks

100% Employer Paid Health Insurance HSA or Base Plan, Dental, Life Insurance, AD&D Insurance, Short Term Disability, Long Term Disability
Additional benefits include Vision, Accident, Critical Illness, Voluntary Life & AD&D
Paid Holidays and 4 weeks PTO
Paid days off to Volunteer
401(k) Plan with employer match
Competitive benefits and pay
Small collaborative teams where you can impact both outcome and culture
Ongoing professional development opportunities
Join a rapidly growing company that promotes internally

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SnowflakeSQLPythonETLELTdata modelingperformance tuningdata warehousingdata integrationdata quality

Soft Skills

technical leadershipcoachingmentoringcommunicationteam-orientedindependencedocumentationproblem-solvingcollaborationownership