Highlights
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. • Understand and document detailed input sources, data lineage, data movement, controls, and downstream reporting dependencies.
Numbers & Facts
| Location | Chicago, IL (Remote) |
| Industry | Computer/IT Services |
| Salary | $55–$60 Per Hour |
| Company Size | 500 to 999 employees |
| Website | https://www.apolisrises.com/ |
Description
Data Analytics - SQL
Remote
6+ months contract
Pay range - $57/hour on W2
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.
Remote
6+ months contract
Pay range - $57/hour on W2
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.
Benefits
Paid Sick Days, Employee Referral Program, Employee Events, Retirement / Pension Plans
About Company
Since 1996, RJT has provided successful SAP, Oracle, and IT consulting solutions and staffing services to clients around the world. The new Apolis brings you the same personalized service fortified with a greater array of IT solutions, global expertise, and cost-management strategies.
We are a global IT consultancy that seamlessly integrates experts and leading-edge solutions into your organization so you can focus on what really matters.