Data Engineer II

Job Title: Data Engineer 2

Location: Remote

Citizenship: Must be a US Citizen or Permanent Resident 

Security Clearance: USDA Public Trust

The Data Engineer 2 is responsible for the design, development, optimization, and administration of database solutions and data pipelines supporting the USDA IT ecosystem. This role requires deep expertise in SQL Server database engineering, data modeling, ETL/ELT development, business intelligence reporting, and database administration across a complex portfolio of interdependent FPAC applications. The Data Engineer 2 provides Tier 3 technical support for data-related production issues, drives database performance optimization, supports cloud migration of data services to AWS, and contributes to the modernization of legacy monolithic database architectures. The role operates with significant autonomy across multiple application domains and serves as a subject matter expert on data structures, schemas, and cross-system data dependencies.

Required Qualifications:

Experience:

• Ten (10) or more years of professional experience in database engineering, data architecture, or database administration with SQL Server.
• Five (5) or more years of experience with ETL/ELT development using SSIS, SQL Agent, or equivalent tools.
• Five (5) or more years of experience with business intelligence development including SSRS, SSAS, or Power BI.
• Three (3) or more years of experience with logical and physical data modeling using PowerDesigner, Erwin, or equivalent tools.
• Three (3) or more years of experience supporting federal IT programs or government agency environments.
• Experience with database performance tuning, query optimization, replication, and capacity management.
• Experience with CI/CD pipelines and automated deployment of database changes.

Education:

• Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent professional experience.

• Master’s degree in Computer Science or a related field is preferred.

Security Requirements:

• Must be a US Citizen or Permanent Resident eligible obtain and maintain an USDA security background investigation
• Must comply with all NIST, USDA, and HSPD–12 security training and reporting requirements.
• Must complete mandatory training: Information Security Awareness (annually) and Section 508 (within 45 days of assignment).

Technical Skills:

• SQL Server (2016+): stored procedures, views, functions, triggers, query optimization, replication, backup/restore
• SSIS (SQL Server Integration Services), SQL Agent jobs, ETL/ELT pipeline development
• SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), Power BI
• Data modeling: PowerDesigner, Erwin Data Modeler, star/snowflake schema design
• Database versioning: Liquibase
• AWS services: RDS, S3, and related data services
• Source control: Git, TFS/Azure DevOps
• Security scanning: SonarQube, Fortify SCA
• Agile/SAFe methodologies; Jira, Confluence

Preferred Qualifications:

• Experience with USDA NRCS or FPAC systems and databases (e.g., CD, CART, Registry, Easements, NPAD, Protracts, NOIS, GDAC).
• Experience with Databricks or AWS Data Lake architectures.
• Experience with Tableau or MicroStrategy in addition to Power BI/SSRS.
• AWS certifications (Cloud Practitioner, Database Specialty, or equivalent).
• Experience with Oracle, PostgreSQL, or other RDBMS platforms in addition to SQL Server.
• Experience with Redgate or equivalent database DevOps tooling.