Talent.com
Data Engineer 2 / SQL Specialist
Data Engineer 2 / SQL SpecialistNetwork Designs Inc. • McLean, VA, USA
Data Engineer 2 / SQL Specialist

Data Engineer 2 / SQL Specialist

Network Designs Inc. • McLean, VA, USA
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
  • [filters_job_card.quick_apply]
[job_card.job_description]

About NDi :

Network Designs, Inc. (NDi) is a leading Federal contractor that specializes in designing, developing, and delivering information technology and network solutions for government customers. Founded in 1985, NDi's firmly defined core values have driven all aspects of the business, which have been paramount to our company's success and the establishment of an enjoyable workplace atmosphere. At NDi, we believe that our people are the cornerstone of our success, and we value collaboration, career growth, and winning ideas. Military Veterans Encouraged to Apply.

Job Description :

The Database Engineer / SQL Specialist will be responsible for designing, developing, and executing SQL and PL / SQL-based data transformations to support accurate migration of legacy VES, EDB, and IVM data into the modernized Enrollment System. This role focuses on data mapping, reconciliation, validation, and performance optimization within Oracle-based environments. The candidate will work closely with data engineers, analysts, and modernization stakeholders to ensure data integrity, accuracy, and auditability throughout migration efforts.

Requirements :

  • U.S Citizenship required.
  • Must be able to obtain and maintain a Public Trust clearance
  • This position is remote but may require occasional onsite meetings in McLean, VA.
  • You can be based out of following states : AZ, DC, FL, GA, OH, ME, MD, SC, TX, UT, VA, NC, OK, WV.

Qualifications and Experience :

  • Bachelor's Degree in Computer Science, Information Technology, Data Science, or a related field
  • At least 3 years of relevant experience in data engineering, SQL development or a related role.
  • Strong proficiency in Oracle SQL and PL / SQL.
  • Experience developing stored procedures, functions, and packages.
  • Experience with indexing strategies, execution plan analysis, and query optimization.
  • Experience with materialized views and partitioning.
  • Experience supporting ETL and ELT data transformations.
  • Experience implementing data validation, reconciliation, and data quality profiling routines.
  • Experience with schema and metadata management.
  • Strong analytical and problem-solving skills.
  • Attention to detail and accuracy.
  • Good communication skills and the ability to work collaboratively in a team environment .
  • Responsibilities

    SQL and PL / SQL Development :

  • Design and implement complex SQL and PL / SQL transformations to support data migration and modernization initiatives.
  • Develop and maintain stored procedures, functions, and packages to support data processing and reconciliation workflows.
  • Data Migration and Transformation :

  • Design and execute ETL and ELT data transformation routines to migrate legacy VES, EDB, and IVM data into the modernized Enrollment System.
  • Implement data mapping logic to ensure accurate field-level and semantic alignment between legacy and target schemas.
  • Data Validation and Reconciliation :

  • Develop and execute data validation and reconciliation routines to verify completeness, accuracy, and consistency of migrated data.
  • Identify, analyze, and resolve data discrepancies and anomalies.
  • Database Performance Optimization :

  • Optimize SQL queries using indexing strategies, execution plan analysis, and query tuning techniques.
  • Design and maintain materialized views and partitioning strategies to support performance and scalability.
  • Schema and Metadata Management :

  • Maintain and enhance database schemas, metadata definitions, and data dictionaries.
  • Support versioned schema changes and metadata traceability throughout migration cycles.
  • Collaboration :

  • Collaborate with data engineers, system integrators, and business stakeholders to understand data requirements and migration constraints.
  • Support integration and testing activities by providing subject-matter expertise on data structures and transformations.
  • Quality, Security, and Compliance :

  • Ensure data handling and migration activities comply with applicable data governance, security, and audit requirements.
  • Support implementation of data quality profiling and monitoring practices.
  • Documentation and Best Practices :

  • Create and maintain documentation for data mappings, transformation logic, reconciliation procedures, and database designs.
  • Follow best practices for SQL development, version control, testing, and code quality.
  • Continuous Improvement :

  • Continuously improve SQL routines, data validation approaches, and migration processes to increase efficiency and reliability.
  • Stay current with Oracle database features and best practices relevant to large-scale data migration.
  • Compensation and Benefits :

    At NDi, we value our team and are committed to retaining top talent by offering competitive benefits and compensation packages. Our employee benefits package includes comprehensive health, dental, vision, pet, and legal insurance. Our corporate benefits include 401(k) retirement matching, paid leave, paid holidays, and health and wellness programs. In addition, we provide employer-paid life and disability insurance, professional development, education benefits, and much more to ensure our team has the resources they need to thrive on and off the job.

    Veterans First Commitment :

    As a Service-Disabled Veteran-Owned Small Business (SDVOSB), NDi is dedicated to hiring veterans and providing a supportive work environment that honors their service while recognizing the unique skills and experiences they bring to our organization.

    Commitment to Diversity :

    NDi is an Equal Opportunity Employer. We are committed to creating a diverse environment and are proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran or military status, citizenship, national origin, or any other basis prohibited by law in all phases of the employment process and compliance with applicable federal, state, and local laws and regulations. As a federal government contractor, NDi complies with all applicable affirmative action requirements.

    Apply Now :

    Take advantage of this unique opportunity to join one of the fastest-growing companies in Federal contracting!

    [job_alerts.create_a_job]

    Data Engineer 2 SQL Specialist • McLean, VA, USA

    [internal_linking.similar_jobs]
    Database Engineer

    Database Engineer

    Mantis Security Corporation • Herndon, VA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Mantis Security is a leading specialty firm of high caliber talent who specialize in Cyber Operations, Cyber Defense, Information Assurance, Software Development, DevSecOps, Security Engineering, a...[show_more]
    [last_updated.last_updated_30]
    Data Engineer

    Data Engineer

    Crystal Management | CMIT • Vienna, Virginia, United States
    [job_card.full_time]
    CMiT is seeking an experienced Data Engineer to help lead the analysis, documentation, and migration of a ~2TB Oracle database environment to PostgreSQL. This role involves mapping complex data depe...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Engineer (Databricks)

    Senior Data Engineer (Databricks)

    Infinitive Inc • Ashburn, VA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Candidates must possess work authorization which does not require sponsorship by the employer for a visa.Infinitive is a data and AI consultancy that enables its clients to modernize, monetize and ...[show_more]
    [last_updated.last_updated_30]
    Unstructured Data Engineer

    Unstructured Data Engineer

    Leidos Inc • Reston, Virginia, United States
    [job_card.full_time]
    The Leidos Digital Modernization Sector is seeking an.We are seeking a highly skilled and innovative Unstructured Data Engineer to lead the design, implementation, and operationalization of unstruc...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Cell and Systems Biology Staff Scientist

    Cell and Systems Biology Staff Scientist

    Cape Fox Shared Services • Frederick, MD, United States
    [job_card.full_time]
    Cape Fox subsidiary Eagle Health, LLC is accepting resumes for a.Cell and Systems Biology Staff Scientist.This position is contingent upon contract award. Incumbents are encouraged to apply!.The abo...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Facilities Systems Specialist II (#1896)

    Facilities Systems Specialist II (#1896)

    BNBI • Fort Detrick, Maryland, United States
    [job_card.temporary]
    The National Biodefense Analysis and Countermeasures Center (NBACC) is a unique facility located at Fort Detrick in Frederick, MD, dedicated to defending the nation against biological threats.Estab...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Data Engineer

    Senior Data Engineer

    Momento USA • Mclean, VA, United States
    [job_card.full_time] +1
    [filters_job_card.quick_apply]
    MessageBody"> Position- Senior Data Engineer Location- Mclean, VA Duration- Till end of this year < / p&...[show_more]
    [last_updated.last_updated_variable_days]
    Senior / Principal Software Engineer - AI Data Platform

    Senior / Principal Software Engineer - AI Data Platform

    Adelphi • McLean, VA, United States
    [job_card.full_time]
    A technology company specializing in data infrastructure is seeking a Senior / Principal Software Engineer to develop secure data sharing middleware for national security and intelligence.The role in...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Engineer III : 25-05317 (W2) (Ex Amazon Preferred)

    Data Engineer III : 25-05317 (W2) (Ex Amazon Preferred)

    Akraya Inc • Herndon, Virginia, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Primary Skills : SQL (Expert), Python (Expert), ETL (Expert), AWS (Proficient), Data Modelling (Proficient).Duration : 3+ Months with possible extension. Location : Seattle, WA / Dallas, TX / Austin TX / ...[show_more]
    [last_updated.last_updated_30]
    Cell & Systems Biology Staff Scientist

    Cell & Systems Biology Staff Scientist

    Alaka`ina Foundation Family of Companies • Frederick, MD, United States
    [job_card.full_time]
    Cell & Systems Biology Staff Scientist.Requisition?org=AKIMEKATECH&cws=43&rid=12615).The Alaka`ina Foundation Family of Companies (FOCs) has a potential need for a Cell & Systems Biology Staff Scie...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    SCADA Controls Engineer

    SCADA Controls Engineer

    JSET Automated Technologies • Sterling, VA, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    DOE; paid weekly + standard JSET benefits.About JSET Automated Technologies.JSET Automated Technologies delivers low-voltage, BMS, EPMS, and controls solutions for data centers and other industrial...[show_more]
    [last_updated.last_updated_30]
    Data Entry Product Support - No Experience

    Data Entry Product Support - No Experience

    GLOCPA • Ballenger Creek, Maryland
    [job_card.full_time]
    We’re looking for Customer Support Product Testers across the US to work from home and help top brands improve their products before they hit the market.[show_more]
    [last_updated.last_updated_30] • [promoted]
    Sr. Ab Initio / Data Engineer

    Sr. Ab Initio / Data Engineer

    KMM Technologies, Inc. • Reston, VA, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Ab Initio / Data Engineer Location : Reston, VA #HYBRID Duration : 12+ months #Contract R ate : $70 / hr< / b...[show_more]
    [last_updated.last_updated_variable_days]
    Data Engineer

    Data Engineer

    ThinkTek • Fairfax, VA, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    ThinkTek LLC is a fast-growing Certified SBA 8(a) and Service-Disabled Veteran-Owned Small Business (SDVOSB).We specialize in providing management and technology consulting services to support the ...[show_more]
    [last_updated.last_updated_variable_hours] • [new]
    Senior Backend Engineer — Cloud & Data Solutions

    Senior Backend Engineer — Cloud & Data Solutions

    Information Technology Senior Management Forum • McLean, VA, United States
    [job_card.full_time]
    A financial services company seeks a Senior Software Engineer in McLean, VA.The role involves collaborating across Agile teams, designing and implementing cloud-based solutions, and requires expert...[show_more]
    [last_updated.last_updated_30] • [promoted]
    WGL - Sr. Sales Engineer

    WGL - Sr. Sales Engineer

    AltaGas • Springfield, VA, United States
    [job_card.full_time]
    Interpret and apply jurisdictional codes and regulations to assess their impact on natural gas infrastructure and project feasibility. Collaborate with builders, developers, and engineering teams to...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Data Engineer 2 - Applicants must be US Citizens with TS - FSP to apply

    Data Engineer 2 - Applicants must be US Citizens with TS - FSP to apply

    Bow Wave LLC • Reston, VA, USA
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Design and optimize Data Pipelines using Spark, Hudi, EMR cloud services, and Kubernetes containers.Make sure pedigree and provenance of the data is maintained such that the access to data is prote...[show_more]
    [last_updated.last_updated_30]
    Lead Data Engineer (Enterprise Platforms Technology)

    Lead Data Engineer (Enterprise Platforms Technology)

    Capital One • McLean, VA, United States
    [job_card.part_time]
    Data Engineers who are passionate about marrying data with emerging technologies.As a Capital One Lead Data Engineer, you’ll have the opportunity to be on the forefront of driving a major transform...[show_more]
    [last_updated.last_updated_30] • [promoted]