Senior Data Engineer

Job DescriptionJob Description

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!

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 .

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 position headquartered in Herndon, VA. Eastern or central time zones . Competitive compensation commensurate with experience. Participation in company benefit offerings include 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 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.