Programmer Analyst - Data Developer

Job Duties

• Design, develop, and maintain database objects (tables, views, indexes, triggers, constraints) to support application and integration requirements.
  
• Develop and optimize PL/SQL packages, procedures, and functions to support business logic, data services, and ETL processes.
  
• Support data design and modeling activities, including logical and physical data models and normalization.
  
• Lead and execute data migration and data conversion tasks for new implementations, upgrades, and system integrations.
  
• Develop and consume web services (SOAP/REST) used in data integrations between internal systems and vendor-hosted COTS solutions.
  
• Analyze data and metadata to ensure accuracy, integrity, and compliance with agency standards.
  
• Work closely with Data Architects and DBAs on performance tuning, code reviews, and database best practices.
  
• Troubleshoot data issues, identify root causes, and implement corrective solutions.
  
• Participate in planning, estimation, documentation, and technical design sessions for both new projects and ongoing maintenance efforts.
  

Requirements

• Oracle PL/SQL development (packages, procedures, functions) 
  
• Use of Oracle development tools such as Toad or SQL Developer 
  
• Designing, creating, and maintaining Oracle database objects
  
• Logical and physical data modeling; database normalization 
  
• Data analysis, data quality, and metadata management
  
• Developing and integrating web services (SOAP and/or REST) 
  
• Database programming for data migration and data conversion 
  

Minimum Education

• Bachelor's Degree
  

Location

• Local candidates vs non-local: Local candidates (strongly preferred) or non-local (must be willing to relocate at their own expense from acceptance with no delays & follow the hybrid schedule)
  
• Position
  is a hybrid schedule working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. Tuesdays and Wednesdays are required onsite days.
  
• Working hours
  Monday-Friday, approximately 8:00 a.m. to
  5:00 p.m. 
  

Additional
Requirements

• Must be authorized to
  work in the United States; We are unable to offer
  sponsorships at this time
  
• Must undergo a background check
  and drug screening for employment.
  

Employment
Terms

• This is a W2 position
  
• 40 hrs per week
  
• HYBRID schedule - will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. Tuesdays and Wednesdays are required onsite days.
  

Benefits