Programmer Analyst - Data Developer

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.