Database architect Jobs in Madison, WI

Lead Solutions Architect Location:

• Hybrid (Madison, WI preferred; open to remote candidates) Department: Technology Type: Full Time, Exempt Experience Level: Senior / Lead Individual Contributor Are you passionate about building the systems that make insurance work?
• Do you think naturally about loss ratio, endorsements, filings, and reporting, and how small system decisions can have outsized downstream financial or regulatory consequences?
• Understory is looking for an Lead Solutions Architect to own the design, specification, and evolution of our policy administration systems.
• This role sits at the center of underwriting, actuarial, reporting, and technology, and is responsible for ensuring our systems behave correctly across the full policy lifecycle - not just at issuance, but months or years later when audits, bordereaux, and financial reconciliation occur.
• This role operates at the intersection of deep insurance expertise and hands-on system delivery.
• You will be expected to think rigorously about insurance mechanics, express them clearly in specifications, actively partner with engineers through implementation, and use modern tooling to accelerate analysis and documentation without compromising correctness.
• This is not a general product role.
• It is a s ystems leadership role for someone who understands property & casualty insurance deeply and can translate that understanding into durable, auditable software behavior.
• Your Main Role Responsibilities Will Include Own the design and evolution of Understory’s policy administration systems as core financial and regulatory infrastructure, including evaluating build vs. buy decisions and leading the selection, integration, customization, and long-term ownership of off-the-shelf insurance solutions when appropriate.
• Ensure policy data supports accurate loss ratio measurement, carrier reporting, bordereaux, reserves, and reinsurance analysis.
• Design system workflows that correctly handle endorsements, mid-term changes, cancellations, renewals, reinstatements, and historical policy reconstruction.
• Anticipate and resolve edge cases that surface downstream through audits, reporting discrepancies, or financial close.
• Partner directly with actuarial and underwriting teams to translate risk and pricing considerations into system behavior.
• Work closely with software engineers to break down complex insurance problems into buildable, testable components.
• Provide technical and domain leadership to engineers to ensure implementations align with insurance reality, not just clean abstractions.
• Ensure systems are designed with auditability, traceability, and long-term correctness in mind.
• You’re Exactly the Person We’re Looking For If You We are looking for someone who can combine deep insurance judgment with modern technical leverage to reason about complex systems at scale.
• Have deep experience with property & casualty insurance systems and policy lifecycles across multiple products.
• Understand how policy data, pricing, and endorsements flow through filings, reporting, reserves, and reinsurance.
• Have worked closely with actuaries and underwriters and are comfortable discussing loss ratio drivers, pricing mechanics, and risk tradeoffs.
• Have implemented or integrated off-the-shelf insurance or policy administration systems and have lived through the downstream audits, bordereaux reconciliation, or reporting corrections that reveal where those systems succeed and where they fall short.
• Have experience onboarding new carriers or insurance partners and can speak fluently to their system, reporting, and data expectations.
• Have moved quickly to support new insurance products while maintaining system integrity and regulatory correctness.
• Can write clear, unambiguous specifications that engineers trust and enjoy building from.
• Are comfortable leading and guiding software engineers through complex, insurance-driven system design decisions.
• Are pragmatic, opinionated, and comfortable operating in a fast-moving startup environment.
• Have used modern technical tools, including AI, to efficiently specify and evolve insurance systems while keeping the focus on insurance behavior and correctness.
• Compensation Includes Base salary commensurate with experience.
• Full-time benefits.
• About Understory Understory is a leading provider of insurance solutions built for the era of climate change.
• The company's global network of Dot weather stations powers the world's most sophisticated weather risk model.
• By combining mutualized, optimized risk structures with precision weather technology and modeling, Understory develops affordable, stable property insurance solutions.
• Traditional insurance is no longer fit for purpose.
• Natural catastrophes driven by the volatility of climate change are increasing rates and restricting coverage.
• Insurance and reinsurance companies are pulling out and leaving 76% of global assets unprotected.
• Transformation is inevitable and it’s coming to the global property insurance market.
• Understory cracked the code, and our approach is the only way to close this gap.
• Comprising a compact yet fiercely dedicated and passionate team, Understory is a mission-centric, results-driven startup that thrives on adaptability and resilience.
• We cherish accountability and push the limits at breakneck speeds, always backed by the unwavering support of our colleagues.
• To sustain our drive, we place significant emphasis on work-life harmony, nurturing our families, and fostering our communities.
• Headquartered in Madison, Wisconsin, Understory is poised to rewrite the story of insurance. Powered by JazzHR