Business Systems Analyst

Solera, Inc.

Business Systems Analyst role at Solera focusing on external data sources and validation. Collaborating closely with stakeholders to ensure accurate and complete data integration.

Posted 6/4/2026full-timeRemote • Minnesota • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

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.
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.
Coordinate deployments of new data pipelines and perform post-production monitoring to ensure stability, accuracy, and consistency in partnership with QA.
Partner with Product Owners to prioritize onboarding activities, communicate timelines, and understand business expectations.
Document data source characteristics, field definitions, transformation logic, mapping decisions, validation outcomes, and configuration details.

Requirements

What you’ll need

5+ years as a Business Systems Analyst, Data Analyst, or similar technical, data-focused role.
Strong SQL skills and experience working with relational databases.
Experience analyzing raw data and defining transformation requirements for system-ready outputs.
Ability to troubleshoot complex data issues, identify root causes, and recommend solutions.
Strong analytical thinking, documentation skills, and attention to detail.
Proven ability to collaborate with both technical and non-technical stakeholders.
Experience working in Agile environments.

Benefits

Comp & perks

Health insurance
401(k) matching
Paid time off
Flexible work arrangements
Professional development opportunities

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLETLELTdata analysisdata transformationdata validationrelational databasesdata mappingdata ingestiondata normalization

Soft Skills

analytical thinkingdocumentation skillsattention to detailcollaborationtroubleshootingcommunicationproblem-solvingstakeholder managementprioritizationadaptability