Programmer Analyst - Data Developer

Zenfreed•Lansing, MI

1d•Hybrid

About The Position

This senior-level Application Data Developer role supports enterprise applications in an Oracle database environment. As a core member of a technology team supporting agency applications and data services, the developer designs, develops, and maintains database structures, PL/SQL code, and data integrations that enable secure, efficient, and accurate data flow across assigned systems. The role contributes to project and maintenance activities and provides technical leadership for data modeling, ETL development, and integration of agency-specific data into vendor-hosted solutions. The developer collaborates with Data Architects, Database Administrators, application support staff, and vendors to create, test, deploy, and optimize data structures and processes. A high degree of technical proficiency, problem-solving ability, and independent judgment is expected. The position may report to a project lead, project manager, or manager. This is a 40-hour-per-week W2 position with a hybrid schedule. Employees must be onsite two days per week starting on day one; Tuesdays and Wednesdays are required onsite days. The stated hours are Monday through Friday, approximately 8:00 a.m. to 5:00 p.m. There is no remote-only option. Local candidates are strongly preferred; non-local candidates must be willing to relocate at their own expense after acceptance without delay and follow the hybrid schedule. Candidates must be authorized to work in the United States; sponsorship is not offered. Employment requires a background check and drug screening.

Requirements

8 or more years of Oracle PL/SQL development experience, including packages, procedures, and functions.
Experience using Oracle development tools such as Toad or SQL Developer.
Experience designing, creating, and maintaining Oracle database objects.
Experience with logical and physical data modeling and database normalization.
Experience in data analysis, data quality, and metadata management.
Experience developing and integrating web services using SOAP and/or REST.
Experience with database programming for data migration and conversion.
Experience supporting or integrating vendor-hosted or COTS systems.
Bachelor's degree.
Must be authorized to work in the United States; sponsorship is unavailable.
Must undergo a background check and drug screening.
Must be onsite Tuesdays and Wednesdays and follow the hybrid schedule; non-local candidates must be willing to relocate at their own expense after acceptance without delay.

Nice To Haves

Local candidates are strongly preferred.

Responsibilities

Design, develop, and maintain database objects, including tables, views, indexes, triggers, and constraints, to support application and integration requirements.
Develop and optimize PL/SQL packages, procedures, and functions for business logic, data services, and ETL processes.
Support data design and modeling, including logical and physical data models and normalization.
Lead and execute data migration and conversion tasks for new implementations, upgrades, and system integrations.
Develop and consume SOAP and REST web services for data integrations between internal systems and vendor-hosted COTS solutions.
Analyze data and metadata to ensure accuracy, integrity, and compliance with agency standards.
Work 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 new projects and ongoing maintenance.