Estes Forwarding Worldwide · 15 hours ago
Data Engineer II, Database Engineering
Richmond, VA, US
Full-time
Onsite
Mid, Senior Level
5+ years expEstes Forwarding Worldwide (EFW) is a leading domestic and international freight forwarder in the United States, providing customized logistics and warehousing solutions. The Data Engineer II, Database Engineering role is responsible for designing, developing, and supporting robust database solutions that power business applications and analytics, requiring advanced SQL development expertise and strong relational data modeling skills.
AutomotiveLogistics
No H1B
Responsibilities
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
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
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
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
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
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
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
Qualification
Required
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
Must be eligible to work in the United States
At this time, EFW will not sponsor a new applicant for employment authorization for this position
Candidates who receive a job offer will be required to successfully pass a drug screen and a background check
Minimum of a Bachelor's degree (or equivalent) in Computer Science, Information Technology, or related field or 4-6 years of experience
Preferred
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
Experience working in Agile or DevOps-oriented environments
Familiarity with CI/CD concepts for database deployments
Benefits
Paid vacation, sick time, and holidays
401(k) plan with company match
Medical, dental, and vision insurance
Short- and long-term disability plans
Life and accidental death & dismemberment insurance
Job referral bonus program
Company
Estes Forwarding Worldwide
Estes Forwarding Worldwide is a logistics company specializing in domestic delivery services.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Scott Fisher
Chief Executive Officer
Recent News
2024-04-24
Company data provided by crunchbase