Operations and Data Quality Analyst

Operations and Data Quality Analyst

Job Description

We are looking for an Operations and Data Quality Analyst to join our Data Engineering team. As an Operations and Data Quality Analyst, you will help lay the foundation for a Data Operations pillar within Data Engineering — developing a deep understanding of production job dependencies across our Snowflake data platform, building operational run books, and establishing the monitoring and incident management practices that keep production data reliable. You will own the Monte Carlo Data Observability Platform, building and maturing a comprehensive data quality suite that proactively detects issues before they reach downstream consumers, and will serve as the data quality owner for the team. As part of a high-performing team working on mission-critical data with visibility across the organization, you will develop critical insight into the company and support every function of the business, taking ownership of data quality and treating data as a product.

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.

The above cited duties and responsibilities describe the general nature and level of work performed by people assigned to the job. They are not intended to be an exhaustive list of all the duties and responsibilities that an incumbent may be expected or asked to perform.

Qualifications

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