Financial Reporting Consultant

Blue Cross Blue Shield of Massachusetts•Boston, MA

8d•Hybrid

About The Position

We are seeking a seasoned Financial Reporting Consultant to provide expert-level data analysis and reporting for our critical business functions. This role is pivotal in delivering essential reports, supporting strategic decisions, writing efficient SQL code, and driving process automation within our databases to ensure the accuracy and efficiency of our membership reporting.

Requirements

Extensive experience with SQL, databases, data analysis, and reporting.
Highly skilled in SQL, Visual Studio, SQL Server and SQL Server Integration Services (SSIS).
Experience migrating processes from one environment to another, such as MS Access to SQL Server Management Studio/SSIS.
Experience with Claude Code and ETL processes a plus.
A strong background in the health insurance industry, with a solid understanding of membership reporting requirements, metrics, and the sales and enrollment processes.
10+ years of related experience.
A Bachelor’s Degree, preferably in a business-related field.
Master’s Degree a plus.
A proven ability to work effectively and build strong relationships with a wide range of internal and external stakeholders.
Excellent written and verbal communication skills, with the ability to translate complex data into clear, concise, and compelling information for various audiences.
High school degree or equivalent required.

Nice To Haves

Experience with Claude Code and ETL processes a plus.
Master’s Degree a plus.

Responsibilities

Develop, automate, and streamline reports and processes.
Deliver monthly, quarterly, and annual production reports.
Fulfill ad-hoc reporting requests and provide data to internal teams.
Support system design, coding, and documentation.
Translate business rules and requirements into system logic and resolve issues.
Leverage Claude Code and other advanced AI tools to optimize workflows.
Set up new products and manage existing products within databases.
Work with Contracts, Online Benefits, and other internal areas on product-related issues, questions, and requests.
Coordinate with Sales and project leads when new plans are brought to market or existing plans are cancelled.
Participate in workgroups for new product introductions and contribute data for RFPs.