Business System Analyst

Compunnel

$100K — $120K *
Finance & Insurance
11 - 15 years of experience
Job Overview by Ladders

Qualifications

  • 12+ years of experience as a Senior Data Analyst in Insurance, Reinsurance, or Actuarial environments.
  • Strong experience in business data analysis or similar roles within insurance or financial services.
  • Expertise in SQL and proficiency in handling complex data queries.
  • Deep knowledge of the insurance domain, specifically in actuarial, underwriting, broking, or insurance data environments.
  • Experience with data governance practices, including data quality and lineage.

Responsibilities

  • Analyze source systems to extract relevant data for reporting.
  • Define data mappings and prepare source-to-target mapping documents.
  • Document business rules, transformation logic, and data definitions clearly.
  • Conduct detailed source data analysis across multiple systems.
  • Ensure accuracy and integrity of data used for reporting and decision-making.
  • Collaborate with actuarial teams and business stakeholders to understand requirements.
  • Support reporting and dashboard development with a focus on data quality.

Benefits

  • Collaborative work environment with cross-functional teams.
  • Access to cutting-edge tools and technology in data analytics.
  • Opportunities for skill enhancement and professional growth.
  • Involvement in high-impact projects within the insurance industry.
  • Engagement with key business leaders and actuarial experts.
Full Job Description
JOB SUMMARY We are seeking an experienced Senior Data Analyst with strong insurance and actuarial domain knowledge to support data analysis, reporting, governance, and business intelligence initiatives. The role will involve working closely with business stakeholders, actuarial teams, underwriting and broking functions, data engineers, and reporting teams to understand business requirements, analyze source systems, define data mappings, and ensure the accuracy and integrity of data used for reporting and decision-making. The ideal candidate will have hands-on experience in actuarial and insurance environments, strong SQL capabilities, and a proven ability to translate complex business requirements and rules into clear, documented data solutions. Key Responsibilities Advanced SQL, Strong insurance domain knowledge with experience in Actuarial. Hands-on experience in data analysis and Strong understanding of data warehouses, data lakes, ETL/ELT processes, analytical data models, and Azure/Databricks ecosystem. Excellent SQL skills, including: Complex joins and subqueries Common table expressions Window functions Aggregations and reconciliations Data profiling and validation Query optimization Proven experience conducting detailed source data analysis across multiple systems. Strong capability in preparing and maintaining source-to-target mapping documents. Experience documenting business rules, transformation logic, calculations, assumptions, and data definitions. Hands-on experience with data reconciliation, data quality analysis, and issue investigation. Understanding of data warehouses, data lakes, reporting layers, ETL/ELT processes, and analytical data models. Familiarity with Databricks and the Azure data ecosystem. Experience working with large, complex, and potentially distributed datasets. Exposure to reporting, dashboards, management information, and analytical outputs. Ability to interpret technical data structures and explain them in business terms. Deep knowledge of the insurance domain, with hands-on experience in actuarial, underwriting, broking, or insurance data environments. Practical understanding of actuarial processes such as: Pricing and rating Reserving Loss ratios and profitability analysis Exposure and premium analysis Claims development Forecasting and portfolio performance Strong understanding of underwriting and broker data, including policy, submission, quote, bound, premium, commission, exposure, risk, and claims information. Experience interpreting insurance and actuarial metrics, business rules, and reporting requirements. Ability to work effectively with actuaries, underwriters, brokers, finance teams, and business leadership. Understanding of insurance reporting cycles, data dependencies, and key operational and regulatory considerations. Experience working with data governance frameworks, standards, and controls. Knowledge of data ownership, stewardship, lineage, metadata, data dictionaries, and critical data elements. Experience defining and validating data quality rules and reconciliation controls. Exposure to governed reporting environments and consistent KPI or metric definitions. Ability to ensure that reporting outputs are complete, accurate, traceable, and aligned with approved business rules. Experience supporting reporting requirements, dashboard development, management information, or regulatory reporting. Required Qualifications Minimum 12+ years of experience as a Senior Data Analyst in Insurance, Reinsurance, Actuarial environments. Strong experience as a Senior Data Analyst, Business Data Analyst, or similar role in an insurance, actuarial, financial services, or data-intensive environment. Preferred Qualifications None mentioned Certifications None mentioned

Similar Jobs

More Jobs at Compunnel

More Finance & Insurance Jobs

Find similar Business System Analyst jobs: