Underwriting Database Management Specialist

bcbsks; Kansas; Hybrid; USD 86,000 - 107,000; Full time

Benefits offered by this job

Incentive pay program (EPIP)

Health/Vision/Dental insurance

6 weeks paid parental leave

Fertility/Adoption assistance

2 weeks paid caregiver leave

401(k) plan matching up to 5%

Tuition reimbursement

Health & fitness benefits, discounts

Job summary

Blue Cross and Blue Shield of Kansas seeks an Underwriting Database Management Specialist to extract, import, and link data across sources, assuring accuracy of underwriting tools and driving reporting improvements.

Responsibilities include developing durable data reports, automations in VBA, and collaborating with IT on system enhancements. Remote, hybrid or onsite work is eligible for this Kansas-based role.

Qualifications

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

Responsibilities

• Serve as SME for Underwriting and Group Rating data needs, building reports/dashboards with Excel, Access, and visualization tools.
• Develop/maintain underwriting databases with accurate data integration, governance, and reporting standards.
• Create VBA-based apps and automation to improve underwriting workflow efficiency.
• Collaborate with IT on system enhancements, upgrades, and underwriting project development.
• Ensure data integrity through auditing, cleaning, and validating datasets.
• Develop/maintain custom rating and reporting formats for special requests.
• Analyze underwriting data trends to provide insights for business decisions.
• Support internal training on data tools, reporting, and statistical methods.
• Stay current on data visualization/analytics trends and apply new knowledge.
• Assist governance processes, ensuring regulatory and corporate data standards compliance.

Skills

Data analytics

Data governance

Problem solving

Communication

Education

Bachelor's degree (Math, Econ, CS, Info Mgmt, Act Sci, Stats)

Tools

SQL

Access

Oracle

Excel

VBA

Tableau

Power BI

Job description

Are you ready to make a difference? Choose to work for one of the most trusted companies in Kansas.

You Belong At Blue

Why Join Us?

• 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.

Benefits & Perks

• Base compensation is only one component of your competitive Total Rewards package
  • Incentive pay program (EPIP)
  • Health/Vision/Dental insurance
  • 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%
  • Tuition reimbursement
  • 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

Exempt Grade 16

• 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), 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.

Blue Cross and Blue Shield of Kansas conducts pre-employment drug screening, criminal conviction check, employment verifications and education as part of a conditional offer of employment.