Find JobsSalary EstimateCareer AdviceUpload ResumeEmployers / Post JobProfileMessage Center

Data Engineer II

EDI Specialists, Inc.

Richmond, VA

Apply
JOB DETAILS
JOB TYPE
Full-time, Employee
SKILLS
Agile Programming Methodologies, Airport Security, Analysis Skills, Artificial Intelligence (AI), Atlassian JIRA, Automation, Best Practices, Business Solutions, Cloud Computing, Code Reviews, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Data Modeling, Data Quality, Data Recovery, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Technology, Debugging Skills, Design Flows, Detail Oriented, DevOps, Documentation, Git, Identify Issues, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), On Call, Operational Audit, Operational Support, Operations Processes, Performance Management, Performance Tuning/Optimization, Problem Solving Skills, Programming Tools, Project/Program Management, Quality Management, Query Analysis, Query Optimization, Refactoring, Relational Databases (RDBMS), SQL (Structured Query Language), SQL Databases, Software Engineering, Source Code Control System (SCCS), Stored Procedures, Strategic Planning, System Integration (SI), Systems Administration/Management, Team Player, Technical Leadership, Technical/Engineering Design, Testing
LOCATION
Richmond, VA
POSTED
19 days ago
Hybrid near Richmond, VA

Overview
The Data Engineer II, Database Engineering role is a mid-level data engineering position responsible for designing, developing, and supporting robust, scalable database solutions that power business applications, analytics, and data integrations. This role requires advanced SQL development expertise, a strong understanding of relational data modeling, and the ability to independently deliver complex database solutions. While this role does not own enterprise database administration or platform strategy, it plays a key role in implementing best practices and improving database development standards.

Database Design & Development
  • Design and implement complex relational database solutions to support operational and analytical workloads.
  • Translate business and technical requirements into well-structured database designs and data models.
  • Develop advanced database objects, including stored procedures, functions, views, and optimized schemas.
  • Review and improve existing database designs for performance, scalability, and maintainability.
  • Contribute to database design discussions and technical solution reviews.

SQL Development & Performance Optimization
  • Write, optimize, and maintain complex SQL queries and database objects handling large data volumes.
  • Investigation and resolution of query-level and workload performance issues.
  • Apply indexing strategies, execution plan analysis, and query refactoring techniques.
  • Review SQL code written by other engineers and provide actionable feedback to improve quality, performance, and maintainability.
  • Guide other engineers through query optimization techniques, debugging approaches, and SQL best practices.
  • Serve as a point of escalation for complex SQL development questions.
  • Help establish and reinforce SQL development standards through example and peer review.

Data Integration & ETL
  • Design and implement reliable ETL and data integration workflows.
  • Ensure data quality, consistency, and accuracy across integrated systems.
  • Partner with stakeholders to refine data requirements and improve data accessibility.
  • Provide technical guidance on data integration patterns and approaches.

Internal Tools & Automation
  • Build and maintain lightweight internal tools or utilities, including the use of approved low-code or no-code platforms, to support database and data operations.
  • Assist in automating repeatable data-related tasks and workflows.

AI-Assisted Development
  • Utilize AI-assisted development tools (e.g., code generation, query optimization, documentation assistance) to improve development efficiency and code quality.
  • Apply judgment to validate, test, and refine AI-generated outputs in accordance with engineering standards.
  • Share effective AI-assisted development techniques informally with team members.

Documentation & Collaboration
  • Create and maintain clear documentation for database designs, data flows, and operational processes.
  • Collaborate with other data engineers, software engineers, integrations engineers, and business partners.
  • Communicate technical concepts effectively to both technical and non-technical audiences.

Monitoring & Support
  • Monitor scheduled database jobs and data processes for failures or anomalies.
  • Respond to support requests using Jira Service Management and Jira Cloud.
  • Assist with troubleshooting data-related issues and propose improvements to prevent recurring problems.
  • Participate in an on-call rotation for after-hours, weekend, and holiday support.
  • Make suggestions for changes that proactively prevent future support issues.
  • Communicate effectively with stakeholders and project managers to clarify requirements on support requests.
  • Comply with company C-TPAT and TSA security procedures.
  • Perform other duties and functions as assigned.

SKILLS & ABILITIES
  • 5+ years of experience in SQL development and database administration.
  • Advanced proficiency in SQL, including complex query design, performance tuning, and troubleshooting.
  • Strong hands-on experience with Microsoft SQL Server.
  • Deep understanding of relational data modeling and database design principles.
  • Experience designing and maintaining ETL or data integration workflows.
  • Experience performing peer code reviews and providing technical guidance.
  • Proficiency with source control systems (e.g., Git).
  • Demonstrated ability to use AI-assisted development tools responsibly.
  • Strong analytical, problem-solving, and communication skills.
  • Experience with relational database management operations for Microsoft SQL Server.
  • Experience with SQL Server upgrades preferred.
  • Knowledge of data modeling techniques and database design principles.
  • Familiarity with database administration tasks such as backup, recovery, and security.
  • Excellent problem-solving skills and attention to detail.
  • Strong communication and collaboration skills to work effectively in a team environment.
  • Experience working in Agile or DevOps-oriented environments.
  • Familiarity with CI/CD concepts for database deployments.

* To perform this job successfully, an individual must satisfactorily perform each essential duty. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential duties.

About the Company

E

EDI Specialists, Inc.

At EDI Staffing, we strive to provide the best staffing solutions for each of our business disciplines, in honest, resourceful, and creative techniques. Our mission is to connect talented people with great organizations across all industries, while maintaining our company values: accountability, innovation, integrity, teamwork and work ethic. Our commitment to our values becomes tangible in our daily customer interactions and lifetime customer relationships.

COMPANY SIZE
100 to 499 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1994
WEBSITE
https://www.edistaffing.com/