Regulatory Reporting Analyst

AF Group Careers Section; United States; On-site; USD 57,000 - 80,000; Full time

Job summary

Blue Cross Blue Shield of Michigan is seeking a Regulatory Reporting Analyst to support the regulatory reporting function under supervision. The role involves data manipulation, identifying process improvements, and building scalable reporting solutions.

Collaboration with the Actuarial Data Team ensures data requirements and frameworks meet department needs. The successful candidate will have a bachelor’s degree in a related field, plus experience with data analysis and Microsoft Office.

Qualifications

• Bachelor’s degree in actuarial science, mathematics, finance, economics, or related field.
• Two years of relevant experience preferred.
• Proficiency in Microsoft Office Suite (Word, Excel, Access).
• Data analysis experience preferred.

Responsibilities

• Understand, define, and document reporting goals, needs, and requirements.
• Define data requirements for regulatory reporting with the Actuarial Data Team.
• Troubleshoot regulatory data reporting impacts and propose solutions.
• Develop repeatable data flows using enterprise data sources and BI tools.
• Act as SME in moderate scale solution development.
• Perform data scrubbing, aggregation, and amendments to meet requirements.
• Develop and implement monitoring tools and reports under supervision.
• Create and maintain technical documentation of processes and workflows.
• Apply QA techniques, including reconciliation and peer-review.
• Design and develop reporting templates and schedules.
• Develop proficiency with data and reporting tools.
• Maintain data confidentiality.

Skills

Statistical analysis

Data analysis

Data quality

Communication skills

Teamwork

Problem solving

Education

Bachelor’s degree in actuarial science, mathematics, finance, economics, or related field

Tools

Microsoft Office

Database applications

Job description

SUMMARY

The Regulatory Reporting Analyst supports the regulatory reporting function under the direction of the Regulatory Reporting Supervisor. The Analyst applies data manipulation and analytical skills to identify opportunities for process improvement, create and monitor data quality indicators, troubleshoot problems, and develop and implement data reporting solutions. The Analyst uses knowledge of business processes, systems, and databases to improve the overall success of the regulatory reporting function by improving data quality and increasing scalability. In collaboration with the Actuarial Data Team, the Analyst defines new data requirements and specifications, and ensures frameworks for data reporting meet the needs of the regulatory reporting department.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Work with customers and department personnel as appropriate to understand, define, and document reporting goals, needs, and requirements.
• Define data requirements for regulatory reporting and work in partnership with the Actuarial Data Team to ensure the availability of adequate data resources to accomplish tasks.
• Work with business process owners to understand and troubleshoot impacts to regulatory data reporting, and recommend solutions.
• Develop repeatable data flows and processing steps using enterprise and departmental data sources, BI tools, data development interfaces, and other tools and data sources as needed to accomplish tasks.
• Act as subject matter expert in moderate scale solution development.
• Perform data scrubbing, aggregation, grouping, and amendment as needed to meet customer requirements.
• Develop and implement monitoring tools and reports under the direction of the Regulatory Reporting Manager.
• Create and maintain technical documentation of processes and workflows, including purpose, data sources, methodology, procedures for updating, intended use, schedules, and quality control items.
• Apply quality assurance techniques to deliverables to ensure quality of work products, including reconciliation, cross-checking, and peer-review.
• Design and develop reporting templates and schedules as needed.
• Develop proficiency with data and reporting tools as required.
• Maintain confidentiality of data and information as appropriate.

EDUCATION AND EXPERIENCE

Bachelor’s degree in actuarial science, mathematics, finance, economics, or related field required. Prior experience or skills may be considered in lieu of a degree. Continuous learning required, as defined by the Company’s learning philosophy. Certification in a relevant discipline, or progress toward certification, is preferred and encouraged.

REGULATORY REPORTING ANALYST

With proper education, two years of relevant experience which provides the necessary skills, knowledge, and abilities is preferred. Proficiency in the use of Microsoft Office Suite (Word, Excel, and Access) required. Data analysis experience is preferred.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

OTHER SKILLS AND ABILITIES

Skill levels are progressive:

• Ability to perform statistical analysis.
• Knowledge of mathematics and statistics required to perform necessary computations
• Knowledge of database applications
• Ability to apply the principles of logical thinking to define problems, collect data, establish facts and draw conclusions
• Ability to recognize the impact of business processes and data processing systems to regulatory data and take appropriate action
• Ability to effectively exchange information clearly and concisely, present ideas, report facts and other information, and respond to questions as appropriate
• Strong oral and written communications skills
• Ability to assess the suitability of data and data visualization techniques for an intended purpose
• Ability to exercise discretion and independent judgment
• Ability to work in a team environment with a diverse portfolio of products and customers
• Ability to effectively present complex information and concepts and respond to questions appropriately
• Ability to recognize confidential information and intellectual property, and protect appropriately
• Proficiency in the use of computers and company standard software specific to position
• Ability to meet necessary deadlines
• Ability to maintain confidentiality as appropriate

ADDITIONAL INFORMATION

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified. This job description does not constitute a contract for employment.

WORKING CONDITIONS

Work is performed in an office setting with no unusual hazards. Minimal travel required.

PAY RANGE

Actual compensation decision relies on the consideration of internal equity, candidate’s skills and professional experience, geographic location, market, and other potential factors. It is not standard practice for an offer to be at or near the top of the range, and therefore a reasonable estimate for this role is between $56,700 and $80,000.

We are an Equal Opportunity Employer. We will not tolerate discrimination or harassment in any form. Candidates for the position stated above are hired on an "at will" basis. Nothing herein is intended to create a contract.