Data Modeler

SUMMARY:

The client Fidelity is initiating a migration project to enhance and update their current reporting infrastructure aiming to move away from the existing ecosystem of Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Exadata towards a new setup involving Snowflake and Power BI hosted on AWS and Azure platforms respectively. The migration is driven by the need to address various challenges including data quality issues lack of selfservice capabilities and alignment with Enterprise Information (EI) and Workplace Investing (WI) cloud strategies. The transition aims to provide a better reporting experience faster time to market and support the decommissioning of legacy hardware and data warehouses.

Responsibilities: Design logical and physical data models for the reporting database. Work closely with data engineers to implement the data structures and ensure they support efficient data retrieval and reporting capabilities. Define data relationships constraints and indexing strategies.

Qualifications: Deep understanding of data modeling principles and experience with AWS RDS or other cloud database services. Proficient in designing data models for business intelligence and reporting purposes. Knowledge of financial data structures and requirements. Experience with data migration and transformation projects.