Actuarial Data Quality Analyst I

1 month ago


Livonia, United States Compensation Advisory Organization of Michigan Full time
Job DescriptionJob Description

About the Job

Under significant supervision and with some independent judgment, review, test and validate data collection. Maintain data reporting requirements for all policy, unit statistical and financial data calls. Participate in ad-hoc data requests and/or implementing new data calls as requested. Generate scripts and processes to automate data testing, reporting and verification as needed.

Role and Responsibilities

  • Data collection and validation
  • Data Warehouse Development / Maintenance
  • Analyze large data sets
  • SQL Programming and Reporting
  • Assist in the development of pure premium (rate) indications
  • Assist in the development of classification pure premiums (rates) and other rating values

Qualifications and Education Requirements

  • Minimum: Bachelor’s degree from four-year College or university; or four to six years related experience and/or training; or equivalent combination of education and experience.
  • Basic knowledge of Transact-SQL, SSRS programming and development.
  • Basic knowledge of MS-Excel or related analytical software.
  • Basic knowledge and experience with Data Warehouse best practices. Able to articulate the value of those practices to a technical or non-technical audience.
  • Experience designing and building Data Warehouse structures, processing, and reports preferred.
  • Proficient with ETL concepts and implementation.
  • Development of Business Intelligence software, including the construction of complex reports based on warehouse data.
  • Basic skills in database design, tuning and other DBA related tasks.
  • Competent in Microsoft Outlook, Word and Excel.
  • Collaborative, positive, energetic team player.
  • Strong, effective, written and verbal communication skills.
  • Good judgement and business acumen.
  • Motivated, self-directed work ethic, willing to aggressively pursue individual and team goals.

Salary starts at $56,000/year and is commensurate with experience.

Company DescriptionCAOM is a private, non-profit association of insurance companies that write workers’ compensation insurance in Michigan. CAOM collects, processes and analyzes worker’s compensation policy and claim data for member companies and state regulators. CAOM’s sister organization, the Michigan Workers’ Compensation Placement Facility, processes worker’s compensation coverage applications for businesses that are unable to get coverage by ordinary means due to high claim activity, high risk operations, or other reasons. Established by state statute in 1983 and funded by its member insurance carriers, CAOM is the sole organization responsible for these duties in Michigan, resulting in a uniquely stable work environment regardless of economic fluctuation. CAOM’s small number of employees (less than 35) provide a family-like atmosphere and are consistently recognized for outstanding customer service.
CAOM is an equal opportunity employer, offering active full-time employees a highly competitive benefit package, including but not limited to, paid time off, paid personal time, paid holidays, insurance (medical, dental, vision, life), a company-sponsored retirement plan, training, and educational opportunities. Once respective seasoning requirements are met, new hires are eligible for these benefits and any other benefits CAOM may adopt.Company DescriptionCAOM is a private, non-profit association of insurance companies that write workers’ compensation insurance in Michigan. CAOM collects, processes and analyzes worker’s compensation policy and claim data for member companies and state regulators. CAOM’s sister organization, the Michigan Workers’ Compensation Placement Facility, processes worker’s compensation coverage applications for businesses that are unable to get coverage by ordinary means due to high claim activity, high risk operations, or other reasons. Established by state statute in 1983 and funded by its member insurance carriers, CAOM is the sole organization responsible for these duties in Michigan, resulting in a uniquely stable work environment regardless of economic fluctuation. CAOM’s small number of employees (less than 35) provide a family-like atmosphere and are consistently recognized for outstanding customer service. \r
CAOM is an equal opportunity employer, offering active full-time employees a highly competitive benefit package, including but not limited to, paid time off, paid personal time, paid holidays, insurance (medical, dental, vision, life), a company-sponsored retirement plan, training, and educational opportunities. Once respective seasoning requirements are met, new hires are eligible for these benefits and any other benefits CAOM may adopt.

  • Livonia, United States Compensation Advisory Organization of Michigan Full time

    Job DescriptionJob DescriptionAbout the JobUnder significant supervision and with some independent judgment, review, test and validate data collection. Maintain data reporting requirements for all policy, unit statistical and financial data calls. Participate in ad-hoc data requests and/or implementing new data calls as requested. Generate scripts and...

  • Actuarial Consultant

    3 weeks ago


    Livonia, Michigan, United States AAA Life Insurance Company Full time

    Overview: The Actuarial Consultant may have wide range of responsibilities that may include but not be limited to Valuation and reserving, asset liability modeling, economic capital modeling, cash flow testing, pricing & product develop, data analytics and data science, product management, underwriting and risk pricing. The Actuarial Consultant will be...

  • Actuarial Consultant

    1 month ago


    Livonia, United States AAA Life Insurance Company Full time

    OverviewThe Actuarial Consultant may have wide range of responsibilities that may include but not be limited to Valuation and reserving, asset liability modeling, economic capital modeling, cash flow testing, pricing & product develop, data analytics and data science, product management, underwriting and risk pricing.The Actuarial Consultant will be expected...

  • Actuarial Associate

    1 month ago


    Livonia, Michigan, United States AAA Life Insurance Company Full time

    OverviewAAA Life is seeking to hire an Associate Actuary to support our Product Development team. This person will be responsible for things such as pricing products, performing full valuations, and/or preparing all facets of testing models. Requires regular communication and consultation with managers of systems, administration, sales, finance, and...

  • Actuarial Associate

    1 month ago


    Livonia, United States AAA Life Insurance Company Full time

    OverviewAAA Life is seeking to hire an Associate Actuary to support our Product Development team. This person will be responsible for things such as pricing products, performing full valuations, and/or preparing all facets of testing models. Requires regular communication and consultation with managers of systems, administration, sales, finance, and...

  • Actuarial Associate

    2 weeks ago


    Livonia, Michigan, United States AAA Life Insurance Company Full time

    Overview:AAA Life is seeking to hire an Associate Actuary to support our Product Development team. This person will be responsible for things such as pricing products, performing full valuations, and/or preparing all facets of testing models. Requires regular communication and consultation with managers of systems, administration, sales, finance, and...


  • Livonia, Michigan, United States DPDHL Full time

    Business Data Analyst II at DHL Supply ChainDo you consider yourself a results-driven leader who thrives in a dynamic environment with plenty of room for growth and development? Are you known for your knack for problem-solving and your ability to turn creative ideas and data analysis into actionable insights that benefit both your team and your clients? If...

  • Quality Manager

    2 weeks ago


    Livonia, United States Quality Metalcraft Inc Full time

    For 60 years, Quality Metalcraft (QMC) and Experi-Metal Inc (EMI) have been leaders in innovative structural solutions for the mobility industry. Joining forces, QMC-EMI makes the production and prototype parts that could be used in the next airplane you take or the next car you buy. We are small enough that YOU can make an impact in your day-to-day work...

  • Quality Manager

    2 weeks ago


    Livonia, United States Quality Metalcraft Inc Full time

    For 60 years, Quality Metalcraft (QMC) and Experi-Metal Inc (EMI) have been leaders in innovative structural solutions for the mobility industry. Joining forces, QMC-EMI makes the production and prototype parts that could be used in the next airplane you take or the next car you buy. We are small enough that YOU can make an impact in your day-to-day work...

  • Quality Manager

    3 weeks ago


    Livonia, United States Quality Metalcraft, Inc. Full time

    For 60 years, Quality Metalcraft (QMC) and Experi-Metal Inc (EMI) have been leaders in innovative structural solutions for the mobility industry. Joining forces, QMC-EMI makes the production and prototype parts that could be used in the next airplane you take or the next car you buy.We are small enough that YOU can make an impact in your day-to-day work...

  • Quality Manager

    3 weeks ago


    Livonia, United States Quality Metalcraft, Inc. Full time

    For 60 years, Quality Metalcraft (QMC) and Experi-Metal Inc (EMI) have been leaders in innovative structural solutions for the mobility industry. Joining forces, QMC-EMI makes the production and prototype parts that could be used in the next airplane you take or the next car you buy.We are small enough that YOU can make an impact in your day-to-day work...

  • Senior Data Scientist

    1 month ago


    Livonia, United States Vaco Full time

    ResponsibilitiesDevelop and implement experimentation best practices, statistical methodologies, and scalable frameworks to facilitate the creation, monitoring, and learning from experiments.Cultivate strong relationships with internal users of the experimentation platform, comprehending their preferences and experiences to enable them to conduct rapid,...

  • Senior Data Scientist

    1 month ago


    Livonia, United States Vaco Full time

    ResponsibilitiesDevelop and implement experimentation best practices, statistical methodologies, and scalable frameworks to facilitate the creation, monitoring, and learning from experiments.Cultivate strong relationships with internal users of the experimentation platform, comprehending their preferences and experiences to enable them to conduct rapid,...

  • Quality Engineer

    3 weeks ago


    Livonia, United States Quality Metalcraft, Inc. Full time

    For 60 years, Quality Metalcraft (QMC) and Experi-Metal Inc (EMI) have been leaders in innovative structural solutions for the mobility industry. Joining forces, QMC-EMI makes the production and prototype parts that could be used in the next airplane you take or the next car you buy.We are small enough that YOU can make an impact in your day-to-day work...

  • Quality Engineer

    1 week ago


    Livonia, United States Quality Metalcraft Inc Full time

    For 60 years, Quality Metalcraft (QMC) and Experi-Metal Inc (EMI) have been leaders in innovative structural solutions for the mobility industry. Joining forces, QMC-EMI makes the production and prototype parts that could be used in the next airplane you take or the next car you buy. We are small enough that YOU can make an impact in your day-to-day work...


  • Livonia, United States DPDHL Full time

    Business Data Analyst II Are you a passionate leader looking for autonomy and exciting career possibilities?Do you take an energetic and resourceful approach to problem-solving while bringing innovative ideas and analytics to life on behalf of your team and your customers?Do you enjoy effectively translating requirements into an efficient process and/or...


  • Livonia, United States TRIGO Global Quality Solutions Full time

    Job DescriptionJob DescriptionTRIGO Global Quality Solutions is seeking a Quality Resident Liaison/Representative 30 hours / weekElectronic experience preferredThis job is key for the success of TRIGO's Quality Resident Engineering business, so the following objectives should be accomplished to the highest feasible standards to avoid the official claims...

  • Inventory Analyst

    3 weeks ago


    Livonia, United States Republic National Distributing Company Full time

    RNDC is looking for an analytical self-starter and team player. The Cycle Counter is responsible for monitoring warehouse inventory and performing cycle counting duties to ensure that all materials are properly verified to be reflective of reported i Inventory Analyst, Inventory, Analyst, Monitoring, Inventory Control, Manufacturing

  • People Analyst

    3 weeks ago


    Livonia, United States C&S Engineers Full time

    The People Analyst will collect, compile, and analyze HR data, metrics, and statistics, and apply this data to make recommendations related to recruitment, retention, and legal compliance. This position plays a vital role in collecting, structuring, Analyst, HRIS, Human Resource, Project Management, Construction, Leadership

  • Business Analyst

    1 month ago


    Livonia, United States Georgia IT Inc Full time

    Business Analyst Livonia, MI Business Analyst Position Description: The Business Analyst Reviews, analyzes and evaluates existing client systems, business processes and user needs. Documents requirements, specifications, process improvements and solutions to meet stated business objectives. Relies on experience and expert judgment to plan project work and...