Senior Data Engineer - Williamsburg, United States - Team Velocity

Team Velocity Williamsburg, United States

3 weeks ago

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

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.

Senior Data Engineer

12 hours ago

Team Velocity Williamsburg, United States

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 ...
Data Engineer

1 hour ago

Booz Allen Hamilton Hampton, United States

Data Engineer · Langley AFB , Virginia , USA · Apply ) · Be you · Be Booz Allen ) · Be empowered · Learn More · Job Description · Location:Langley AFB, Virginia, USA · Remote Work:No · Job Number:R · ...
Automotive Technician

3 weeks ago

AAA Tidewater Virginia Williamsburg, United States Full time

Automotive TechnicianAAA Tidewater has immediate openings for Automotive Technicians in our Williamsburg Car Care Center · Job Duties · Perform minor diagnostics on automobiles as required · Repair vehicles according to manufacturers' specifications including, but not limited to, ...
Requirements Manager

3 weeks ago

SAIC Williamsburg, United States

Job ID: WILLIAMSBURG-VA · **Location**:WILLIAMSBURG, VA, US · **Date Posted**: · **Category**:Engineering and Sciences · **Subcategory**:Systems Engineer · **Schedule**:Full-time · **Shift**:Day Job · **Travel**:No · **Minimum Clearance Required**:Top Secret · **Clearance Level ...
Diesel Mechanic

5 days ago

Transdev Williamsburg, United States Full time

Transdev is now hiring a Diesel Mechanic for our shop serving Williamsburg, Virginia · Wages up to $30/hour Depending on Experience with $3000 Sign On Bonus ** Conditions Apply · Why join Transdev as a Diesel Mechanic? · $28 - $30 / hour based on experience and qualifications ...
Phoenix Diving Coordinator Williamsburg Va

3 weeks ago

Phoenix International Holdings Inc Williamsburg, United States

**SUMMARY DESCRIPTION**: · **GREAT OPPORTUNITY - JOIN US IN WILLIAMSBURG, VA** · **MEET & GREET ON APRIL 18, 2024, 2-PM-6:30 PM** · The Diving Coordinator - Virginia coordinates diving operations with the Phoenix Program Manager and the Navy. Overall responsibility for ensuring t ...
Recreation Assistant Oer

3 weeks ago

US Commander, Navy Installations Williamsburg, United States

**Duties**: · - Issues and receives a variety of recreation equipment to authorized personnel and assists patrons with questions and appropriate selections. Advises patrons in safe boating and camping techniques and administers a safe boating test to patrons as applicable. Discus ...
IT administrator for CAD data exchange

3 weeks ago

Nexus Dynamics Williamsburg, United States

Our client is a German traditional company with more than 10,000 employees and is a well-known player in its industry worldwide. For over 100 years, the company has been developing and building complex products in the drive and engine technology sector. A large number of developm ...
Assistance salary wage

1 week ago

NovaWorks Williamsburg, United States

We are looking for a reliable and detail-oriented employee for a long-term position as Salary and Wage Assistant in full-time. This is a renowned company in the machinery and plant engineering industry, located in Williamsburg, with a global customer base that values comprehensiv ...
Construction Technician

5 days ago

ECS Ltd Williamsburg, United States

What You'll Do: · **No experience required and all training and certifications are provided** · **Responsibilities** · - ** Field Activities**: Conduct observation, testing, sampling, and inspection of materials, including soils, aggregates, concrete, grout, masonry, asphalt, and ...
Estimator

1 week ago

CARDINAL CIVIL RESOURCES Williamsburg, United States

**About This Role**: · Cardinal is seeking an Estimator to join our dynamic and growing team. As an Estimator, you will **_support the business at large and help improve workplace communication and efficiency. You will conduct yourself as a leader with high integrity and excellen ...
Survey Cadd Technician

1 week ago

CARDINAL CIVIL RESOURCES Williamsburg, United States

**CADD Tech** · Cardinal Civil Resources is currently looking for an employee with high integrity and an excellent attention to detail in order to fill a position as a CADD Tech. · **Essential Functions and Responsibilities** · - Perform some office duties, including data reducti ...
Associate Director of Utilities

1 week ago

William & Mary Williamsburg, United States

Position Information · **Position Number** · - FP223W**Position Title** · - Associate Director of Utilities**Employment Category** · - Full Time Professional**Location** · - William & Mary**Department** · Plant Administration**Unit Mission Statement** · - The mission of Business ...
Survey Field Technician

1 week ago

CARDINAL CIVIL RESOURCES Williamsburg, United States

**About This Role**: · Cardinal Civil Resources is currently looking for an employee with high integrity and excellent attention to detail to fill a position as a Survey Field Technician - Instrument Operator. Travel will be required from time to time at different job sites. You ...
Office Administrator

1 week ago

CARDINAL CIVIL RESOURCES Williamsburg, United States

Cardinal is seeking an Office Administrator to join our dynamic and growing team. As an Office Administrator, you will support the business at large and help improve workplace communication and efficiency. You will conduct yourself with high integrity and excellent attention to d ...
Project Engineer Data Manager Specialist

3 weeks ago

Bering Straits Native Corporation Jamestown, United States

Overview · Visit our website at to apply · Equal Opportunity Employer/Veterans/Disabled · SUMMARY · Paragon Professional Services, LLC, a subsidiary of Bering Straits Native Corporation is currently seeking a qualified project Engineer Data Manager Specialist for the United S ...
Operations Analyst

4 weeks ago

William & Mary Williamsburg, United States Full time Operational

Position Summary · The Operations Analyst will play a pivotal role in harnessing the power of data to drive strategic business decisions and process improvements across the Business Affairs organization. Leveraging AWS cloud services, this individual will develop and deploy ETL ...
Lead Mechanic

2 weeks ago

Williamsburg-James City County Public Schools Williamsburg, United States

Job Summary · This position performs highly skilled, master level mechanical and technical diagnostic work in the repair and maintenance of School Division vehicles and equipment. Diagnoses malfunctions in automotive equipment; removes and replaces worn or broken parts, and repl ...
Capital Projects Inspector I/II/III

5 days ago

James City County Williamsburg, United States

$45,704 - $52,339 / year or higher DOQ + Full-Time County Benefits · James City County's General Services Department is seeking an individual to perform responsible (Inspector I/II) or experienced (Inspector III) work inspecting public construction sites in compliance with local ...
Associate Director of Utilities

1 day ago

InsideHigherEd Williamsburg, United States

Position Number:FP223W · Position Title:Associate Director of Utilities · Employment Category:Full Time Professional · Location:William & Mary · Department:951100 Plant Administration · Unit Mission Statement:The mission of Business Affairs is to support W&M as a leader among lib ...