Reporting Engineer II

Position Description

Base pay is influenced by several factors including a candidate’s qualifications, relevant experience, and anticipated contributions to meet the needs of the business, along with internal pay equity and external market driven rates. The salary range displayed has not been adjusted for geographical location. This range has been created in good faith based on information known to Capital Blue Cross at the time of posting and may be modified in the future. Capital Blue Cross offers a comprehensive benefits packaging including Medical, Dental & Vision coverage, a Retirement Plan, generous time off including Paid Time Off, Holidays, and Volunteer time off, an Incentive Plan, Tuition Reimbursement, and more. 

At Capital Blue Cross, we promise to go the extra mile for our team and our community. This promise is at the heart of our culture, and it’s why our employees consistently vote us one of the “Best Places to Work in PA.”

This position is a critical component of the A&R Reporting Services team, responsible for providing technical leadership, design, development, and implementation of both operational and analytical reporting solutions, as well as the associated infrastructure.

Responsibilities and Qualifications

• Development of Production Reporting Solutions: Design, develop, and maintain reporting solutions to support business operations.
• Business Requirements Translation: Interpret and translate complex business requirements into effective technical solutions.
• Consultation and Problem Solving: Serve as a consultant, researcher, problem solver, advisor, liaison, and developer for production reporting processes, ensuring optimal performance and reliability.
• Data and Reporting Requests: Efficiently fulfill data, analytical, and reporting requests within tight timelines, ensuring accuracy and completeness.
• Billing Process Support: Provide support for ASO/Fully Insured Billing Processes, ensuring compliance and accuracy.
• Rate Renewal Notices: Program and produce rate renewal notices for the individual market, adhering to regulatory requirements and timelines.
• Mailing Generation: Generate ad hoc, recurring, and production mailings, ensuring timely and accurate delivery.
• Standards and Guidelines Management: Create and manage standards and guidelines for report development and related processes, ensuring consistency and quality.
• Technical Documentation: Document technical solutions and related architecture comprehensively, ensuring clarity and accessibility for future reference.

Skills:

• Ability to work independently in a fast-paced, dynamic environment, managing multiple tasks and priorities effectively.
• Strong analytical and problem-solving skills, with a meticulous attention to detail.
• Team player who values teamwork, collaboration, and open communication, contributing positively to team dynamics.
• Ability to communicate technical information to non-technical audiences effectively, including presenting data, answering questions, and addressing concerns.
• Proficiency in documenting technical information clearly and effectively.
• Strong written and verbal communication skills, ensuring clear and effective interaction with stakeholders.

Knowledge:

• Passion for learning new features, tools, and techniques, staying updated with industry trends and advancements.
• Facets Data Model Knowledge: Familiarity with the Facets Data Model, with a particular focus on enrollment, membership, and billing is preferred.

Experience:

• 5 years of experience in software development and/or report development.
• Toolset Expertise: Mastery level expertise with Crystal Reports 2020 and /or Power BI and/or SAS.
• SQL Proficiency: Mastery of SQL, with extensive experience in SQL Server, Snowflake, Netezza, and/or Oracle.
• Experience with StreamWeaver, is preferred.

Education and Certifications:

• Technical Degree: A BS degree in computer science, computer engineering, or a related technical discipline is strongly recommended.

Physical Demands:

• While performing the duties of the job, the employee is frequently required to sit, use hands and fingers, talk, hear, and see. The employee must occasionally lift and/or move up to 5 pounds.

About Us

We recognize that work is a part of life, not separate from it, and foster a flexible environment where your health and wellbeing are prioritized. At Capital you will work alongside a diverse and caring team of supportive colleagues, and be encouraged to volunteer in your community.  We value your professional and personal growth by investing heavily in training and continuing education, so you have the tools to do your best as you develop your career.     And by doing your best, you’ll help us live our mission of improving the health and well-being of our members and the communities in which they live.