Senior Data Engineer

Fast-paced, high-growth marketing company serving the digital marketing automotive industry seeks hard working Senior Data Engineer.

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. Additionally, you are 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 headquartered in Herndon, VA. No contracts/1099. Candidates must reside in 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 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 or others
• Experience with NoSQL databases

COMPENSATION
This is a full-time, salaried, remote or onsite position headquartered in Herndon, VA. Eastern or central time zones preferred for remote work. Competitive compensation commensurate on experience. Participation in company benefit offerings include, medical, dental, vision, 401K, 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. 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 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.