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

Data Engineer 2 / SQL Specialist

Network Designs Inc. • McLean, VA, US
8 days ago
Job type
  • Full-time
Job description

Job Description

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!

    Create a job alert for this search

    Data Engineer 2 SQL Specialist • McLean, VA, US

    Similar jobs
    Data Engineer

    Data Engineer

    Crystal Management | CMIT • Vienna, VA, United States
    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: 30+ days ago • Promoted
    Lead Data Engineer

    Lead Data Engineer

    nTech Workforce • Reston, VA, United States
    Full-time
    W2 Contract-to-Hire, 12 months.This is a hybrid schedule at Reston, VA, Candidates must reside in Maryland, Washington, DC, or Virginia. The Lead Data Engineer is responsible for designing, building...Show more
    Last updated: 14 hours ago • Promoted • New!
    Databricks Data Engineer

    Databricks Data Engineer

    Equiliem • 20697, MD, US
    Full-time
    Job Title : Databricks Data Engineer.Our client is seeking a Databricks Data Engineer to design, develop, and maintain scalable data pipelines and analytics solutions within an Azure cloud-based dat...Show more
    Last updated: 3 days ago • Promoted
    Lead Data Engineer — Enterprise Platforms

    Lead Data Engineer — Enterprise Platforms

    Capital One Financial Corporation • McLean, VA, United States
    Full-time
    A leading financial services company in McLean, VA is seeking a Lead Data Engineer to drive technology solutions.The ideal candidate will have at least 4 years of experience in application developm...Show more
    Last updated: 13 days ago • Promoted
    Lead Data Engineer (AWS, Azure, GCP)

    Lead Data Engineer (AWS, Azure, GCP)

    CapTech Consulting • Reston, VA, US
    Full-time
    CapTech is an award-winning consulting firm that collaborates with clients to achieve what’s possible through the power of technology. At CapTech, we’re passionate about the work we do a...Show more
    Last updated: 12 days ago • Promoted
    Data Engineer

    Data Engineer

    Viasat • Germantown, MD, United States
    Full-time
    At Viasat, we're on a mission to deliver connections with the capacity to change the world.For more than 35 years, Viasat has helped shape how consumers, businesses, governments and militaries arou...Show more
    Last updated: 5 days ago • Promoted
    Data Engineer - Viasat Government

    Data Engineer - Viasat Government

    Viasat • Germantown, MD, United States
    Full-time
    At Viasat, we're on a mission to deliver connections with the capacity to change the world.For more than 35 years, Viasat has helped shape how consumers, businesses, governments and militaries arou...Show more
    Last updated: 18 days ago • Promoted
    Data Engineer (AWS, Azure, GCP)

    Data Engineer (AWS, Azure, GCP)

    CapTech Consulting • Reston, VA, US
    Full-time
    CapTech is an award-winning consulting firm that collaborates with clients to achieve what’s possible through the power of technology. At CapTech, we’re passionate about the work we do a...Show more
    Last updated: 12 days ago • Promoted
    Senior Data Engineer (Databricks)

    Senior Data Engineer (Databricks)

    Infinitive Inc • Ashburn, VA, US
    Full-time
    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: 30+ days ago
    Senior Data Engineer

    Senior Data Engineer

    ATPCO • Herndon, VA, US
    Full-time
    ATPCO is the world's primary source for air fare content, holding over 200 million fares across 160 countries.Every day, the travel industry relies on ATPCO's technology and data solutions ...Show more
    Last updated: 12 days ago • Promoted
    Cleared Data Focused Software Engineer - TS / SCI w / Poly required

    Cleared Data Focused Software Engineer - TS / SCI w / Poly required

    Leading Path Consulting • Chantilly, Virginia, United States
    Full-time
    This role is part of a mission critical directorate where you will have significant impact on Mission (pointy end of spear). Due to the priority of this funded and sole-sourced opportunity, we are o...Show more
    Last updated: 30+ days ago • Promoted
    Senior Data Engineer

    Senior Data Engineer

    Tiger Analytics Inc. • McLean, VA, US
    Full-time
    Tiger Analytics is a global leader in AI and advanced analytics consulting, empowering Fortune 1000 companies to solve their toughest business challenges. We are on a mission to push the boundaries ...Show more
    Last updated: 19 days ago • Promoted
    Data Engineer

    Data Engineer

    Dark Wolf Solutions • Herndon, VA, US
    Full-time
    This position will have hybrid / remote flexibility.The Data Engineer will be responsible for designing, building, and optimizing robust data pipelines and data infrastructure to ensure the reliabili...Show more
    Last updated: 14 days ago • Promoted
    Data Architect and Solutions Engineer

    Data Architect and Solutions Engineer

    The Aerospace Corporation • Chantilly, VA, United States
    Full-time
    The Aerospace Corporation is the trusted partner to the nation's space programs, solving the hardest problems and providing unmatched technical expertise. As the operator of a federally funded resea...Show more
    Last updated: 9 hours ago • Promoted • New!
    Senior Data Engineer (Python, SQL, AWS)

    Senior Data Engineer (Python, SQL, AWS)

    Capital One • McLean, VA, US
    Full-time +1
    Senior Data Engineer (Python, SQL, AWS).Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative,.At Capital One, y...Show more
    Last updated: 20 hours ago • Promoted • New!
    Lead Data Engineer (Enterprise Platforms Technology)

    Lead Data Engineer (Enterprise Platforms Technology)

    Capital One Financial Corporation • McLean, VA, United States
    Full-time +1
    Lead Data Engineer (Enterprise Platforms Technology).Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, incl...Show more
    Last updated: 13 days ago • Promoted
    Lead Data Engineer (Enterprise Platform Technology)

    Lead Data Engineer (Enterprise Platform Technology)

    Capital One National Association • McLean, VA, United States
    Full-time +1
    Lead Data Engineer (Enterprise Platform Technology).Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclu...Show more
    Last updated: 30+ days ago • 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
    Full-time
    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: 30+ days ago