Blue Cross Blue Shield of Massachusetts

Financial Reporting Consultant

Finance & Insurance
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 10+ years of experience in financial reporting and data analysis.
  • Proficiency in SQL, Visual Studio, SQL Server, and SSIS.
  • Experience with process migration to SQL Server Management Studio/SSIS.
  • Strong background in health insurance membership reporting and metrics.
  • A Bachelor's Degree in a business-related field; a Master's Degree is a plus.

Responsibilities

  • Develop, automate, and streamline financial reports and processes.
  • Fulfill ad-hoc reporting requests for internal teams to support strategic decisions.
  • Translate business rules into system logic, resolving issues as they arise.
  • Set up and manage products within databases, coordinating with various internal teams.
  • Collaborate with cross-functional teams on projects and assist with RFPs.

Benefits

  • Autonomy in planning work while meeting objectives within a structured accountability framework.
  • Ability to influence project outcomes and internal team decisions.
  • Engagement with complex analytical work and resolution of data challenges.
  • Opportunities for ongoing professional development and technology application.
Full Job Description
The Role

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.

Your Day to Day
  • Innovate and Optimize: Play a critical role in developing, automating, and streamlining our reports and processes. Deliver monthly, quarterly, and annual production reports that are essential for both internal business decisions and external regulatory agencies.
  • Drive business forward as a strategic partner to internal teams, including Finance, Sales, and Product Management, by fulfilling ad-hoc reporting requests and providing the data they need to succeed.
  • Support system design, coding, and documentation. Accurately translate business rules and requirements into system logic and resolve issues when they arise. Leverage Claude Code and other advanced AI tools to optimize workflows and drive operational efficiency.
  • Set up new products and manage existing products within our 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.
  • Collaborate and Influence: Work closely with cross-functional teams on a variety of projects. Participate in workgroups for new product introductions and contribute essential data for RFPs.

We're Looking for:
  • Technical Proficiency: 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.
  • Industry Expertise: 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.

What You Bring:
  • A Bachelor's Degree, preferably in a business-related field. Master's Degree a plus.
  • Collaborative Spirit: A proven ability to work effectively and build strong relationships with a wide range of internal and external stakeholders.
  • Exceptional Communication: Excellent written and verbal communication skills, with the ability to translate complex data into clear, concise, and compelling information for various audiences.

What You'll Gain:
  • An environment where you can exercise personal responsibility and autonomy, planning your work to meet objectives within a clear framework of accountability.
  • The opportunity to influence internal teams and make decisions that directly impact the success of projects and team objectives.
  • A role where you will tackle a broad range of complex analytical work, investigating, defining, and resolving intricate data challenges.
  • A platform to continuously learn and apply new technologies and maintain an awareness of developing analytical tools and their applications to grow professionally in a rewarding environment.


This role is eligible for our Flex persona.

#LI-HYBRID

Minimum Education Requirements:

High school degree or equivalent required unless otherwise noted above

Location
BostonTime Type
Full time

Salary Range: $112,680.00 - $137,720.00

The job posting range is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. We may ultimately pay more or less than the posted range, and the range may be modified in the future. An employee's pay position within the salary range will be based on several factors including, but limited to, relevant education, qualifications, certifications, experience, skills, performance, shift, travel requirements, sales or revenue-based metrics, and business or organizational needs and affordability.

This job is also eligible for variable pay.

We offer comprehensive package of benefits including paid time off, medical/dental/vision insurance, 401(k), and a suite of well-being benefits to eligible employees.

Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company's sole discretion, consistent with the law.

About Blue Cross Blue Shield of Massachusetts

Blue Cross Blue Shield of Massachusetts (BCBSMA) is a state licensed private health insurance company under the Blue Cross Blue Shield Association with headquarters in Boston. It is the largest health plan in Massachusetts, serving 2.8 million members. BCBSMA is committed to providing access to high-quality, affordable health care to help improve the health and well-being of its members and the communities it serves.
Learn more about Blue Cross Blue Shield of Massachusetts
Size
3,700 employees
Industry
Founded
1937

Similar Jobs

More Jobs at Blue Cross Blue Shield of Massachusetts

More Finance & Insurance Jobs

Find similar Financial Reporting Consultant jobs: