Job Description
Job 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.
Recruiter Contact: ********
Company Description CAOM 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. Telecommuting from home twice a week is available to eligible employees as a flexible work option.
Company Description
CAOM 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.
\rCAOM 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. Telecommuting from home twice a week is available to eligible employees as a flexible work option.
#J-18808-Ljbffr
