Programmer Analyst - Data Developer

First Roles; Dimondale (MI); Hybrid; USD 90,000 - 120,000; Full time

Job summary

First Roles is seeking a Programmer Analyst - Data Developer to join our Lansing area team in a hybrid role. The position emphasizes Oracle PL/SQL development, database design, and data integration across enterprise systems.

The ideal candidate will drive data migration, governance, and quality initiatives, collaborate with DBAs and data architects, and deliver robust data services and integrations using SOAP/REST in a fast-paced environment.

Qualifications

• 8+ years of advanced development experience with Oracle PL/SQL (packages, procedures, functions).
• Proficiency using Oracle development environments such as Toad or SQL Developer.
• Experience designing, creating, and maintaining Oracle database objects, logical/physical data modeling, and normalization.

Responsibilities

• Design, develop, and maintain database objects (tables, views, indexes, triggers, constraints).
• Develop and optimize PL/SQL packages, procedures, and functions powering business logic and ETL processes.
• Support data design and modeling activities, including logical/physical modeling and normalization.

Skills

Oracle PL/SQL

Database design

Data management

Web services

Data migration

COTS integration

Tools

Toad

SQL Developer

Job description

Programmer Analyst - Data Developer

Lansing,Mi Hybrid

Top Required Skills & Experience

• Oracle PL/SQL: 8+ years of advanced development experience (packages, procedures, functions).
• Development Tools: 8+ years of proficiency using Oracle development environments such as Toad or SQL Developer.
• Database Design: 8+ years of experience designing, creating, and maintaining Oracle database objects, logical/physical data modeling, and database normalization.
• Data Management: 8+ years of expertise in data analysis, data quality assurance, and metadata management.
• Integrations & Web Services: 8+ years of experience developing and consuming SOAP and/or REST web services for enterprise system integration.
• Data Migration: 8+ years of database programming experience supporting data migration and data conversion initiatives.
• COTS Integration: Demonstrated experience supporting or integrating vendor-hosted or Commercial Off-The-Shelf (COTS) software solutions.

Key Responsibilities

Database Design & PL/SQL Development

• Design, develop, and maintain database objects (tables, views, indexes, triggers, and constraints) to support core application and integration requirements.
• Develop, optimize, and maintain complex PL/SQL packages, procedures, and functions to power business logic, data services, and ETL processes.
• Support enterprise data design and modeling activities, including logical and physical data modeling and strict database normalization.

Integration, COTS & Data Migration

• Lead and execute data migration and data conversion tasks for new software implementations, platform upgrades, and enterprise system integrations.
• Develop and consume enterprise web services (SOAP/REST) to facilitate secure data integrations between internal systems and vendor-hosted COTS solutions.
• Integrate internal data services seamlessly into third-party vendor platforms while ensuring data integrity.

Data Governance, Performance & Support

• Analyze data and metadata to ensure accuracy, high integrity, and strict compliance with organizational data standards.
• Partner closely with Data Architects and DBAs on SQL performance tuning, database code reviews, and adherence to database engineering best practices.
• Troubleshoot complex data issues, identify root causes, and implement rapid corrective solutions.
• Participate actively in planning, estimation, documentation, and technical design sessions for both new projects and ongoing maintenance efforts.

Core Competencies & Qualifications

• Strong problem-solving abilities and the capability to exercise independent judgment in a fast-paced environment.
• Clear and concise written and verbal communication skills, with the ability to articulate technical concepts effectively to stakeholders at all levels.
• Proven track record of collaborating successfully across cross-functional technology teams.