Technical Specialist

Technical Analyst (TA)

insurance processes and technical solutions

SQL expertise, data mapping skills, and experience with APIs, JSON, XML, and insurance-specific systems

Key Responsibilities

• Data Mapping for Forms & Raters
• Map backend database fields to front-end user interfaces to ensure accurate data display.
• Configure digital insurance forms (applications, dec pages, endorsements, claims, schedules of locations, coverage summaries).
• Integrate raters with underwriting systems via APIs, XML, and spreadsheet mapping.
• Ensure rating outputs (e.g., premiums) reflect correct calculations and business logic.
• Writing SQL Reports, Quote Covers, & Validations
• Develop and optimize SQL reports (e.g., BDX reports, renewal reports, loss runs, underwriting performance, compliance audits).
• Build and automate Quote Covers, ensuring accurate data extraction, rating logic, and business rule application.
• Configure validations to enforce business rules in underwriting platforms, reducing errors and improving data accuracy.
• Configuring & Optimizing Underwriting Platforms (C1/Other)
• Set up and configure system components (user-defined tables, corresponding templates, invoice/check documents, workflows).
• Troubleshoot and optimize system performance (e.g., speeding up slow reports, fixing data flow issues).
• Collaborate with stakeholders to align configurations with underwriting and compliance needs.
• API, JSON, and XML Integration
• Integrate underwriting systems with external APIs (e.g., driving records, risk assessment tools, carrier services).
• Structure and transform data in JSON/XML for smooth communication between systems.
• Manage third-party integrations to ensure seamless system connectivity and data accuracy.
  

Tools & Technologies

• SQL & SSMS (SQL Server Management Studio) – for queries, stored procedures, validations, and reporting.
• Adobe Acrobat Pro – for form design and field alignment.
• Infomaker (PowerBuilder) – for reporting, form development, and front-end data mapping.
• Mapping Utility Tools & Excel – for spreadsheet rating mapping and integration.
• APIs (REST/SOAP) – for external integrations using JSON and XML formats.
  

Collaboration & Workflow

• Work with Business Analysts (BAs) to translate business requirements into technical specifications.
• Collaborate with Quality Assurance (QAs) to test and refine system outputs, resolving bugs or issues.
• Partner with Developers when deeper coding or new feature development is required.
  

Qualifications

• Strong proficiency in SQL, data mapping, and reporting.
• Hands-on experience with underwriting systems (ConceptOne or similar).
• Familiarity with insurance processes (policy issuance, endorsements, raters, claims, reporting).
• Experience with APIs, JSON, XML, and system integrations.
• Problem-solving mindset with ability to troubleshoot and optimize workflows.
• Strong communication skills, capable of bridging technical and business perspectives.
  

Why Join Us?

engineer of clarity

critical function that transforms technology into operational performance