EDI Staffing, an EDI Specialists Company · 14 hours ago
Data Engineer II
EDI Staffing is an EDI Specialists Company, and they are seeking a Data Engineer II to design, develop, and support scalable database solutions. This role involves advanced SQL development, relational data modeling, and implementing best practices for database development standards.
ConsultingHuman ResourcesInformation TechnologyStaffing Agency
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
Excellent problem-solving skills and attention to detail
Strong communication and collaboration skills to work effectively in a team environment
Preferred
Experience with SQL Server upgrades
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