Datawarehouse-ETL Architect Job at Novalink Solutions LLC, Augusta, ME

V0lwZUFqSURvd1F3eHZLZGtpRUIrVE1MVGc9PQ==
  • Novalink Solutions LLC
  • Augusta, ME

Job Description

Top 3 Skills:

Developing automated ETL

Designing & Implementing Enterprise class data repositories built upon Oracle on prem and cloud hosted databases

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

The MaineDOT EDW is central to mandatory Federal billing, providing management reports to MaineDOT leadership for legislative discussions and building the MaineDOT 3-year Workplan. 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 Maine Department of Transportation (MDOT) and serve as a technical mentor to other IT staff. They will collaborate with other developers, analysts, and DBAs employed by the MDOT and MaineIT. They will work closely with IT vendors, IT leadership, and MDOT business partners.

They will play a key role in upcoming system migrations, system expansions, and data modernization efforts.

Has extensive practical experience with the modern Oracle platforms and technologies. This includes the following:

Significant Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.

Practical experience developing fully automated ETL processes from a variety of flat-file and DB sources.

Practical experience utilizing API calls for automated data refreshes.

Practical experience with Oracle Analytics Cloud (OAC)

Mastery of SQL and PL/SQL and the ability to develop complex procedures, functions, views, and scripts.

Expertise in dimensional modeling.

Experience with tabular data models.

Proven ability to accurately capture complex business requirements and translate those into technical solutions which are robust, performant, scalable, reliable, and expandable. 

Demonstrates a disciplined approach to process and error logging.

Maintains excellent work habits when it comes to coding comments, system documentation, and metadata creation.

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

Ability to develop architectural diagrams and system documentation, and train others on the content.

Demonstrates previous success in independently researching technical options to find suitable solutions for evolving technical needs.

Works independently towards project and/or assignments goals with limited day-to-day oversight and/or prompting.

Job Tags

Full time,

Similar Jobs

Rubenstein

Executive Assistant Job at Rubenstein

 ...RUBENSTEIN is seeking an Executive Assistant to provide support for senior executives...  ...is discreet, trustworthy, and personable, and will have administrative experience...  ...can interact comfortably with c-suite, celebrity, and high-level media Full proficiency... 

More Staffing LLC

Video Editor (Fitness Industry) Job at More Staffing LLC

 ...version control. Requirements Qualifications: Proven experience as a Video Editor, preferably within the fitness, outdoor, or lifestyle industry. Proficiency in video editing software (Adobe Premiere Pro, After Effects, Final Cut Pro, or similar). Strong... 

USA Staffing Network

Cardiologist Job at USA Staffing Network

(Physician/MD qualifications required) Cardiology (Non-Invasive) - Cardiologist - A full-time Cardiologist is need for a well-established practice of two Finger Lakes regional hospitals. Direct Hire Competitive Compensation. Excellent Benefits Package Relocation... 

NIS EXPRESS

CDL A DRIVER -No Experience- Paid Training Job at NIS EXPRESS

 ...Pay: $1,200$1,500 per week, based on experience Miles: 2,1002,300 per week Home...  ...with APUs ~ No slip seating take your truck home For Recent CDL-A Graduates:...  ...Minimum 120+ hours from an accredited driving school Paid Training: 4-6 weeks (200-... 

Georgetown Learning Centers

Online Math and Science Tutor Job at Georgetown Learning Centers

Online Math and Science TutorThinkingStorm is a national online tutoring company seeking writing tutors to conduct live online tutoring sessions from home.Our ideal tutor has a BA/BS degree or higher in a math or science related discipline. If tutor is applying to...