Job Description
Fast-paced, high-growth, technology-driven marketing company serving the digital marketing automotive industry seeks hard working Senior Data Engineer. trong 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.