This job ad has been posted over 60 days ago...
0
applicants
Remote| Data Architect | Huntington Bank OH
at Cerebra Consulting Ohio in Ohio (Published at 29-10-2022)
Title: DATA ARCHITECT
Client: Huntington Bank OH
Fully Remote.
Description:
This position will have solid-line reporting to the Head of Balance Sheet Management, and dotted-line reporting to the head of the Finance Data Transformation program. The expectation is that this individual will represent the BSM group at key scheduled and ad hoc progress meetings. This position is fully remote.
Responsibilities: * Do a full diagnostic of the data used by QRM-ALM today. Identify every field that's relevant to the successful execution of ALM forecasts
Client: Huntington Bank OH
Fully Remote.
Description:
This position will have solid-line reporting to the Head of Balance Sheet Management, and dotted-line reporting to the head of the Finance Data Transformation program. The expectation is that this individual will represent the BSM group at key scheduled and ad hoc progress meetings. This position is fully remote.
Responsibilities: * Do a full diagnostic of the data used by QRM-ALM today. Identify every field that's relevant to the successful execution of ALM forecasts
- For each data element identified above, identify which of the fields are:
- Already being migrated from existing infrastructure to the Finance data mart through Regulatory Reporting or Liquidity/2052a workstreams
- Not yet on the roadmap for migration
- For all elements in 2a, verify that the specific implementation is fit for use by the QRM engine. For all elements in 2b, work with the appropriate data partners to ensure the appropriate data element is made available in the data lake
- Reprogram the QRM application, where necessary, to migrate QRM-specific transformations out of the pre-QRM data table and into the QRM application's ETL module
- Partner with the ALM Production team to demonstrate the regression testing that key IRR metrics exhibit no material changes driven by the change in data flows.
- Provide testing documentation describing the data lineage consumed by the QRM stratification, data validation approach, and regression model testing results.
- Develop procedural documentation for use by QRM support team to maintain the new ETL process.
