Data Engineer 2 / SQL Specialist

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!