Data Analytics Contractor: 6-9 years (Advanced)
Overview
In this Data Analytics Contractor role, you will analyze large datasets to deliver actionable insights that support decision-making. You’ll build and maintain data models, dashboards, and reports to visualize findings for cross-functional teams. You will apply statistical methods to reveal trends and ensure data accuracy through validation and quality checks. You will work with data architects, SMEs, and actuaries to align data design with business needs and governance standards. This opportunity offers hands-on impact across data lineage, dictionary creation, and future-state data design in a regulated environment.
ResponsibilitiesCollect, process, and analyze large datasets to identify trends and insightsDevelop and maintain data models, dashboards, and reports for visualizationApply statistical and analytical tools to generate insightsCollaborate with project teams to understand data requirements and deliver analytical solutionsEnsure data accuracy and integrity via data validation and quality checksInventory metadata and source data across databases; document input sources, data lineage, movement, controls, and reporting dependenciesCompare data elements across systems to identify common fields and normalization needsIdentify data gaps, quality issues, missing attributes, control gaps, and reconciliation needsSupport creation of a data dictionary with definitions, naming conventions, metrics, and business rulesPartner with Data Architect, Data Modeler, Pipeline Engineers, SMEs, and leadership to support Bronze Layer readiness and future-state data designLeverage data profiling, metadata documentation, source-to-target mapping, and reconciliation in collaboration with technical and business SMEsActuarial or valuation background is advantageous for supporting actuaries and Controllers at OCA
Key requirementsSQL Advanced (6-9 years)Amazon Web Services (AWS) Intermediate (3-5 years)Databricks Intermediate (3-5 years)Data Build Tool (DBT) Intermediate (3-5 years)Data Governance Intermediate (3-5 years)Metadata Repository Advanced (6-9 years)GenAI Prompt Engineering Intermediate (3-5 years)Actuarial or valuation background advantageous (not required)collaboration with cross-functional teamsstrong data storytelling and communicationattention to detail and data stewardshipSQLDatabricksAWS