Data Engineer | TS(SCI Eligible)

4 weeks ago

Springfield, United States Connect Talent Solutions Full time
Job DescriptionJob Description

Connect Talent Solutions is a fast growing, innovative staffing firm offering direct placement, contract and contract to hire solutions. We are uniquely positioned and experienced to support your requirements from IT and engineering to general labor and customer service positions. At Connect, people are the center of our universe and we go to great lengths to ensure that our customers and candidates have the most enjoyable and informational hiring experience that will encourage and foster fruitful, long term relationships and careers.

Job Description:

In your role as data engineer, you will be assigned to an agile scrum team that focuses on the development of extract, transform, and load (ETL) jobs currently using Microsoft SQL, Server, and SSIS. The environment currently supports hundreds of related ETL jobs that move data between 30 different source systems and between multiple classifications. Part of the challenge as a data engineer will be to find scalable and efficient coding solutions that plug into this extensible system in order to add more data to the Enterprise data store. The existing data warehouse is built on Microsoft SQL hosted on Amazon Web Services (AWS), so experience developing solutions that scale well in these environments is a plus. Experience with other data ingest pipelines such as NIFI is also desired as this contract is likely to evolve over the next 5 years to keep up with industry best practices.

In this role you will work with product owners and data stewards to deliver high quality technical solutions in response to business requirements. You will be counted on to provide your peers with technical expertise that will offer solutions for difficult programming problems.

Qualifications

Desired Core Skills:

  • 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:
    o Move data from source databases to target databases
    o Clean / Condition data
    o Convert or transform data
    o Reconcile and confirm converted data
    o Find data errors
    o Validate data to business rules
    o Ability to examine existing ETL scripts and track data back to
    source
  • SQL Server administration, tuning, and workbench.
    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.

Connect Talent Solutions is an Equal Opportunity Employer-Minorities/Females/Veterans/Individuals with Disabilities.  Individuals with disabilities, including disabled veterans or veterans with service-connected disabilities, are encouraged to apply.  

Job Location:

Springfield, VA

  • TS/SCI Windows Engineer

    4 weeks ago

    Springfield, United States Marathon TS Full time

    Marathon TS is currently hiring for a TS/SCI cleared Windows Engineer to join our team to support our intelligence customer in Springfield, VA. HOW A WINDOWS ENGINEER WILL MAKE AN IMPACT Job Description: Responsibilities: Perform advanced troubleshooting and resolution of complex Server OS related issues to ensure optimal performance and availability...

  • Data Modeler

    2 weeks ago

    Springfield, United States Tulk LLC Full time

    Data Modeler - TIBTULK is a leading boutique consulting firm providing technology and management consulting services to the US Federal Government. Our expert team assists Defense and National Security clients in acquiring, designing, managing, and developing advanced technology systems and business practices to advance their missions. We offer tailored...

  • Data Modeler

    4 weeks ago

    Springfield, United States Tulk LLC Full time

    Job DescriptionJob DescriptionData Modeler - TIBTULK is a leading boutique consulting firm providing technology and management consulting services to the US Federal Government. Our expert team assists Defense and National Security clients in acquiring, designing, managing, and developing advanced technology systems and business practices to advance their...

  • System Engineer

    3 weeks ago

    Springfield, United States Alta It Services Full time

    Job Description Job Description System Engineer Top Secret/SCI Springfield, VA JOB DESCRIPTION: · Contributes to completion of milestones associated with specific engineering projects · Develops solutions to a variety of engineering problems of moderate scope and complexity · Perform systems design, development, and integration from the start of a systems...

  • Software Engineer

    6 days ago

    Springfield, United States North Point Technology Full time

    ***This job requires active TS/SCI clearance. Please apply only if you have an active TS/SCI clearance. *** North Point Technology is looking for a TS/SCI Cleared Software Engineers to support a critical mission out of Springfield, VA. Primary Responsibilities: The Software Engineer will be part of a small team that focuses on advancing and automating...

  • Software Engineer

    4 days ago

    Springfield, United States North Point Technology Full time

    ***This job requires active TS/SCI clearance. Please apply only if you have an active TS/SCI clearance. *** North Point Technology is looking for a TS/SCI Cleared Software Engineers to support a critical mission out of Springfield, VA. Primary Responsibilities: The Software Engineer will be part of a small team that focuses on advancing and automating...

  • Software Engineer

    6 days ago

    Springfield, United States North Point Technology Full time

    Job DescriptionJob Description***This job requires active TS/SCI clearance. Please apply only if you have an active TS/SCI clearance. ***North Point Technology is looking for a TS/SCI Cleared Software Engineers to support a critical mission out of Springfield, VA.Primary Responsibilities:The Software Engineer will be part of a small team that focuses on...

  • Action Officer TS/SCI

    3 weeks ago

    Springfield, United States TENICA and Associates LLC Full time

    Action Officer TSSCI - Careers At Tenica and Associates Share with friends or Subscribe! Back To Openings Action Officer TS/SCI Department: Govt Customer-Springfield Location: Springfield, VA START YOUR APPLICATION TENICA is looking to hire action officers, TS/SCI with CI poly. Responsibilities: - Provide senior executive level support - Track actions;...

  • System Engineer

    4 weeks ago

    Springfield, United States ALTA IT Services Full time

    Job DescriptionJob DescriptionSystem Engineer Top Secret/SCI Springfield, VA  JOB DESCRIPTION:· Contributes to completion of milestones associated with specific engineering projects· Develops solutions to a variety of engineering problems of moderate scope and complexity· Perform systems design, development, and integration from the start of a systems...

  • System Engineer

    2 weeks ago

    Springfield, United States ALTA IT Services Full time

    Job DescriptionJob DescriptionSystem Engineer Top Secret/SCI Springfield, VA  JOB DESCRIPTION:· Contributes to completion of milestones associated with specific engineering projects· Develops solutions to a variety of engineering problems of moderate scope and complexity· Perform systems design, development, and integration from the start of a systems...

  • Tableau Analyst with active TS/SCI

    3 weeks ago

    Springfield, United States RTI Consulting, LLC Full time

    RTI is seeking a TS/SCI cleared individuals with a Strong Tableau Experience who will manage the life cycle of Tableau analytics dashboards, including business requirements gathering, functional specification write-up, prototyping, development, quality testing, user acceptance testing, roll-out and post-launch enhancements implementation to support customer...

  • Configuration Manager

    1 week ago

    Springfield, United States Tenica and Associates Full time

    Apply Description Configuration Manager TS/SCI with CI poly TENICA is looking to hire Configuration Manager (CM). Location: Springfield VA Responsibilities: * Serve as the executor of site CM forums * Prepare and promulgate meeting notices, agendas, and minutes for site-level CM forums, including, but not limited to, Configuration Control Boards...

  • System Engineer

    3 weeks ago

    Springfield, United States TENICA and Associates LLC Full time

    Description TENICA is looking to hire System Engineers Job Location: Springfield, VA Responsibilities: Define and propose novel methods to utilize digital engineering (DE) (i.e., Model-Based Systems Engineering (MBSE)) techniques and tools to improve systems engineering processes, utilizing available enterprise tools. Define and propose novel methods to...

  • Cloud Engineer

    2 weeks ago

    Springfield, United States Accede Solutions Inc. Full time

    Cloud Engineer - TS/SCI Springfield, VA - Onsite The Cloud Engineer will be responsible for working with highly functional development team automating service deployments; optimizing system performance; integrating with enterprise authentication services; establishing/improving system monitoring; maintaining established security protocols; provide...

  • Tableau Analyst with active TS/SCI

    1 month ago

    Springfield, United States RTI Consulting, LLC Full time

    RTI is seeking a TS/SCI cleared individuals with a Strong Tableau Experience who will manage the life cycle of Tableau analytics dashboards, including business requirements gathering, functional specification write-up, prototyping, development, quality testing, user acceptance testing, roll-out and post-launch enhancements implementation to support customer...

  • Tableau Analyst with active TS/SCI

    1 month ago

    Springfield, United States RTI Consulting, LLC Full time

    RTI is seeking a TS/SCI cleared individuals with a Strong Tableau Experience who will manage the life cycle of Tableau analytics dashboards, including business requirements gathering, functional specification write-up, prototyping, development, quality testing, user acceptance testing, roll-out and post-launch enhancements implementation to support customer...

  • Tableau Analyst with active TS/SCI

    4 weeks ago

    Springfield, United States RTI Consulting, LLC Full time

    RTI is seeking a TS/SCI cleared individuals with a Strong Tableau Experience who will manage the life cycle of Tableau analytics dashboards, including business requirements gathering, functional specification write-up, prototyping, development, quality testing, user acceptance testing, roll-out and post-launch enhancements implementation to support customer...

  • Geoint Analyst

    4 weeks ago

    Springfield, United States Xcellent Technology Solutions Full time

    As a GEOINT Analyst, your mission is to provide timely, relevant, and accurate geospatial intelligence that extends beyond specific methodological imagery proficiencies to support critical global mission efforts. With a broadened technical scope, you will contribute to the mission by analyzing and exploiting geospatial data, remote sensor imagery, drone...

  • Cloud DevOps Engineer

    5 days ago

    SPRINGFIELD, VA, United States Phoenix Operations Group Full time

    TS/SCI Clearance RequiredWe have an immediate opening for a DevOps engineer that is interested in working on a mature, production environment focused, CI/CD Operational team.General Duties:Leverage AWS and CI/CD technologies to streamline and maintain a DevSecOps pipeline for mission critical-software applications.  Since most of the work is conducted...

  • Data Analyst with TS/SCI- Direct Hire

    1 week ago

    Springfield, United States Elite Technical's Customer Full time

    Data AnalystOur client, a federal contractor is seeking a Data Analyst who examines data from multiple disparate sources with the goal of providing security and privacy insight. Designs and implementscustom algorithms, workflow processes and layouts for complex, enterprise-scale data sets used for modeling, data mining, and research purposes.The position is...