View Our Website View All Jobs

Data Architect

Hawkins Point Partners is seeking to hire an experience Data Architect to help create short-term tactical solutions to achieve long-term objectives and an overall data management roadmap. The successful candidate will assist with assessing and determining governance, stewardship, and frameworks for managing data across our client's organization.

The Data Architect will be expected to establish methods and procedures for tracking data quality, completeness, redundancy, and improvement. Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks. Develop and deliver long-term strategic goals for data integration standards in conjunction with data users, department managers, clients, and other key stakeholders.

Operational Management

  • Develop integration process data flows and data mapping analyses.
  • Address data-related problems in regards to systems integration, compatibility, and multiple-platform integration.
  • Develop and promote data integration methodologies and standards.
  • Act as an advocate of data integration and management, including coaching, training, and career development to staff.
  • Develop and implement key components as needed to create testing criteria in order to guarantee the fidelity and performance of data architecture.
  • Identify and develop opportunities for data reuse, migration, or retirement of systems.

Required Experience

  • 4-7 years Oracle ODI experience including experience with ODI 12c.
  • 4-7 years overall experience in Data Integration, Data Architecture, Data Modeling, and implementation.
  • 4-7 years of full lifecycle data warehousing experience.
  • Familiarity with student academic performance data and education data concepts
  • hands-on knowledge of ODI 11g including performance monitoring and tuning
  • knowledge of Oracle 11g database performance monitoring and tuning
  • In depth hands-on experience designing, implementing and troubleshooting ETL/ELT processes
  • Knowledge of relational database designs and concepts including normalization and dimensional models
  • Knowledge of web services and XML at the level of using ODI to interface with pre-existing web services as data sources and/or targets.
  • Experience with Oracle RAC on RHEL 6 platform preferably an Exadata platform
  • Ability to coordinate and work with network team and other system administration groups to isolate resource bottlenecks (bandwidth/network, cpu, memory, disk/storage)
  • Experience reading and evaluating Oracle SQL and using the Oracle Explain Plan feature
  • Desired familiarity with IBM Cognos in terms of its use and interaction with Oracle (e.g. building cubes, creating extracts, running queries and reports submitted via Cognos)
  • Experience in Installation, configuration and migration of ODI versions
  • Ability to develop ODI knowledge modules for checking, loading, and integration.
  • Experience in resolving ODI and database related data loading performance issues.
  • Implementation of ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including, Relational Database Management servers (including Oracle RDBMS, flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security).
  • Experience with Set up, configuring and administration of ODI according to requirements.
  • BI knowledge a requirement – 3-5 years in BI from ETL perspective.
  • Ability to observe steps and ascertain success of step or failure and root cause of step(s).
  • Experience in Master Data Management and Meta Data Management.
  • Experience in Dimensional Modeling.
  • Assist infrastructure personnel in implementing the ODI migration process to migrate the ODI configuration through various development, test, and production environments.
  • Mentor and transfer ODI technical knowledge and processes to other team and department personnel, as requested.

Desired Experience

  • Good knowledge of applicable data privacy practices and laws (FERPA).
  • Experience in an education environment a plus.
  • Experience with Oracle Exadata is a plus.


Read More

Apply for this position

Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file