Regulatory Reporting Analyst

Blue Cross Blue Shield of Michigan•Lansing, MI

1d•Onsite

About The Position

The Regulatory Reporting Analyst supports the regulatory reporting function under the direction of the Regulatory Reporting Supervisor. The Analyst uses data manipulation and analytical skills to identify process improvements, create and monitor data quality indicators, troubleshoot problems, and develop and implement reporting solutions. The role applies knowledge of business processes, systems, and databases to improve data quality and scalability. In collaboration with the Actuarial Data Team, the Analyst defines data requirements and specifications and ensures reporting frameworks meet the needs of the regulatory reporting department. The Analyst works with customers and department personnel to understand, define, and document reporting goals, needs, and requirements. The position develops repeatable data flows and processing steps using enterprise and departmental data sources, BI tools, data development interfaces, and other appropriate tools. It also performs data scrubbing and aggregation, develops monitoring tools and reports, maintains technical process documentation, applies quality assurance techniques, and designs reporting templates and schedules. The Analyst protects confidential information and develops proficiency with required data and reporting tools. The position requires a bachelor’s degree in actuarial science, mathematics, finance, economics, or a related field; relevant prior experience or skills may be considered in lieu of a degree. With appropriate education, two years of relevant experience is preferred. Proficiency with Microsoft Office Suite, including Word, Excel, and Access, is required, while data analysis experience and relevant certification or progress toward certification are preferred. Work is performed in an office setting with no unusual hazards, and minimal travel is required. The estimated pay range is $56,700–$80,000.

Requirements

Bachelor’s degree in actuarial science, mathematics, finance, economics, or a related field; prior experience or skills may be considered in lieu of a degree.
Proficiency in Microsoft Office Suite, including Word, Excel, and Access.
Ability to perform statistical analysis and apply relevant mathematical and statistical knowledge.
Knowledge of database applications.
Ability to define problems, collect data, establish facts, and draw conclusions using logical thinking.
Ability to recognize how business processes and data processing systems affect regulatory data and take appropriate action.
Strong oral and written communication skills, including the ability to exchange information clearly, present ideas, report facts, and respond to questions.
Ability to assess whether data and data visualization techniques are suitable 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 present complex information and concepts effectively and respond appropriately to questions.
Ability to recognize and appropriately protect confidential information and intellectual property.
Proficiency with computers and company-standard software specific to the position.
Ability to meet necessary deadlines and maintain confidentiality as appropriate.
Continuous learning as defined by the Company’s learning philosophy.

Nice To Haves

With proper education, two years of relevant experience that provides the necessary skills, knowledge, and abilities.
Data analysis experience.
Certification in a relevant discipline or progress toward certification.

Responsibilities

Work with customers and department personnel to understand, define, and document reporting goals, needs, and requirements.
Define data requirements for regulatory reporting and partner with the Actuarial Data Team to ensure adequate data resources are available.
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 appropriate tools and sources.
Act as a subject matter expert in moderate-scale solution development.
Scrub, aggregate, group, and amend data 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, 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.