Data Warehouse Developer (Ref: 18042)

  • Professional Technology Integration, Inc.
  • Augusta, Maine
  • 01/15/2026
Information Technology Telecommunications SQL Oracle Testing

Job Description

Position: Data Warehouse Developer (Ref: 18042)
Location: Augusta, ME USA, 04333
Salary: DOE
Duration: 5 Months 14 Days - Contract
Openings: 1
Deadline: 01/20/2026

Description:
Remote 100%
Eastern and Central Time Zones

We are seeking a Datawarehouse Developer who will assist in meeting the timeline of the existing analytics projects, while supporting users with the current production environments. Resource will provide continued support after projects go-live.

Roles and Responsibilities:
Prepares detailed design specifications for highly complex and large-scale systems to plan and facilitate system development and programming.
Maintains assigned systems, responding to and resolving system problems to ensure systems are continuously available and function properly.
Develop systems employing higher level languages such as 3 GL's, 4 GL's, enterprise class application development tools, system utilities, and project management tools to prepare systems for implementation.
Diagnoses and isolates complex application software problems; formulates and implements effective solutions considering system capacity, limitations, time requirements, and desired results to resolve system problems and prevent reoccurrence.
Design and develop subroutines in support of system development efforts to achieve maximum productivity.
Perform difficult, complex, and specialized programming assignments to ensure users and business needs are met.
The ability to switch between multiple priorities while maintaining momentum on current work.
Customer focused approach when working with other teams and business contacts.
Familiar with a shared team development environment, including the ability to perform tasks for all aspects of the SDLC.
Ability to complete work in an Oracle Cloud environment (Oracle Cloud Infrastructure - OCI).
Knowledge and application of Data Warehouse design and development principles.
Understanding Kimball method and how it is applied.
Data Warehouse Structure and Application / Star Schema experience.
Software testing experience.
Data/Business analysis skills needed to gather business requirements and create technical documents.

Required / Desired Skills
Data Warehouse Structure and Application- Star Schema Required - 3 Years
Kimball Method Required - 1 Years
Oracle Cloud Infrastructure (OCI) Required - 3 Years
SQL Required - 3 Years
PL/SQL Required - 3 Years
Review & Convert Coding Required - 3 Years
Experience gathering business requirements Required - 3 Years
Experience creating technical documentation Required - 3 Years