Business System Analyst

Title: Business System Analyst - Commercial Insurance

HYBRID - Richmond VA Only W2 – No Corp to Corp Open to Sponsorship

We are looking for a Data BSA with strong hands-on SQL and data analysis skills who can bridge business requirements and technical data solutions. The candidate should be able to understand complex data, translate requirements into detailed mappings and technical specifications, and leverage Generative AI tools to accelerate analysis, documentation, and prototyping.

Key Responsibilities

• Gather and translate business requirements into data and technical requirements.
• Use SQL to analyze source data, understand data relationships, validate business rules, and troubleshoot data issues.
• Develop source-to-target mapping documents, transformation rules, and data specifications.
• Work closely with Data Engineers and Architects to clarify requirements and support implementation.
• Leverage GenAI/Copilot tools to:
• Convert requirements into SQL, pseudo-code, or semi-code prototypes.
• Generate and enhance source-to-target mappings.
• Analyze existing SQL and transformation logic.
• Accelerate technical documentation and requirements analysis.
• Validate AI-generated outputs against actual data and business requirements.

Required Skills

• Strong hands-on SQL and data analysis skills.
• Strong understanding of data models, ETL/ELT, data integration, and data warehousing.
• Experience creating source-to-target mappings and transformation specifications.
• Ability to translate business requirements into implementation-ready technical artifacts.
• Hands-on experience using GenAI tools for SQL/code generation, documentation, mapping, or prototyping.
• Strong communication and analytical/problem-solving skills.
• Insurance domain experience, preferably with Policy, Claims, Billing, Underwriting, or insurance reporting/data.

Good to have but not required

• Experience with SQL Server, Databricks, Azure and/or Power BI