Data Architect - Remote

Job Description

Location: Remote with some travel to California (California candidates preferred)

Work Hours: 9-5pm PST

Duration: 12 months

Requirements:

• Deep experience with large data sets and managing deltas
• Experience across multiple big data platforms (Hadoop, Hortonworks, MapR, Cloudera, AWS, GCP, etc.)
• 5+ years of experience
• Develop database solutions to store and retrieve company information
• Install and configure information systems to ensure functionality
• Analyze structural requirements for new software and applications
• Migrate data from legacy systems to new solutions
• Design conceptual and logical data models and flowcharts
• Improve system performance by conducting tests, troubleshooting and integrating new elements
• Optimize new and current database systems
• Define security and backup procedures
• Provide operational support for Management Information Systems (MIS)

Stack used:

• DW – Oracle 19C
• ODI – Oracle Data Integrator
• SSIS to push data into Oracle DW
• OSI PI

First Project - OBI Metadata Improvement:

Phase 1

• Currently the tables have not details/definitions about the table, columns etc.
• Oracle Database
• Identify tool where to save the details/definitions.
• Populate the details for all databases with relevant details.

Phase 2

• Application Component Dependency Mapping
• Identify which applications are accessing which data from which databases and the data flow.
• Identify tool/system to capture this information
• Populate this data in the identified system/tool.

Second Project - ED PI Data Quality Improvement:

• This team is expected to help build Data Quality detection algorithms
• Original they used SQL Server environment but is now all in Oracle.

Qualifications

• Location: Remote with some travel to California (California candidates preferred)

  Work Hours: 9-5pm PST

  Duration: 12 months

   

  Requirements:

• Deep experience with large data sets and managing deltas
• Experience across multiple big data platforms (Hadoop, Hortonworks, MapR, Cloudera, AWS, GCP, etc.)
• 5+ years of experience
• Develop database solutions to store and retrieve company information
• Install and configure information systems to ensure functionality
• Analyze structural requirements for new software and applications
• Migrate data from legacy systems to new solutions
• Design conceptual and logical data models and flowcharts
• Improve system performance by conducting tests, troubleshooting and integrating new elements

• Stack used:

• DW – Oracle 19C
• ODI – Oracle Data Integrator
• SSIS to push data into Oracle DW
• OSI PI

• First Project - OBI Metadata Improvement:

  Phase 1

• Currently the tables have not details/definitions about the table, columns etc.
• Oracle Database
• Identify tool where to save the details/definitions.
• Populate the details for all databases with relevant details.

• Phase 2

• Application Component Dependency Mapping
• Identify which applications are accessing which data from which databases and the data flow.
• Identify tool/system to capture this information
• Populate this data in the identified system/tool.

• Second Project - ED PI Data Quality Improvement:

• This team is expected to help build Data Quality detection algorithms
• Original they used SQL Server environment but is now all in Oracle.
•  
• Optimize new and current database systems
• Define security and backup procedures
• Provide operational support for Management Information Systems (MIS)

Additional Information

All your information will be kept confidential according to EEO guidelines.