Senior Data Engineer

2 weeks ago

Williamsburg, United States Team Velocity Full time

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 Financial Analyst

    2 weeks ago

    Williamsburg, United States The Judge Group Full time

    Our client is currently seeking a Senior Financial Analyst for their manufacturing facility near Newport News, VA.Responsibilities:Analyze and forecast financial, economic, and other data to provide accurate and timely information for strategic and operational decisions.Work with the Operations, Maintenance and Finance teams to identify weekly indicators and...

  • Senior Financial Analyst

    1 week ago

    Williamsburg, Virginia, United States The Judge Group Full time

    Our client is currently seeking a Senior Financial Analyst for their manufacturing facility near Newport News, VA.Responsibilities:Analyze and forecast financial, economic, and other data to provide accurate and timely information for strategic and operational decisions.Work with the Operations, Maintenance and Finance teams to identify weekly indicators and...

  • Process Control Engineer

    1 week ago

    Williamsburg, United States Mastech Digital Full time

    Quality Engineer Location: Williamsburg Kentucky 40769- 5 days onsite Experienced quality engineer. Automotive specific background experience. Will handle customer complaints. Will lead the team in problem solving. Minimum 2 years of experience as a quality engineer. Ready to interview ASAP. 100% onsite, there are no options for hybrid. 3 months to start....

  • Quality Engineer

    5 hours ago

    Williamsburg, United States Planet Forward Full time

    Description:Experienced quality engineer.Automotive specific background experience.Will handle customer complaints.Will lead the team in problem solving.Minimum 2 years of experience as a quality engineer. Responsible for departmental quality, planning for quality, customer contacts and / or vendor support to ensure that product quality meets and/or exceeds...

  • Senior Generalist

    3 weeks ago

    Williamsburg, Virginia, United States Colonial Williamsburg Full time

    Who We AreFounded in 1926, the Colonial Williamsburg Foundation is a private, not-for-profit educational, historic, and cultural institution that owns and operates one of the largest and best-known museum complexes in the world. Our mission is "that the future may learn from the past" through preserving and restoring 18th-century Williamsburg, Virginia's...

  • Senior/Lead Audio-Video Installation Technician

    4 weeks ago

    Williamsburg, United States OPTECH Full time

    Job DescriptionJob DescriptionSeeking motivated individual with experience installing and troubleshooting audio/video systems in a commercial environments and senior/advanced level service work. Technician will be responsible for the successful outcome of projects and oversee/train co-workers. Installations vary from simple rooms to fully integrated...

  • Senior Product Manager

    1 month ago

    Williamsburg, Virginia, United States Chesapeake Bank Full time

    OverviewChesapeake Bank-In this role, you will provide leadership in the development of the organization's product strategy and product team. Work across the organization to gather insights from primary product sales and support departments. You'll be accountable for strategy input and also recommending new product features and services or changes to the...

  • Research Technician

    2 weeks ago

    Williamsburg, United States The College of William & Mary Full time

    Research Technicians perform a variety of routine, technical, and administrative responsibilities in support of research at the institute. They perform duties such as the following: collecting specimens, preparing materials, and operate specialized lab equipment. Assist in preparation for field work and participate in field activities. Under supervision,...

  • Requirements Manager

    4 days ago

    Williamsburg, United States SAIC Full time

    Job ID: 2406774-WILLIAMSBURG-VA **Location**:WILLIAMSBURG, VA, US **Date Posted**:2024-05-14 **Category**:Engineering and Sciences **Subcategory**:Systems Engineer **Schedule**:Full-time **Shift**:Day Job **Travel**:No **Minimum Clearance Required**:Top Secret **Clearance Level Must Be Able to Obtain**:TS/SCI **Potential for Remote...

  • Cost Estimator

    1 week ago

    Williamsburg, United States ZP Group Full time

    Zachary Piper Solutions is seeking a Pre-Construction Cost Estimator located in the Williamsburg Area of Virginia. The Estimator will develop project cost estimates on a variety of assignments associated with classified governments base operations and maintenance of facilities infrastructure. The Estimator will support the Project Management Office, the...

  • Supervisor for Facilities and Capital Projects

    1 month ago

    Williamsburg, United States Williamsburg-James City County Public Schools Full time

    Job Summary This position performs a variety of responsible, diverse, and complex administrative responsibilities to assist with minor and major capital improvement projects, helps oversee the division’s safety committee activities, monitors air quality issues, and helps develop the division’s Capital Improvements Project budget. Also supervises...

  • Lead Mechanic

    4 weeks ago

    Williamsburg, United States Williamsburg-James City County Public Schools Full time

    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 replaces fluids; enters maintenance data into computerized system. Provides...

  • Quality Coordinator

    4 weeks ago

    Williamsburg, United States Magna International Full time

    Job Number: 65445 Group: Cosma International Division: WILLIAMSBURG MFG. - BLD 1 Job Type: Permanent/Regular Location: WILLIAMSBURG Work Style: About usWe see a future where everyone can live and move without limitations. That's why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the...

  • Quality Coordinator

    2 days ago

    Williamsburg, United States Magna International Full time

    Job Number: 65445 Group: Cosma International Division: WILLIAMSBURG MFG. - BLD 1 Job Type: Permanent/Regular Location: WILLIAMSBURG Work Style: About us We see a future where everyone can live and move without limitations. That's why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the...

  • Quality Coordinator

    4 weeks ago

    Williamsburg, Virginia, United States Magna International Inc. Full time

    Job Number: 65445 Group: Cosma International Division: WILLIAMSBURG MFG. - BLD 1 Job Type: Permanent/Regular Location: WILLIAMSBURG Work Style: About usWe see a future where everyone can live and move without limitations. That's why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the...

  • Applications Developer

    2 weeks ago

    Williamsburg, United States J5 Consulting Full time

    J5 Consulting is a Maryland based company established in 2006 to provide computing and consulting services for government and commercial entities. Our services improve Information System networking performance and compliance and protect electronic assets from loss and compromise. We welcome your application to receive consideration for the following...

  • Director of Human Resources

    1 month ago

    Williamsburg, United States Shoreline Fruit Full time

    Job DescriptionJob DescriptionWe are seeking a dynamic director to champion our company's most valuable asset - our employees. The Director of Human Resources will lead initiatives to foster a collaborative, inclusive workplace environment where talent thrives and enjoys the state of belonging, and where goals are continually exceeded. We are looking for...

  • Director of Human Resources

    4 weeks ago

    Williamsburg, United States Shoreline Fruit Full time

    We are seeking a dynamic director to champion our company's most valuable asset - our employees. The Director of Human Resources will lead initiatives to foster a collaborative, inclusive workplace environment where talent thrives and enjoys the state of belonging, and where goals are continually exceeded. We are looking for a strategic thinker, innovative...

  • Applications Developer

    4 weeks ago

    Williamsburg, United States J5 Consulting Full time

    Job DescriptionJob DescriptionJ5 Consulting is a Maryland based company established in 2006 to provide computing and consulting services for government and commercial entities. Our services improve Information System networking performance and compliance and protect electronic assets from loss and compromise. We welcome your application to receive...

  • Applications Developer

    4 days ago

    Williamsburg, United States J5 Consulting Full time

    J5 Consulting is a Maryland based company established in 2006 to provide computing and consulting services for government and commercial entities. Our services improve Information System networking performance and compliance and protect electronic assets from loss and compromise. We welcome your application to receive consideration for the following...