Network Designs, Inc. ยท 7 hours ago
Data Engineer 2 / SQL Specialist
McLean, VA
Full-time
Hybrid
Mid Level
$96K/yr - $113K/yr
3+ years expNetwork Designs, Inc. (NDi) is a leading Federal contractor that specializes in designing, developing, and delivering information technology and network solutions for government customers. 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 data into the modernized Enrollment System.
Information ServicesInformation Technology
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
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
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
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
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
Maintain and enhance database schemas, metadata definitions, and data dictionaries
Support versioned schema changes and metadata traceability throughout migration cycles
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
Ensure data handling and migration activities comply with applicable data governance, security, and audit requirements
Support implementation of data quality profiling and monitoring 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
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
Qualification
Required
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
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
Benefits
Comprehensive health, dental, vision, pet, and legal insurance
401(k) retirement matching
Paid leave
Paid holidays
Health and wellness programs
Employer-paid life and disability insurance
Professional development
Education benefits
Company
Network Designs, Inc.
NDi is a Verified Service-Disabled Veteran Owned Small Business [SDVOSB] professional services firm, supporting Federal and Commercial customers since 1995.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Anthony Zeruto, CISM
CEO and Owner
Company data provided by crunchbase