{bc}
paylocity

Data Engineer (Mid-Level)

Team Velocity Marketing
Remote, USA
Full-time
Mid · 2+ years experience
Remote
USD 115000-115000 yearly / year
Discovered 3 weeks ago
SQLPythonSnowflakeGitClaude CodeGitHub Copilot

Full Job Posting

Responsibilities

  • Build and maintain scalable data pipelines and ELT/ETL workflows.
  • Develop and optimize data models and data structures that support reporting, analytics, machine learning, and operational applications.
  • Use Snowflake and modern cloud data platforms to ingest, transform, and optimize large datasets.
  • Partner with Business Intelligence and Data Science teams to deliver trusted, production-ready datasets.
  • Build and maintain the data foundations that AI and ML workloads depend on; clean, well-documented, well-governed datasets and feature tables.
  • Implement data quality, validation, and monitoring processes.
  • Support both batch and near real-time data integration requirements.
  • Contribute to APIs and data services that enable internal and customer-facing applications.
  • Use AI coding assistants to accelerate development, while owning and validating everything that ships under your name.
  • Improve data pipeline performance, scalability, and cost efficiency.
  • Document data architectures, pipeline processes, and engineering standards.
  • Participate in code and design reviews and help uphold engineering best practices.

Qualifications

  • 2–3 years of experience in Data Engineering, Software Engineering, or a related field (internships and co-ops count toward this).
  • Strong SQL skills and hands-on experience with a modern cloud data platform, preferably Snowflake.
  • Solid proficiency with Python and Sound Software Development Practices.
  • Experience building and maintaining ELT/ETL pipelines.
  • Working understanding of data modeling and data warehousing concepts.
  • Experience integrating structured and semi-structured data from multiple sources.
  • Familiarity with data orchestration and transformation frameworks.
  • Working knowledge of version control (Git) and branch-based collaboration.
  • Strong troubleshooting instincts and a desire to become a world-class data and SQL debugger.
  • Clear written and verbal communication, and the ability to work independently in a remote-first environment.

AI Qualifications

  • These are the floor, not the ceiling. We expect every engineer on the team to meet this bar on day one!
  • Daily working use of at least one AI coding assistant (Claude Code, GitHub Copilot, Cursor, or similar) for writing, refactoring, debugging code and the judgment to recognize when its output is wrong.
  • Practical prompt-writing ability: can break a real task into clear, scoped instructions and iterate toward a correct result rather than accepting the first answer.
  • Conceptual understanding of how LLMs work at a high level; tokens, context windows, what causes hallucination, and why model output must be validated before it touches production data.
  • Familiarity with calling an LLM via API (any provider) from Python, including handling structured/JSON output.
  • Basic understanding of embeddings and vector search, and what problems they are and are not suited for.
  • Awareness of AI data-governance basics: what client, consumer, or PII data may not be sent to a third-party model, and why.
  • Willingness to bring AI-assisted approaches to the team and share what works.

Preferred Qualifications

  • Automotive industry data experience, including vehicle, dealership, CRM, inventory, consumer, telematics, finance, aftermarket, or mobility datasets.
  • Experience with Matillion preferred, dbt welcome.
  • Experience with Snowflake Cortex, or with LLM and ML features native to a cloud data warehouse.
  • Experience building a retrieval-augmented generation (RAG) pipeline, even at a personal-project level.
  • Familiarity with machine learning data pipelines and feature engineering concepts.
  • Experience with streaming technologies and event-driven architectures.
  • Experience supporting Business Intelligence, Data Science, and AI initiatives.
  • Experience with CI/CD, infrastructure-as-code, or containerization.
  • Experience working in a remote-first environment.

COMPENSATION

  • This position offers competitive compensation starting at $115,000 annually, commensurate with experience, as well as participation in company benefit offerings including medical, dental, vision, unlimited paid leave, 401(k) matching, wellness, and more.

NEXT STEPS

If you meet the requirements, and are interested in applying for this role, please complete the online application, be sure to include a current resume and contact information. Incomplete submissions are not eligible for consideration. No phone calls please.

About Team Velocity

Team Velocity is a full-service marketing agency serving the automotive industry, providing integrated marketing solutions to OEMs and dealerships nationwide. We leverage our proprietary Apollo® technology platform to predict consumer behavior, personalize marketing campaigns, and help dealerships drive more sales and service revenue. Our team members are driven, creative, and collaborative, enjoying a unique culture where innovation and client success are paramount. Join us in revolutionizing automotive marketing and technology through powerful, data-driven insights, continuous improvement, and an unwavering commitment to reliability.

Salary Description

Starting at $115,000 Annually

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Team Velocity Marketing