Operations and Data Quality Analyst
Indexed description
Responsibilities
- Develop and maintain a comprehensive understanding of production job dependencies, data flows, and scheduling across the Snowflake data platform.
- Build, document, and maintain operational run books covering routine processes, job recovery procedures, escalation paths, and incident response.
- Monitor production data pipelines and batch processes; triage failures, coordinate resolution, and communicate status to stakeholders — helping establish the operational standards, SLAs, and incident management processes for a new Data Operations pillar.
- Own the Monte Carlo Data Observability Platform — including configuration, administration, and adoption — and design and build a comprehensive data quality suite with monitors for freshness, volume, schema changes, and field-level anomalies across critical data domains.
- Define data quality rules, thresholds, and alerting workflows; establish data quality SLAs and scorecards, and report on data health to Data Engineering leadership and business stakeholders.
- Perform data validation at both the intake (Snowflake ingestion) and output (downstream delivery) stages to ensure accuracy, completeness, and integrity.
- Develop and execute data quality checks, reconciliation routines, and exception reports to identify and resolve discrepancies; serve as the data quality owner for assigned data domains, documenting findings and partnering with Data Engineering to resolve root causes.
- Validate bordereau data received from MGAs/Program Administrators against expected schemas, field requirements, and business rules.
- Design, build, and maintain multi-layered dashboards, KPI reports, and ad-hoc analyses to support Finance, Operations, and Leadership; perform quantitative and statistical analysis to surface trends, anomalies, and business insights.
- Contribute to monthly, quarterly, and annual financial close processes by validating data and producing supporting schedules.
- Partner closely with Data Engineers to define, test, and validate data pipelines — providing business context and analytical perspective that engineers may not have.
- Participate in requirements gathering and UAT for new data integrations, system enhancements, and reporting solutions; understand system capabilities across Snowflake and reporting platforms to design queries and outputs optimized for performance and usability.
- Build and maintain positive working relationships with internal customers in Finance, Premium Operations, Underwriting, IT, and Actuarial; handle escalations, assess data or reporting issues, and implement corrective action as needed.
- Identify opportunities for process improvement and automation; document current-state processes and propose enhanced workflows.
- B.S. in Data Analytics, Information Systems, Computer Science, Finance, Business, or equivalent required.
- Minimum of 3 years of experience in data analysis, data quality, data operations, or a related analytical role.
- Strong command of SQL, including complex queries, joins, window functions, and stored procedures against large datasets.
- Hands-on experience with data validation, reconciliation, and exception reporting processes.
- Experience monitoring production data pipelines and supporting operational processes — troubleshooting job failures, managing escalations, and documenting procedures such as run books.
- Strong analytical and problem-solving skills, with the ability to trace data issues to root cause across multiple systems.
- Hands-on experience with a data observability or data quality platform such as Monte Carlo (strongly preferred), Great Expectations, Soda, or similar.
- Experience with Snowflake (data ingestion, tasks, streams, and query optimization) a plus.
- Insurance industry experience — particularly P&C, specialty insurance, or warranty programs — including familiarity with bordereau data and MGA/Program Administrator relationships a plus.
- Familiarity with data pipeline orchestration and transformation tools (e.g., dbt, Airflow, or comparable scheduling tools) preferred.
- Experience with BI and reporting tools (e.g., Power BI, Tableau, or similar) preferred.
- Exposure to financial close processes and producing supporting schedules for Finance and Accounting preferred.
- Excellent verbal, written, and interpersonal communication skills, with the ability to articulate data issues and findings to both technical and business audiences.
- High attention to detail and a commitment to data accuracy and integrity, with a strong customer focus, ownership, and urgency.
Additional Information
Full benefit package including medical, dental, life, vision, company paid short/long term disability, 401(k), tuition assistance and more
Job Posting Disclaimer
Fortegra has recently been made aware of unauthorized communications regarding career opportunities by individuals not associated with Fortegra or our recruitment team. Fortegra will only contact you from the Fortegra domain address (@fortegra.com). If you receive a message from someone posing as a Fortegra recruiter via text message, WhatsApp, Telegram or other messaging platform, please report it as phishing and block the sender.
Fortegra is not accepting unsolicited resumes from search firms for this position.
Internal Notice: As part of our commitment to talent development, this position is open for internal promotion applications at the time of public posting.
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search