Job Title: Programmer Analyst 6 – Data Developer (Oracle / COTS Solutions)
Location: Lansing, Michigan
Work Arrangement: Hybrid – 2 days onsite per week
Experience Required: 8+ years
Contract Duration: 1 year, with extension likely
Interview Process: In-person interview; up to 2 rounds

Job Summary

We are seeking an experienced Data Developer with strong Oracle PL/SQL expertise to support enterprise applications and data services. The ideal candidate will have extensive experience in Oracle database development, data modeling, data migration, data quality, and system integration.

The candidate will work closely with Data Architects, Database Administrators, application support teams, and vendors to design, develop, maintain, and optimize database solutions and integrations with commercial off-the-shelf (COTS) applications.

Key Responsibilities

• Design, develop, and maintain Oracle database objects, including tables, views, indexes, triggers, and constraints.

• Develop, maintain, and optimize PL/SQL packages, procedures, and functions.

• Support logical and physical data modeling, database normalization, and data design activities.

• Lead and execute data migration and data conversion activities for new implementations, system upgrades, and integrations.

• Develop and integrate SOAP and REST web services for data exchange between internal systems and vendor-hosted applications.

• Analyze data and metadata to ensure accuracy, integrity, quality, and compliance with organizational standards.

• Collaborate with Data Architects and DBAs on performance tuning, code reviews, and database best practices.

• Troubleshoot database and integration issues, identify root causes, and implement corrective solutions.

• Participate in technical design sessions, project planning, effort estimation, documentation, and application maintenance.

Required Skills and Qualifications

• 8+ years of experience in Oracle PL/SQL development, including packages, procedures, and functions.

• 8+ years of experience using Oracle development tools such as Toad or Oracle SQL Developer.

• 8+ years of experience designing, creating, and maintaining Oracle database objects.

• 8+ years of experience with logical and physical data modeling and database normalization.

• 8+ years of experience in data analysis, data quality, and metadata management.

• 8+ years of experience developing and integrating SOAP and/or REST web services.

• 8+ years of experience with database programming for data migration and data conversion.

• Experience supporting or integrating vendor-hosted applications and COTS solutions.

• Strong analytical, problem-solving, and troubleshooting skills.

• Excellent written and verbal communication skills.

• Ability to work independently and collaborate effectively with cross-functional teams.

Work Location and Schedule

• Hybrid work arrangement requiring onsite presence in Lansing, Michigan, two days per week.

• Tuesdays and Wednesdays are mandatory onsite days.

• Remote-only arrangements are not available.

• Local candidates are strongly preferred.

• Non-local candidates must be willing to relocate at their own expense upon acceptance, without delaying the start, and comply with the required hybrid schedule.

• Candidates must be available for an in-person interview.

Ideal Candidate

The ideal candidate is a senior Oracle PL/SQL developer with strong database design, data modeling, data migration, and web services integration experience. Experience supporting enterprise applications and vendor-hosted COTS solutions is highly desirable.

Interested candidates who meet the required qualifications and on-site work expectations are encouraged to apply.