Data Architect Job at CEDENT, Maine

cHNLZnA1UWxsKzloQVZCUUc2NGdveEtiS1E9PQ==
  • CEDENT
  • Maine

Job Description

Job description:

  • 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.
  • Experience with utilizing API calls for automated data refreshes.
  • 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 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.

Top Skills: 

  • Minimum of 5 years' experience as a Data Architect.
  • Experience with developing fully automated ETL processes from a variety of flat-file and DB sources.
  • Significant Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.
  • Expertise in dimensional modeling.
  • Ability to act as a technical mentor to junior developers.

Job Tags

Contract work,

Similar Jobs

Macdonald & Company

Vice President - Multifamily Development Job at Macdonald & Company

 ...amenities, and other key project features aimed at attracting the target demographic and achieving the required rent levels. Due...  ...coordinating timely entity formations, obtaining corporate approvals, and working with the construction team to secure the necessary building...