Data Engineer Team Lead

6 days ago


Springfield, Virginia, United States Connect Talent Solutions Full time
About This Role

We are seeking an experienced Data Engineer to join our agile scrum team at Connect Talent Solutions. As a key member of the team, you will play a vital role in designing and developing scalable and efficient ETL jobs using Microsoft SQL, Server, and SSIS.

Job Overview

This is a fantastic opportunity for a talented data engineer to work with a fast-growing innovative staffing firm offering direct placement, contract, and contract-to-hire solutions. You will have the chance to collaborate with product owners and data stewards to deliver high-quality technical solutions in response to business requirements.

Key Responsibilities
  • Design and develop ETL jobs using Microsoft SQL, Server, and SSIS
  • Work with agile scrum teams to identify and implement scalable and efficient coding solutions
  • Collaborate with product owners and data stewards to deliver high-quality technical solutions
  • Provide technical expertise to peers on difficult programming problems
Desired Skills
  • Advanced knowledge of SQL Server Integration Services (SSIS) including UI and custom code features
  • Ability to write or create stored procedures, SQL scripts, SSIS packages that can be used to move data from source databases to target databases, clean/condition data, convert/transform data, reconcile and confirm converted data, find data errors, and validate data to business rules
  • SQL Server administration, tuning, and workbench skills
  • Ability to work with business experts to understand data and complete data mappings
Preferable Secondary Skills
  • Data discovery techniques and data wrangling to pull data together from disparate sources
  • Data modeling techniques
  • Expertise in operating within an Agile based environment and breaking down large tasks into smaller story/point based tasks
  • AWS infrastructure functionality and configuration, installation as applies to databases and specifically
  • Experience in at least one scripting language desirable (PowerShell, Shell, PERL, Python)
  • Expertise in the design and deployment of various components as part of SQL to include SQL Server Integration Services, SSIS - (both Scale-Out and non-Scale-Out)
  • Understanding of SSIS ETL jobs including setting up and monitoring job length and performance
  • SQL Server Reporting Services (SSRS) – Decent to Solid understanding of monitoring the SSRS core database tables with regards to report run-time and slow reporting performance

We offer a competitive salary of $110,000 - $130,000 per year, depending on experience. If you are a motivated and detail-oriented data engineer looking for a challenging role, please apply today



  • Springfield, Virginia, United States Strategic ASI Full time

    We are looking for a talented Data Architect, Senior to join our team at Strategic ASI.About the RoleThe Senior Data Architect will be responsible for designing and implementing innovative data solutions to support our customers in Springfield, VA or St. Louis, MO. This role requires a strong understanding of data engineering, architecture, and design...


  • Springfield, Virginia, United States Connect Talent Solutions Full time

    Job Title: Senior Python Data EngineerEstimated Salary: $80,000 - $120,000 per year in Springfield, VAAbout UsConnect Talent Solutions is a fast-growing staffing firm that specializes in direct placement, contract, and contract-to-hire solutions. Our company is uniquely positioned to support clients' requirements across various industries.Job DescriptionWe...


  • Springfield, Virginia, United States INflow Federal Full time

    Unlock your potential in the cutting-edge field of Artificial Intelligence and Machine Learning at INflow Federal, a leading provider of innovative solutions for the Department of Defense. As an AI Engineer for Advanced Data Solutions, you will be at the forefront of developing and implementing cutting-edge AI/ML technologies to empower DoD customers with...


  • Springfield, Virginia, United States Innovative Data Solutions LLC Full time

    Job Summary:We are seeking a highly skilled AI Geospatial Solutions Engineer to support our mission critical IT infrastructure for the US Government Intelligence, Defense and Homeland Security communities. This position requires a strong background in machine learning engineering and geospatial data analysis.About the Job:In this role, you will be...


  • Springfield, Virginia, United States Allen Integrated Solutions LLC Full time

    Job DescriptionAllen Integrated Solutions LLC is seeking a highly skilled Data Scientist Exploitation Lead to join our team.About the RoleThis role will involve leading the design and application of methods to identify, collect, process, and analyze large volumes of data to build and enhance products, processes, and systems. The successful candidate will...


  • Springfield, Virginia, United States Robinson Consulting Group, LLC Full time

    Join the Robinson Consulting Group, LLC team as a Chief Systems Engineering Lead in our cutting-edge geospatial intelligence department. As an expert-level professional with extensive experience in systems engineering, you will be responsible for leading high-performing teams in delivering complex projects across multiple domains.Job Summary:We are seeking a...


  • Springfield, Virginia, United States Innovative Data Solutions LLC Full time

    Job SummaryWe are seeking an experienced DevOps Engineer to support our IC customer/contract in a challenging role that requires a TS/SCI clearance and eligibility to obtain a CI polygraph.In this role, you will design and define the DevOps architecture for new or existing IT systems, coordinating system development to include design, modeling, security,...


  • Springfield, Virginia, United States General Dynamics Information Technology Full time

    At General Dynamics Information Technology, we deliver consulting, technology, and mission services to every major agency across the U.S. government, defense, and intelligence community.We are seeking a highly skilled Data Visualization Specialist - Systems Engineering to join our team. This role will be responsible for delivering cutting-edge solutions to...

  • Technical Team Lead

    7 days ago


    Springfield, Virginia, United States SAIC Full time

    Job SummaryWe are seeking a highly skilled Technical Team Lead to oversee and manage a team of engineers providing maintenance and operational support for our network enterprise tools. The ideal candidate will have a strong background in systems engineering, excellent leadership skills, and the ability to communicate effectively with senior leaders and...


  • Springfield, Virginia, United States Innovative Data Solutions LLC Full time

    We are seeking an experienced Senior DevOps Engineer to support our IC customer/contract in the Washington, DC area. This position requires a TS/SCI clearance and eligibility to obtain a CI polygraph.Job OverviewThis role will involve designing and defining the DevOps architecture for new or existing IT systems. You'll coordinate system development to...


  • Springfield, Virginia, United States Rividium Inc Full time

    About the JobWe are seeking an experienced Data Analyst to join our team at RiVidium Inc. As a Data Analyst, you will play a key role in examining data from multiple sources, providing security and privacy insights, and designing custom algorithms for complex data sets.Responsibilities:Analyze and define data requirements and specifications.Plan for...


  • Springfield, Virginia, United States Innovative Data Solutions LLC Full time

    Job SummaryWe are seeking a skilled Hybrid-Cloud Platform Engineer to support our IC customer/contract in the Springfield, VA area. This position requires a Top Secret/SCI clearance and eligibility to obtain a CI polygraph.The ideal candidate will have a strong understanding of cloud-based infrastructure and platform services, including RedHat OpenShift and...


  • Springfield, Virginia, United States Arena Technical Resources Full time

    Job Description:">Arena Technical Resources is seeking a highly skilled Sr. Software Developer to join our team. This position is based in Springfield, VA and offers a competitive annual salary of $180,000.">About the Role:">The successful candidate will be responsible for designing, developing, evaluating, planning and testing software programs and...


  • Springfield, Virginia, United States Robinson Consulting Group, LLC Full time

    About the RoleWe are seeking an experienced IT solution architect to lead the design and development of software solutions for complex applications problems. This role requires a deep understanding of software architecture, data services, platform services, cloud services, and infrastructure services.As a software expert, you will make high-level design...


  • Springfield, Virginia, United States Top Secret Clearance Jobs Full time

    About the role, we are seeking a highly motivated and experienced Lead Systems Engineer to join our team at Top Secret Clearance Jobs. The ideal candidate will have a strong background in systems engineering, particularly in the field of geospatial intelligence, and will be able to lead complex projects from start to finish.Job Description:We are looking for...


  • Springfield, Virginia, United States Leidos Full time

    Job OverviewWe are seeking a skilled Network Engineer to join our team at Leidos, supporting computer data communications systems and providing design specifications, testing, and inspections for computer networks.About the RoleThe successful candidate will support the installation and maintenance of client LAN/WAN devices.They will respond to and resolve...


  • Springfield, Virginia, United States Peraton Full time

    Peraton is a next-generation national security company that drives missions of consequence. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies.We are seeking an experienced Systems Architect to join our team in...


  • Springfield, Virginia, United States Innovative Data Solutions, Inc. Full time

    Innovative Data Solutions, Inc. is seeking a skilled Cloud Operations Engineer to join our team in Springfield, VA. As a key member of our Continuous Operations Release Environment (CORE) team, you will be responsible for providing high-quality cloud solutions to our clients by maintaining and enhancing our cloud infrastructure.Key ResponsibilitiesMaintain...


  • Springfield, Virginia, United States Connect Talent Solutions Full time

    Job Title: Python Data Warehouse DeveloperJob Description:Create and maintain a Python-based data warehouse processing system on Red Hat Enterprise Linux.Collaborate with ETL engineers, database administrators, and business intelligence specialists to implement new features and scale the application.Analyze business operations requirements for data, evaluate...


  • Springfield, Virginia, United States Peraton Full time

    About the RolePeraton is seeking a highly experienced Senior Enterprise Release Manager - Systems Engineering Lead to join our team in Springfield, VA. As a key member of our engineering team, you will be responsible for leading and implementing complex processes and concepts in large-scale, cross-functional environments.Key ResponsibilitiesSupport the...