ETL/SQL Developer
Role details
Job location
Tech stack
Job description
As an ETL/SQL Developer, you will play a key role in supporting data integration, transformation, and migration efforts across various projects. You'll be responsible for designing, developing, and optimizing stored procedures, packages, and scripts using PL/SQL (preferred) or Microsoft SQL Server (T-SQL). This role requires strong hands-on experience in relational database development, excellent problem-solving skills, and the ability to collaborate across cross-functional teams. You will work closely with application developers, data analysts, and project managers to ensure that data processes are efficient, scalable, and meet business requirements. The role will require 3 days a week on site in our Desert Ridge location., + Design, develop, and optimize stored procedures, triggers, functions, and views using PL/SQL (preferred) or T-SQL.
- Build and maintain complex queries and scripts to support data migration, reporting, and integration tasks.
- Participate in code reviews, performance tuning, and troubleshooting.
- Collaborate with analysts and data engineers to understand requirements and implement reliable data solutions.
- Document database designs, coding standards, and technical specifications.
- Perform unit testing and support QA with test case creation and defect resolution.
- Analyze legacy system data structures and participate in data mapping and conversion efforts.
- Monitor and maintain database jobs, schedules, and overall performance.
Requirements
- Bachelor's degree in computer science, Information Technology, or a related field., + 4+ years of experience in SQL development, with strong proficiency in Oracle PL/SQL (preferred) or Microsoft SQL Server T-SQL.
- Experience with data migration, ETL processes, and database performance tuning.
- Familiarity with source control tools and DevOps processes is a plus.
- Ability to read and understand existing codebases and refactor or optimize as needed.
- Strong analytical and debugging skills.
- Excellent communication and teamwork abilities.
- Experience working in Criminal Justice or Public Safety domains is a plus.
Preferred Skills
- Experience with source control tools and DevOps processes.
- Experience working in Criminal Justice or Public Safety domains.