Jobs · Finance

Underwriting Database Management Specialist

Blue Cross and Blue Shield of Kansas · Topeka, KS · 1 mo ago
Finance$86k/yrFull-time
We need to output HTML fragment with headings

for sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real content. We need to parse the posting. Content: - Intro: "Are you ready to make a difference? Choose to work for one of the most trusted companies in Kansas." etc. This is marketing fluff. Could be considered "About the role"? Possibly "About the role" could be the job summary? The posting includes "Job Summary" paragraph. So we can have "About the role" maybe using that summary. But we need to follow instruction: Use

for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can decide which sections to include based on content. We have: - Job Summary: description of role. Could map to "About the role" or "Job Summary". Since they gave example headings, we can use "About the role" for a brief description. - Responsibilities: The "What you'll do" bullet list. - Requirements: Education and Experience (maybe "Requirements"). - Qualifications: maybe "Qualifications" could be same as Requirements? But we can separate: "Education And Experience" as Requirements, and "Knowledge/Skills/Abilities" as Skills. - Benefits: The "Benefits & Perks" list. - Pay: The compensation range. - Schedule: Not mentioned explicitly; there is remote/hybrid/onsite eligibility but not schedule details. So we should not include Schedule unless there is real content. The posting mentions remote/hybrid/onsite eligibility but not schedule like full-time, part-time, shift. So we should omit Schedule. - Also there is "Inclusive Work Environment" etc but those are fluff; we could include under "About the role" maybe but not needed. We must preserve all substantive information; do not invent or summarize away detail. So we need to include all bullet points from Benefits, Responsibilities, Requirements, Knowledge/Skills/Abilities, etc. We must not repeat job title as heading; we don't have title. We must not put Job ID/requisition numbers as headings; we can drop them. We must remove boilerplate: cookie/navigation/legal/EEO etc. Not present. We must not include duplicated lines. We must output only HTML fragment, no /, no markdown fences. Thus produce something like:

About the role

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.

Responsibilities

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

Requirements

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.

Skills

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

Benefits

  • 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

Pay

$85,600 - $107,000

We should not include Schedule. Check for any duplicated lines: none. Check that we preserved all substantive info: The intro fluff about "Are you ready to make a difference? Choose to work for one of the most trusted companies in Kansas." etc. We omitted that; is that substantive? It's marketing fluff but maybe considered part of "About the role". However we already have About the role using the Job Summary. The marketing fluff could be considered part of About the role as well. But we might incorporate it into About the role paragraph. The instruction: "Preserve ALL substantive information; do NOT invent or summarize away detail." The marketing fluff may be considered substantive? It's not essential job details but it's part of posting. However we could include it in About the role as a brief intro. But we already have About the role paragraph from Job Summary. We could prepend the marketing sentences. Let's see: The posting starts: "This job was posted by https://www.kansasworks.com : For more information, please see: https://www.kansasworks.com/jobs/13667904 **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." That's a lot of marketing fluff. It could be considered part of "About the role" or maybe we could create a section "About the company" but not in allowed headings. The allowed headings list includes About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we should fit that fluff into About the role. So we need to include that content in About the role paragraph. Thus About the role should combine the marketing fluff and the Job Summary. Let's craft a paragraph that includes all that info without inventing or summarizing away detail. We need to preserve all substantive information; we can combine sentences but must not omit details. Let's list the details: - 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. - 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." We need to preserve all that. We can combine into a paragraph, but we must not lose any detail. Let's write a paragraph that includes all those points as sentences. Potential paragraph:

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

That seems to preserve all. Now check other sections: Responsibilities we have list; ensure we captured all bullet points from "What you'll do". Let's verify: Original "What you'll do" bullets: - Serve as the subject matter expert

Similar jobs