Analytics Engineer

Sonsio Vehicle Protection

Analytics Engineer responsible for data engineering and business analytics related to vehicle protection. Designing reports and dashboards while migrating legacy systems to cloud solutions.

Posted 4/15/2026full-timeRemote • Colorado • 🇺🇸 United StatesMid-LevelSenior💰 $115,000 - $130,000 per yearWebsite

Tech Stack

Tools & technologies

RPASQLSSIS

About the role

Key responsibilities & impact

Maintain, create and enhance existing SSRS reports as part of ongoing legacy support, with an active role in migrating high-value SSRS content to Power BI.
Design, build, and maintain Power BI reports and semantic models supporting Finance, Claims, Operations, and Executive reporting requirements.
Write DAX measures and calculated columns that implement agreed-upon business logic; document metric definitions so they are not dependent on tribal knowledge.
Translate business reporting requirements into scalable Power BI solutions, including incremental refresh strategies, row-level security, and workspace/deployment pipeline governance.
Support UAT cycles, partner-facing reporting validation, and audit reviews by verifying report output against source data and defined calculation logic.
Write and optimize complex SQL across SQL Server and Snowflake, including CTEs, window functions, and query performance tuning against large claims and financial datasets.
Develop and maintain semantic models in Power BI or Snowflake that enforce consistent metric definitions across reports and teams.
Investigate and resolve data discrepancies across environments by tracing issues back to source system ingestion, transformation logic, or pipeline failures.
Build, maintain, and enhance SSIS packages and data pipelines that move data between source systems, SQL Server, and Snowflake to support reporting workflows.
Troubleshoot and resolve pipeline failures that impact reporting delivery; implement alerting and logging so failures are detected before stakeholders are affected.
Maintain and improve existing SSIS processes as part of ongoing reporting evolution.
Partner directly with Finance, Claims, Operations, and Risk teams to scope reporting requirements, validate output accuracy, and resolve metric disagreements before they reach production.
Work alongside Data Engineering to align data availability, schema changes, and pipeline dependencies that affect downstream reporting; flag upstream data quality issues when discovered.
Maintain a data dictionary and report documentation that allows any team member or auditor to verify what a report measures, how it is calculated, and where the data originates.

Requirements

What you’ll need

Bachelor’s Degree preferred; equivalent experience accepted.
4+ years in Business Intelligence, analytics engineering, or data-intensive reporting roles.
Preferred background in insurance, F&I, automotive, claims, or similarly regulated or financially sensitive industries where reporting accuracy is critical.
Experience supporting Finance, Claims, or other regulated business functions where data accuracy has direct financial, compliance, or audit implications.
Exposure to financial close processes, regulatory reporting, or external audit support, including documented and traceable data lineage.
Advanced proficiency in SQL across SQL Server (T‑SQL) and Snowflake, including query optimization, window functions, and data modeling/schema design.
Hands‑on experience developing, publishing, and maintaining Power BI reports and datasets, including strong DAX development and semantic model design.
Experience designing, developing, and troubleshooting SSIS packages in a production reporting environment.
Working Knowledge of Snowflake features such as clustering keys, materialized views, dynamic data masking, and cost/ performance monitoring preferred.
Proven ability to manage multiple concurrent reporting deliverables across diverse business stakeholders while maintaining high standards of data accuracy and reliability.
Demonstrated attention to detail, data validation, and reconciliation in environments with material financial or regulatory risk.
Exposure to analytics modernization initiatives, automation, or RPA in support of scalable, repeatable reporting solutions preferred.

Benefits

Comp & perks

paid time off
medical
dental
vision
401k match (50% on the dollar up to 7% of employee contribution)

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

SSRSPower BIDAXSQLSnowflakeSSISdata modelingquery optimizationdata validationreport documentation

Soft Skills

attention to detaildata accuracystakeholder managementproblem-solvingcommunicationcollaborationorganizational skillsanalytical thinkingtime managementadaptability