Financial Experience (having experience working in a Chief Financial office of an Org *OR* someone who has worked in Banking / Insurance / PNC w/Regulatory Reporting modeling)
Source systems from vendors / regulatory reporting
Other buzzwords he mentioned were AR/AP/GL etc.
brief description of the project and what this person will be doing – day to day responsibilities:
• Work collaboratively with business SMEs, information architecture and technology partners to facilitate modeling design decisions and establish the data models that support how business users access and use data to achieve the CFO KPIs and goals
• Ability to analyze operational data sources and data consumption patterns to build target state logical and physical data warehouse/mart models
• Understand Finance and Risk data domains, metrics and regulatory reports
• Proficiency in dimensional (star schema, snowflake schema) and normalized data models as well Knowledge of multiple database platforms including relational, columnar, NoSQL, and cloud-based solutions
• Demonstrate extensive knowledge of Data Modeling tools such as ER Studio and Erwin
Currently doesn’t have any standardization
Team size 10-11 people
Financial experience- experience working in a chief financial office of an org
General ledger/accounting principles – have worked for financial services
Have experience with regulatory reporting
Standard practices
Work with architecture and leads- give input on their past experience
Not ETLing – data movement falls on delivery teams
Primary is strategy and data assets.
Assist with governance
Must have skills/technologies:
• Financial Experience (having experience working in a Chief Financial office of an Org *OR* someone who has worked in Banking / Insurance w/Regulatory Reporting modeling)
o Source systems from vendors / regulatory reporting
? Other buzzwords he mentioned were AR/AP/GL etc.
• Data Modeling – Erwin
• Data Management / Lineage (mids won’t need as much of this…)
o When they find duplicate assets, they need to help with the governance
Nice to haves’ skills/technologies:
Familiar with OFSAA FSDF data model
Reporting (collab w/ Reports Developer)