Underwriting Database Management Specialist

Blue Cross and Blue Shield of Kansas; Kansas; Hybrid; USD 86,000 - 107,000; Full time

Benefits offered by this job

6 weeks paid parental leave

Fertility/Adoption assistance

2 weeks paid caregiver leave

401(k) matching up to 5%

Health & fitness benefits

Incentive pay program (EPIP)

Job summary

Blue Cross and Blue Shield of Kansas is seeking an Underwriting Database Management Specialist to support data needs of the underwriting department. You will extract, import, and link data from diverse sources, ensuring tool integrity and developing reports to inform rating decisions.

This role is eligible to work remote, hybrid or onsite per Telecommuting Policy. Applicants must reside in Kansas or Missouri or be willing to relocate.

Qualifications

• Bachelor's degree in Mathematics, Economics, Computer Science, Information Management, Actuarial Science, Statistics, or a related field.
• Minimum of 3 years of experience in data analytics, database management, or underwriting systems in health insurance.
• Experience with SQL, VBA, Tableau, Power BI, or similar reporting tools required.
• Background in health insurance rating, actuarial modeling, or underwriting processes is a plus.

Responsibilities

• Develop reports and dashboards for underwriting data needs using Excel, Access, and visualization tools.
• Maintain underwriting databases with accurate data integration and governance.
• Create VBA-based applications to automate underwriting workflows.
• Collaborate with IT on system enhancements related to underwriting systems.
• Audit, clean, and validate datasets to ensure data integrity.

Skills

Analytical skills

Communication

Time management

Problem solving

Education

Bachelor's degree in Mathematics, Economics, Computer Science, Information Management, Actuarial Science, Statistics, or related field

Tools

SQL

VBA

Tableau

Power BI

Access

Oracle

Job description

Make a Positive Impact: Your work will directly contribute to the health and well-being of Kansans.

Family Comes First: Total rewards package that promotes the idea of family first for all employees. Paid vacation and sick leave with paid maternity and paternity available immediately upon hire

Professional Growth Opportunities: Advance your career with ongoing training and development programs.

Dynamic Work Environment: Collaborate with a team of passionate and driven individuals in a work environment that promotes flexibility.

Trust and Stability: Work for one of the most trusted companies in Kansas with over 80 years of commitment, compassion and community.

Inclusive Work Environment: We pride ourselves on fostering a workplace where everyone is valued and respected.

Base compensation is only one component of your competitive Total Rewards package

• Incentive pay program (EPIP)
• 6 weeks paid parental leave for new mothers and fathers
• Fertility/Adoption assistance
• 2 weeks paid caregiver leave
• 401(k) plan matching up to 5%
• Health & fitness benefits, discounts and resources

Job Summary

The Underwriting Database Management Specialist supports the data needs of the Underwriting department. This role is responsible for extracting, importing, and linking data from various sources, ensuring the accuracy and integrity of underwriting tools, and developing reports to support rating and underwriting decisions. The specialist serves as a subject matter expert on underwriting tools, analyzing software needs, improving reporting capabilities, and driving process improvements.

“This position is eligible to work remote, hybrid or onsite in accordance with our Telecommuting Policy. Applicants must reside in Kansas or Missouri or be willing to relocate as a condition of employment.”

What you’ll do

· Serve as the subject matter expert for Underwriting and Group Rating data needs, developing reports and dashboards using Excel, Access, and visualization tools.

· Develop and maintain underwriting databases, ensuring accurate data integration, governance, and reporting standards.

· Construct VBA-based applications and process automation tools to improve underwriting workflow efficiency.

· Collaborate with IT on system enhancements, upgrades, and development projects related to underwriting systems.

· Ensure data integrity by auditing, cleaning, and validating datasets to maintain system performance and structural accuracy.

· Develop and maintain custom rating and reporting formats for special underwriting requests.

· Analyze underwriting data trends to provide insights and recommendations for business decisions.

· Support internal training efforts, educating Underwriting and Group Rating teams on data tools, reporting best practices, and statistical methods.

· Stay current on data, visualization, and analytics trends, applying new knowledge to provide advanced solutions.

· Assist in governance processes, ensuring compliance with regulatory and corporate data standards.

What you need

Education and Experience

· Bachelor's degree in Mathematics, Economics, Computer Science, Information Management, Actuarial Science, Statistics, or a related field.

· Minimum of 3 years of experience in data analytics, database management, or underwriting systems in the health insurance industry.

· Experience with SQL, VBA, Tableau, Power BI, or similar reporting tools required.

· Background in health insurance rating, actuarial modeling, or underwriting processes is a plus.

Knowledge/Skills/Abilities

· Strong data management and database administration skills (SQL, Access, Oracle, etc.).

· Proficiency in Excel, VBA, and automation tools for underwriting applications.

· Experience with data visualization and reporting tools (Tableau, Power BI, etc.).

· Strong problem-solving and analytical skills to assess and enhance underwriting systems.

· Ability to develop and implement data governance policies to maintain system integrity.

· Effective communication skills to present findings and collaborate across teams.

· Strong organizational and time management skills with the ability to manage multiple projects.

· Ability to work independently and develop creative solutions for underwriting system improvements.

Compensation

$85,600 - $107,000

Blue Cross and Blue Shield of Kansas offers excellent competitive compensation with the goal of retaining and growing talented team members. The compensation range for this role is a good faith estimate, it is estimated based on what a successful candidate might be paid. All offers presented to candidates are carefully reviewed to ensure fair, equitable pay by offering competitive wages that align with the individual's skills, education, experience, and training. The range may vary above or below the stated amounts.

Our Commitment to Connection and Belonging

At Blue Cross and Blue Shield of Kansas, we are committed to fostering a culture of connection and belonging, where mutual respect is at the foundation of our workplace. We provide equal employment opportunities to all individuals, regardless of race, color, religion, belief, sex, pregnancy (including childbirth, lactation, and related medical conditions), national origin, age, physical or mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military or veteran status, family or parental status, or any other characteristic protected by applicable law.