Reporting Engineer I/II - Capital Blue Cross

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 robust 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 Required:

• Independent Work: Ability to work independently in a fast-paced, dynamic environment, managing multiple tasks and priorities effectively.
• Analytical and Problem-Solving Skills: Strong analytical and problem-solving skills, with a meticulous attention to detail.
• Team Collaboration: A team player who values teamwork, collaboration, and open communication, contributing positively to team dynamics.
• Communication Skills: Ability to communicate technical information to non-technical audiences effectively, including presenting data, answering questions, and addressing concerns.
• Technical Documentation: Proficiency in documenting technical information clearly and effectively.
• Continuous Learning: A passion for learning new features, tools, and techniques, staying updated with industry trends and advancements.
• Written and Verbal Communication: Strong written and verbal communication skills, ensuring clear and effective interaction with stakeholders.

Experience Needed:

• Crystal Reports Expertise: Mastery level expertise with Crystal Reports 2020.
• Software and Report Development: A minimum of 5 years of experience in software development and/or report development.
• SQL Proficiency: Mastery of SQL, with extensive experience in SQL Server, Snowflake, Netezza, and/or Oracle.
• Facets Data Model Knowledge: Familiarity with the Facets Data Model, with a particular focus on enrollment, membership, and billing.
• Additional Tools: Experience with StreamWeaver, Power BI, and/or SAS is highly advantageous.

Education and Certifications:

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

Physical Demands:

• Work Environment: The role requires frequent sitting, use of hands and fingers, talking, hearing, and seeing.
• Work Hours: The ability to work full-time with occasional extra effort and time as needed
• Physical Activity: Occasionally lifting and/or moving up to 5 pounds.
• Travel Requirements: Travel up to 10% of the time

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.