Title- Data Analytics
Mode- Contract
Location- Remote
Primary Skill Required for the Role-
SQL
Additional Details for Role-
The resources will be responsible for supporting the following activities:
• Inventory metadata and source data across all databases in scope ( FN, FR to start with)
• Understand and document detailed input sources, data lineage, data movement, controls, and downstream reporting dependencies.
• Compare data elements across FN, FR, AVD, LTC, and GPR to identify common fields, differences, and normalization needs.
• Compare source system inputs to what currently exists in the cloud / Databricks environment.
• Identify data gaps, quality issues, missing attributes, control gaps, and reconciliation needs.
• Support the creation of a data dictionary, including definitions, naming conventions, metric definitions, and business rules.
• Partner with the Data Architect, Data Modeler, Pipeline Engineers, database SMEs, actuarial SMEs, and project leadership to support Bronze Layer readiness and future-state data design.
"The ideal resource should have strong data analysis and data stewardship skills, including experience with data profiling, metadata documentation, source-to-target mapping, data dictionaries, reconciliation, and working with technical and business SMEs. An actuarial or valuation background would be highly valuable since this work will directly support actuaries and Controllers within OCA."