Senior Developer / Data Architect

We would be looking for an experienced Senior Developer / Data Architect :

Developing automated ETL.

Designing & implementing enterprise class data repositories built upon Oracle on prem and cloud hosted DB's.

Expertise in dimensional modeling and ability to act as a technical mentor.

Typical Duties : This individual will serve as a daily subject-matter expert for all Oracle

technologies and toolsets. Much of the work will focus on data modeling and

developing automated ETL processes that pull data from a variety of data

sources. However, data assignments will not be limited to these areas. They will be

expected to develop, monitor, and maintain a variety of automated DB processes. They

will be expected to research and resolve database issues as they arise. They will be

assigned a variety of database management and maintenance tasks. They will serve

as a trusted technical advisor to the MaineIT / MaineDOT Application Support team and serve as a technical mentor. They will

collaborate with other developers, analysts, and employed DBAs. They will work closely with IT vendors, IT leadership, and

MaineDOT business partners. They will play a key role in upcoming system migrations, system expansions, and data

modernization efforts.

Requirements

1. Has extensive practical experience with the modern Oracle platforms and

technologies. This includes the following :

A. Significant Senior DBA-level experience with regards to designing and

implementing enterprise class data repositories built upon Oracle on-

prem and cloud-hosted databases.

B. Practical experience developing fully automated ETL processes from a

variety of flat-file and DB sources.

C. Practical experience utilizing API calls for automated data refreshes.

D. Practical experience with Oracle Analytics Cloud (OAC)

E. Mastery of SQL and PL / SQL and the ability to develop complex

procedures, functions, views, and scripts.

2. Expertise in dimensional modeling.

3. Experience with tabular data models.

4. Proven ability to accurately capture complex business requirements and

translate those into technical solutions which are robust, performant, scalable,

reliable, and expandable.

5. Demonstrates a disciplined approach to process and error logging.

6. Maintains excellent work habits when it comes to coding comments, system

documentation, and metadata creation.

7. Ability to serve as a technical mentor to both senior and junior IT staff.

8. Ability to develop architectural diagrams and system documentation, and train

others on the content.

9. Demonstrates previous success in independently researching technical options

to find suitable solutions for evolving technical needs.

10. Works independently towards project and / or assignments goals with limited day-

to-day oversight and / or prompting.

Benefits

Work Location : Majority Remote position but will be required to be onsite in Augusta, ME one day a month. Travel costs will not be billable.