Remote Data Warehouse & PL/SQL Engineer

State of Maine; Augusta (ME); Remote; USD 80,000 - 110,000; Full time

Job summary

A state government agency is seeking a Data Warehouse / PL/SQL Programmer to support their ongoing projects. This remote role requires expertise in PL/SQL, Data Warehouse design, and strong business analysis skills. Candidates should have experience with the Kimball methodology and Oracle Cloud Infrastructure. The position involves detailed system design, problem resolution, and collaboration with other teams to ensure functionality and user satisfaction.

Qualifications

• Experience gathering business requirements.
• Experience creating technical documentation.
• Familiarity with Data Warehouse design and development principles.
• Knowledge of Kimball methodology.
• Experience with Star Schema data modeling.
• Familiarity with PL/SQL.

Responsibilities

• Prepare detailed design specifications for systems development.
• Maintain assigned systems, resolving problems to ensure functionality.
• Develop systems using higher-level programming languages for implementation.
• Diagnose and isolate complex software problems, implementing effective solutions.
• Design and develop subroutines for system development efficiency.
• Perform complex programming assignments to meet user needs.
• Adapt to multiple priorities maintaining work momentum.
• Maintain a customer-focused approach in team interactions.

Skills

PL/SQL

Data Warehouse

Business Requirements Gathering

Technical Documentation Creation

Data/Business Analysis

Tools

Oracle Cloud Infrastructure (OCI)

Job description

A state government agency is seeking a Data Warehouse / PL/SQL Programmer to support their ongoing projects. This remote role requires expertise in PL/SQL, Data Warehouse design, and strong business analysis skills. Candidates should have experience with the Kimball methodology and Oracle Cloud Infrastructure. The position involves detailed system design, problem resolution, and collaboration with other teams to ensure functionality and user satisfaction.