Senior Data Engineer

Fast-paced, high-growth, technology-driven marketing company serving the digital marketing automotive industry seeks hard working Senior Data Engineer. Strong MSSQL experience, a must!

The ideal candidate has very strong knowledge of the Microsoft SQL Server engine with a focus on the ability to troubleshoot, optimize, and support existing pipelines (SSIS) and processes, and a desire to learn (or already possess and grow) popular cloud technologies like Snowflake, BigQuery, Matillion, and more.

The ideal candidate is analytical, results-oriented, self-driven, confident, and able to meaningfully contribute to solution design among a team of other skilled data engineers.

This is a full-time, salaried, remote position. Applicants must be located within the continental U.S., eastern or central time zones highly preferred.

RESPONSIBILITIES:

Maintain and support existing MSSQL processes, pipelines (SSIS), and schemas

Migrate existing pipelines and processes to the cloud (Snowflake, GCP)

Analyze and organize raw data sets to meet both functional and non-functional requirements

Develop and test new pipelines and processes, both in MSSQL and cloud environments

With the data engineering team, design and implement solutions that scale to meet business needs

Design and implement data models to support analytics and reporting initiatives

With the software team, develop products that deliver value to our clients

Participate in peer reviews of solution designs and related artifacts

Package and support deployment of releases

Analyze and resolve technical and application problems

Adhere to high-quality development principles while delivering solutions on time and on budget

Provide third-level support to business users

Participate in business operations as necessary to meet business goals

REQUIREMENTS:

Bachelor’s degree in Information Systems, Computer Science, or Information Technology (a 4-year bachelor’s degree is acceptable) - OR - expertise in above subject matters matched by experience

7+ years’ experience in MSSQL data engineering and development

Excellent understanding of T-SQL, stored procedures, indexes, stats, functions, and views

Expert understanding of relational and warehousing database design and querying concepts

Experience with SSIS, data integration, and ETL/ELT procedures

Exposure to agile development methodology

Understanding of version control concepts

Strong desire to learn

Strong desire to be a world-class data and SQL troubleshooter

BENEFICIAL:

Experience with Snowflake cloud data warehouse

Experience with Matillion (Snowflake/BigQuery)

Experience with Google Cloud Platform technology stack: BigQuery, Data Flow, Data Fusion

Experience with BI tools like Sigma, Tableau, and others

Experience with NoSQL databases

COMPENSATION

This is a full-time, salaried, remote position headquartered in Herndon, VA. Eastern or central time zones preferred. Competitive compensation commensurate with experience. Participation in company benefit offerings includes paid time off, medical, dental, vision, 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, contact information, and salary requirements. NO PHONE CALLS PLEASE.

ABOUT TEAM VELOCITY

Team Velocity is a SaaS technology provider serving the automotive industry. We provide an omni-channel marketing automation platform and retailing solutions to OEMs and dealerships nationwide.

We are revolutionizing the automotive industry with cutting-edge technology to help dealers sell and service more cars. Made by dealers for dealers, Team Velocity’s proprietary technology platform Apollo® analyzes consumer behavior to predict who will buy, what they will buy, and when they are ready to service. Apollo automates the entire communication process by delivering hyper-personalized campaigns across every touchpoint, maximizing ROI, and lifetime revenue.

Our vision is to serve our clients with a single technology platform that empowers them to execute intelligent marketing across every online and offline channel. We aim to deliver a frictionless consumer experience, from the initial engagement to the final transaction.

Our team members are hard-working and driven to achieve success for our clients and our unique culture promotes creativity, camaraderie, and success.