Remote Data Warehouse Programmer Analyst (Oracle/ETL)

State of Maine; United States; Remote; USD 60,000 - 85,000; Full time

Benefits offered by this job

Health Insurance Coverage

Paid holidays

Parental leave

Job summary

Office of Information Technology in Augusta, ME seeks a Programmer Analyst to design, develop, and maintain data warehouse and application programs. Responsibilities include Oracle SQL/PL, ETL processes, and AOPEX apps; work spans requirements through deployment with minimal supervision.

The role emphasizes translating business needs into technical solutions, documenting procedures, and collaborating with users and teams. Telework is available and competitive state benefits apply.

Qualifications

• Knowledge of SQL, structured programming, and database or data warehouse development.
• Ability to analyze data, programs, and business processes and translate findings into effective technical solutions.
• Familiarity with the application-development lifecycle, including requirements, design, development, testing, deployment, documentation, and maintenance.
• Familiarity with application testing, data validation, debugging, and production-support practices.
• Ability to investigate technical problems and develop practical, supportable solutions.
• Ability to prepare clear system, program, operational, and user documentation.
• Ability to communicate technical information effectively to technical and nontechnical audiences.

Responsibilities

• Develop, enhance, test, debug, and maintain data warehouse programs, database code, and data-integration processes.
• Write and maintain Oracle SQL and PL/SQL, including packages, procedures, functions, queries, and scripts.
• Support and enhance Oracle APEX applications.
• Develop and maintain ETL processes that load staging, warehouse, and reporting structures.
• Maintain data warehouse solutions using the team’s established architecture, standards, and development practices.
• Support data-loading processes that use shell scripts, Oracle SQL*Loader, and related utilities.
• Analyze existing applications and code, recommend improvements, and help migrate functionality to supported technologies.
• Investigate production incidents, identify root causes, correct defects, and communicate status clearly to customers and team members.
• Monitor and validate data loads, reconcile results, and address data-quality issues.
• Translate business needs into clear technical requirements and workable solutions.
• Develop and perform appropriate unit, integration, system, and data-validation testing.
• Create and maintain system, program, operational, and user documentation.
• Participate in reviews of system designs, code, test plans, and deployment activities.
• Assist users in understanding application features, warehouse data, and reporting capabilities.
• Manage assigned work independently while coordinating with the team and raising risks or blockers promptly.
• Participate in relevant agency, vendor, and technical training to expand professional and technical knowledge.

Skills

SQL

Structured programming

Data warehouse development

Data analysis

Communication skills

Documentation writing

Team collaboration

Problem solving

Education

Bachelor's Degree in Computer Science

Associates Degree in Computer Information Science

Tools

Oracle SQL

Oracle APEX

Oracle SQL Developer

Oracle Cloud Infrastructure

Shell scripting

SQL*Loader

ETL tools

Job description

Office of Information Technology in Augusta, ME seeks a Programmer Analyst to design, develop, and maintain data warehouse and application programs. Responsibilities include Oracle SQL/PL, ETL processes, and AOPEX apps; work spans requirements through deployment with minimal supervision.

The role emphasizes translating business needs into technical solutions, documenting procedures, and collaborating with users and teams. Telework is available and competitive state benefits apply.