Data Architect in ETL Automation - $99 CTC - REMOTE (Onsite in Augusta, ME 1 day / month)
Posted 7 days ago by 1763119336
Negotiable
Outside
Hybrid
USA
Summary: The Data Architect in ETL Automation will serve as a subject-matter expert in Oracle technologies, focusing on data modeling and automated ETL processes. This role involves developing, monitoring, and maintaining automated database processes while collaborating with various stakeholders. The position requires a strong technical background in Oracle platforms and the ability to mentor other IT staff. The role is primarily remote with one required onsite visit per month in Augusta, ME.
Key Responsibilities:
- Serve as a daily subject-matter expert for Oracle technologies and toolsets.
- Develop, monitor, and maintain automated ETL processes and database management tasks.
- Research and resolve database issues as they arise.
- Collaborate with developers, analysts, and employed DBAs, and serve as a technical mentor.
- Play a key role in system migrations, expansions, and data modernization efforts.
Key Skills:
- Extensive practical experience with modern Oracle platforms and technologies.
- Significant Senior DBA-level experience in designing and implementing enterprise class data repositories.
- Practical experience developing fully automated ETL processes and utilizing API calls for data refreshes.
- Mastery of SQL and PL/SQL, with the ability to develop complex procedures and scripts.
- Expertise in dimensional modeling and experience with tabular data models.
- Ability to capture complex business requirements and translate them into technical solutions.
- Disciplined approach to process and error logging, with excellent work habits in coding comments and documentation.
- Ability to serve as a technical mentor and develop architectural diagrams and system documentation.
- Proven success in independently researching technical options for evolving needs.
- Ability to work independently towards project goals with limited oversight.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: hybrid
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Job Description:
***Crop to Crop resumes are accepted
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.
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 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.
- 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. - 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.
Required Skills:
- 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.