Data Architect / Business Analyst (Actuarial & Insurance Data)

W2 contractors (no 3rd party inquiries, we will not reply) We’re looking for a hands-on Actuarial Data Architect / Business Analyst who can own the flow of insurance and actuarial data from end to end. This person will partner closely with actuarial, data engineering, and business teams to understand how data moves through the organization, shape scalable data solutions, and ensure the information used for reporting, modeling, and analytics is accurate, well-documented, and trusted. What You’ll Do • Work directly with business and actuarial stakeholders to understand data needs, define requirements, and translate them into technical specifications. • Partner with engineers to guide solution design and confirm data pipelines, transformations, and structures support business goals. • Dive deep into insurance datasets—policy, claims, billing, financial—to diagnose data issues, recommend fixes, and ensure consistent data quality. • Build detailed documentation including mapping rules, data definitions, lineage, workflows, process diagrams, and architectural visuals. • Prepare and transform datasets using SQL and Python to support analytics, reporting, and actuarial workloads. • Develop standards for metrics, table structures, and update processes to improve consistency across the data ecosystem. • Ensure data accuracy, usability, and completeness across multiple systems, collaborating frequently with technical teams to troubleshoot issues. What You Bring • Strong background working with actuarial or insurance datasets in a data analyst, data architect, or hybrid BA/technical role. • Advanced SQL skills with hands-on experience building transformations in Snowflake. • Proficiency in Python for data manipulation, exploration, and validation. • Ability to create clean, structured documentation that captures data flows, system behavior, and logical rules. • Deep understanding of how metrics, data structures, and update cycles support analytics in an insurance environment. • Strong communication skills and comfort working across technical and business groups. Bonus Skills • Experience with big data tools or cloud-based data engineering • Familiarity with actuarial processes (valuation, experience studies, reserves) • Knowledge of data governance or metadata management