Job Description

Experis is an industry-leading technology recruitment and project services firm, driven by data and enabled by global reach. We can connect you to an individual with a specific skill set, manage capacity across a team, or provide in-house expertise to deliver your project. Experis has an immediate need for DATA ARCHITECT   to support our STATE GOVERNMENT client HYBRID reporting to Augusta, ME 04330. 

ROLE DATA ARCHITECT
INDUSTRY State Government
DURATION CONTRACT
LOCATION HYBRID reporting to Augusta, ME 04330
INTERVIEW pre-qualifying MS TEAMS conversation
MUST HAVE 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

EXPERIENCE EXPECTATION

• 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.

The Company is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.

Job Tags

Contract work, Immediate start,

Similar Jobs