Remote Data Warehouse Programmer/Analyst

MaineGuide; Augusta, Northern (ME, KY); Hybrid; USD 60,000 - 85,000; Full time

Benefits offered by this job

Paid holidays

Sick leave

Vacation leave

Health insurance

Retirement plan

Gym membership reimbursement

Flexible Spending Accounts

Parental leave

Student Loan Forgiveness

Job summary

The State of Maine is seeking a Programmer Analyst to design, develop, and maintain data warehouse solutions within the Office of Information Technology in Augusta. You will work on multi-project teams writing Oracle SQL/PL/SQL, supporting APEX apps, and building ETL processes while communicating with users and stakeholders.

Qualifications include a Bachelor's in Computer Science or equivalent, with experience in Oracle tools and data warehousing; multiple certifications and years of experience

Qualifications

• Bachelor's Degree in Computer Science or equivalent
• Associates Degree + 1 year dev experience or 2 years dev experience
• Experience in Oracle SQL/PL/SQL and data warehousing

Responsibilities

• Develop, enhance, test, and maintain data warehouse programs
• Write and maintain Oracle SQL/PL/SQL scripts
• Support and enhance Oracle APEX applications
• Develop ETL processes for warehouse and reporting
• Translate business needs into technical requirements
• Provide timely progress updates and communicate with users

Skills

SQL

Structured programming

Data warehouse development

Data analysis

Documentation

Communication

Team collaboration

Education

Bachelor's Degree in Computer Science

Associate Degree in Computer Information Science + 1 year dev experience

2 years application development experience

Tools

Oracle SQL

PL/SQL

Oracle APEX

Oracle Cloud Infrastructure

Oracle SQL*Loader

Job description

The State of Maine is seeking a Programmer Analyst to design, develop, and maintain data warehouse solutions within the Office of Information Technology in Augusta. You will work on multi-project teams writing Oracle SQL/PL/SQL, supporting APEX apps, and building ETL processes while communicating with users and stakeholders.

Qualifications include a Bachelor's in Computer Science or equivalent, with experience in Oracle tools and data warehousing; multiple certifications and years of experience