Analytics Engineer

Who We Are

With a comprehensive lineup of Vehicle Protection plans, Sonsio offers industry-leading programs that cover Tire Road Hazard Protection, Appearance, Parts & Labor Warranties, Mechanical Advisory, and other critical consumer services. These benefits provide vehicle owners with affordable and valuable coverages to keep their vehicles on the road safely, and also maximize the resale value by keeping the appearance of their vehicles like-new.

Sonsio Vehicle Protection is committed to innovation and excellent customer service. Since our inception in 1984, Sonsio has been a leader in the automotive industry—serving more than 74,000 dealerships, F&I service providers, manufacturers, insurance companies, parts suppliers, retail chains, and many independent retailers across all 50 states, Canada, and Puerto Rico.

We understand the challenges and complexities that our partners face when it comes to offering vehicle protection plans. There is no one-size-fits-all. Every business we help is different and has their own set of challenges. That’s why, when you partner with Sonsio, we work with you to provide a custom solution designed to improve customer acquisition and retention and increase profitability.

And when it comes to managing claims, you don’t have the time or resources to worry about the headaches. Sonsio provides end-to-end support and decades of expertise to give customers the highest quality services with a world-class customer experience.

Base Pay Range:

The Analytics Engineer plays a critical role in delivering accurate, timely, and trusted reporting and analytics across Finance, Risk, Claims, Operations, and Executive teams. This role operates at the intersection of data engineering and business analytics—translating complex business questions into trusted, production-grade reporting solutions while actively contributing to the organization’s migration from legacy SQL Server tooling to a modern, cloud-native analytics stack anchored in Snowflake.

You will design, build, and support SSRS reports, Power BI dashboards, SQL-based data models, and SSIS packages that enable reporting workflows. You will serve as a peer to the Data Engineering function—not a consumer of it—and are expected to challenge data quality issues at the source, define metric logic the business can rely on, and deliver analytics that do not require a follow-up explanation.

As an Analytics Engineer, your essential job functions will include the following:

Reporting & Visualization

• 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.

SQL & Data Modeling

• 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.
• Implement financial and claims business logic transformations at the data model layer so that report logic is not duplicated across individual reports.
• Investigate and resolve data discrepancies across environments by tracing issues back to source system ingestion, transformation logic, or pipeline failures.

Data Pipeline & Orchestration

• 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.

Cross‑Functional Collaboration

• 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.

Other Duties as Assigned

Competencies Required

• Strategic Thinking
• Attention to Detail
• Prioritization
• Adaptability
• Communication
• Diagnostic & Troubleshooting Skills
• Results-Oriented
• Trusted Partner Mindset

Position Requirements

• 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.

Physical Job Requirements

• Continuous viewing from and inputting data to a computer screen
• Sitting for long periods of time

Drug Policy

• Sonsio is a drug-free environment.  All applicants being considered for employment must pass a pre-employment background check and drug screening before beginning work.

This position is targeted to be closed on:

Why Sonsio: An amazing opportunity to join a growing organization, built on the efforts of hard working, innovative, and team-oriented people. The compensation offered for this position will depend on qualifications, experience, and geographic location. The total compensation package may also include commission, bonus or profit sharing. We offer a competitive & comprehensive benefit package including: paid time off, medical, dental, vision, and 401k match (50% on the dollar up to 7% of employee contribution). For more information on our benefit offerings, please visit our Dealer Tire Family of Companies Benefits Highlights Booklet.

EOE Statement: Sonsio is an Equal Employment Opportunity (EEO) employer and does not discriminate on the basis of race, color, national origin, religion, gender, age, veteran status, political affiliation, sexual orientation, marital status or disability (in compliance with the Americans with Disabilities Act*), or any other legally protected status, with respect to employment opportunities. 

*ADA Disclosure: Any candidate who feels that they may need an accommodation to complete this application, or any portions of same, based on the impact of a disability should contact Sonsio’s Human Resources Department to discuss your specific needs. Please feel free to contact us at 1-800-933-2537 x6550.