The ClientDOT EDW is central to mandatory Federal billing, providing management reports to ClientDOT leadership for legislative discussions and building the ClientDOT 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.
location: Augusta, Maine
job type: Contract
salary: $72.63 - 77.63 per hour
work hours: 8am to 5pm
education: Bachelors
responsibilities:
- 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.
- 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
qualifications:
- Experience level: Experienced
- Education: Bachelors
skills:
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.
