Business Systems Analyst

About this role

The Role

We are seeking a highly technical Business Systems Analyst to support the onboarding, transformation, and validation of external data sources into our legacy database environment. This role is hands-on and data-driven, requiring strong analytical skills, a solid understanding of data structures, and close collaboration with product stakeholders and developers.

The BSA plays a key role in evaluating new data feeds, defining ingestion and transformation requirements, standardizing source data to internal formats, and ensuring integrated data is accurate, complete, and ready for use by our insurance products.

What You’ll Do

1. External Data Source Analysis & Integration

• Assess new data sources to understand structure, quality, completeness, and alignment with internal standards and product requirements.
• Work with cross-functional partners to understand acquisition constraints, delivery formats, schedules, and long‑term viability.
• Define functional specifications for extraction and ingestion workflows, including data gathering, file merges, source‑to‑target mappings, normalization rules, and required transformations.
• Collaborate with developers to design, refine, and support these ETL/ELT components.
• Maintain lookup tables, mapping logic, and configurations to align source values with internal defined codes.

2. Data Validation & Quality Assurance

• Validate ingested data in lower environments to confirm correct transformations, consistent formatting, and adherence to technical and business requirements.
• Use SQL to investigate and troubleshoot data discrepancies, unmapped values, anomalies, and processing issues across ingestion and transformation layers.
• Analyze data completeness by matching and comparing new data sources against internal datasets to confirm expected jurisdictional representation.
• Identify and escalate issues such as incomplete data, mapping gaps, unexpected variances, extraction, or transformation failure...