Sr Data Analyst
for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Include a section only when posting has real, specific content. So we need to decide which sections to include.
We have:
- Job Description Summary: could be "About the role" maybe. But they said do NOT repeat the job title as a heading. The summary is about role. Could use About the role
with paragraph.
- Essential Responsibilities: could be Responsibilities
with - list.
- Additional Responsibilities: maybe also part of responsibilities; but we could combine? The instruction: prefer few substantive sections over many thin ones. Could merge essential and additional responsibilities into one Responsibilities section. But we need to preserve all substantive info; we can combine them into one list.
- Qualifications / Experience Required: could be
Qualifications
with list.
- Preferred Qualifications: could be Preferred Qualifications
maybe as part of Qualifications? Could be separate but maybe we can combine into Qualifications with subheadings? But only allowed headings are those listed; we could still use Preferred Qualifications
as it's not in the list but maybe allowed? The instruction says use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It gives examples but not exclusive? Likely they expect only those headings. So we should map content to those headings.
Thus:
- About the role: job description summary.
- Responsibilities: essential + additional responsibilities combined.
- Qualifications: qualifications / experience required.
- Skills: maybe we can include proficient in Python/PySpark, SQL, Power BI etc. Could be part of Qualifications but we could make Skills section.
- Benefits: Benefits and Compensation section.
- Pay: pay ranges.
- Schedule: mention "This is a 100% in-office position. Candidates must be able to work on-site at a designated company office during standard business hours." That's schedule info.
- Core Values maybe not a standard heading; could be omitted or put under About the role? Probably we can include as a separate section? Not in list; maybe we can omit as not required. But we need to preserve ALL substantive information; we cannot omit core values. Could we put core values under About the role as extra paragraph? That would preserve. Yes.
Thus we will not create a separate Core Values heading; we'll include it in About the role paragraph.
Now we need to remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, application instructions. The text includes "Please Note Applicants must be legally authorized to work in the United States..." that's legal; we should remove. Also "Benefits And Compensation" we keep as Benefits section. Also "Core Values" we keep as paragraph.
Also need to not include Job ID/requisition numbers.
Now construct HTML.
Structure:
About the role
Company Shared Services Argo and Farm Family are specialty property and casualty insurance brands whose underwriting companies are wholly-owned subsidiaries of Clearbrook Holdings Inc. Argo and Farm Family partner with agents and brokers to provide insurance solutions that enable businesses to manage risks with confidence. Job Description Summary: The Sr Data Analyst partners with stakeholders across P&C Operations (Underwriting, Product, Actuarial, Claims, and Marketing) to deliver advanced analytical insights that inform business strategy and operational decision-making. This role’s responsibility includes performing data analysis (e.g., conceptualization, mining/modeling, and presentation of data) and developing methods to efficiently capture, manage, and analyze data. The position serves as a trusted partner to business leaders by translating complex data into clear, actionable insights and identifying opportunities to improve processes and outcomes. This is a 100% in-office position. Candidates must be able to work on-site at a designated company office during standard business hours. Core Values At Clearbrook our Core Values are Integrity, Collaboration, Pursuit of Excellence and Forward Thinking. These values reflect who we are today and who we aspire to be - guiding how we work, how we lead and how we succeed.
But we separated schedule later; maybe we should keep schedule separate. However we included schedule info in About the role; but we also have a Schedule section. To avoid duplication, we could move schedule info to Schedule section and remove from About the role. Let's do that.
Thus About the role paragraph excludes schedule sentence.
Now Responsibilities: combine essential and additional responsibilities into a list.
We need to preserve each bullet.
Let's list them:
Essential Responsibilities:
- Partners with stakeholders to define business problems, translate data needs into analytical solutions, and ensure alignment between business objectives and data outputs.
- Develops and maintains methods to distribute management information, as appropriate, throughout P&C Operations using tools, standards, and platforms in use at the time with minimal guidance.
- Designs, develops, and maintains dashboards (Power BI), reports, and data products for use throughout P&C Operations using the tools, standards, and platforms in use at the time with minimal guidance.
- Develops and optimizes SQL queries, Python/PySpark scripts, and data pipelines to extract, transform, and validate data for analysis and reporting.
- Independently leads analytics initiatives, managing priorities, timelines, and deliverables from intake through deployment.
- Responds to support questions promptly, courteously, and accurately, with an analysis of the results and any issues or changes made with minimal guidance.
- Synthesizes analytical findings into clear insights and recommendations, tailoring communication for both technical and non-technical audiences.
- Ensure enterprise reporting and analytics adhere to defined data governance standards, business rules, and data quality expectations.
- Validates data accuracy and completeness across source systems and downstream reporting layers, identifying trends, anomalies, and data quality issues.
- Performs quality assurance checks to validate completeness and accuracy of data and/or deliverables for release with minimal guidance.
- Supports recurring operational data needs (e.g., month‑end, quarter‑end, and ongoing production reporting cycles) by ensuring timely, accurate delivery of analytics and reports.
- Identifies trends, patterns, and opportunities within data to support process improvements and strategic initiatives.
Additional Responsibilities:
- Document, update, and utilize the policies, procedures, and processes used throughout P&C Operations.
- Mentor junior analysts by reviewing policies, procedures, and processes and validating the queries/code, reports, and dashboards for accuracy and quality.
- Proactively identify opportunities with the appropriate stakeholders to remedy the errors timely with minimal guidance.
- Ensures that the data produced remains secure, respecting corporate privacy and security procedures.
- Assists with training for stakeholders in areas such as proper data usage, SQL, or Power BI.
- Collaborate with data engineering and platform teams to ensure alignment between analytics solutions and enterprise data platforms (e.g., cloud data warehouses, semantic models, and BI environments).
We'll combine into one - list.
Now Qualifications: list.
Qualifications / Experience Required:
- Four to six years of relevant work experience
- Bachelor’s degree in mathematics, computer science, data science, data analytics, or a related field. Equivalent work experience in a business or technical environment will be considered in lieu of a bachelor’s degree.
- Proficient in Python/PySpark, SQL (CTE, window functions) and Power BI using graphs, charts, and map features.
- Experience in data quality control/governance, data mining, and modeling
- Working knowledge of emerging analytics technology (e.g., Agentic AI/ML concepts)
- Strong soft skills with clear, effective oral and written communication.
Preferred Qualifications:
- Experience in Microsoft Fabric, Snowflake Ecosystem, and Visual Studio Code
- Strong understanding of Property & Casualty insurance data concepts and operational workflows is preferred.
We could put preferred qualifications under Skills or Qualifications. Perhaps we make a Skills section for technical skills: Python/PySpark, SQL, Power BI, etc. But we already have qualifications includes those. Could split: Qualifications for education/experience, Skills for technical proficiencies, Preferred Qualifications separate.
But we need to avoid thin sections. Let's make:
- Qualifications: education/experience.
- Skills: technical proficiencies (Python/PySpark, SQL, Power BI, data quality control/governance, data mining/modeling, emerging analytics tech, soft skills).
- Preferred Qualifications: the two items.
But the instruction says use headings like Skills, Benefits, Pay, Schedule. So we can have Skills section.
Thus:
Qualifications
- Four to six years of relevant work experience
- Bachelor’s degree in mathematics, computer science, data science, data analytics, or a related field. Equivalent work experience in a business or technical environment will be considered in lieu of a bachelor’s degree.
Skills
- Proficient in Python/PySpark, SQL (CTE, window functions) and Power BI using graphs, charts, and map features.
- Experience in data quality control/governance, data mining, and modeling
- Working knowledge of emerging analytics technology (e.g., Agentic AI/ML concepts)
- Strong soft skills with clear, effective oral and written communication.
Preferred Qualifications
- Experience in Microsoft Fabric, Snowflake Ecosystem, and Visual Studio Code
- Strong understanding of Property & Casualty insurance data concepts and operational workflows is preferred.
Now Benefits: we have benefits paragraph.
Benefits
We offer a competitive compensation package, performance-based incentives, and a comprehensive benefits program—including health, dental, vision, 401(k) with company match, paid time off, and professional development opportunities.
Pay: we have pay ranges.
Pay
Omaha & Albany Pay Range $95,000 - $115,000
Chicago Pay Range $103,000 - $133,000
NYC Pay Range $113,000 - $143,000
But we should avoid
maybe use each line. Could use separate
elements. We'll do:
Omaha & Albany Pay Range $95,000 - $115,000
Chicago Pay Range $103,000 - $133,000
NYC Pay Range $113,000 - $143,000
Schedule: we have schedule info.
Schedule
This is a 100% in-office position. Candidates must be able to work on-site at a designated company office during standard business hours.
Now About the role paragraph we need to include job description summary and company description, but not schedule sentence.
Let's craft About the role:
Company Shared Services Argo and Farm Family are specialty property and casualty insurance brands whose underwriting companies are wholly-owned subsidiaries of Clearbrook Holdings Inc. Argo and Farm Family partner with agents and brokers to provide insurance solutions that enable businesses to manage risks with confidence. Job Description Summary: The Sr Data Analyst partners with stakeholders across P&C Operations (Underwriting, Product, Actuarial, Claims, and Marketing) to deliver advanced analytical insights that inform business strategy and operational decision-making. This role’s responsibility includes performing data analysis (e.g., conceptualization, mining/modeling, and presentation of data)
Qualifications
with list. - Preferred Qualifications: could bePreferred Qualifications
maybe as part of Qualifications? Could be separate but maybe we can combine into Qualifications with subheadings? But only allowed headings are those listed; we could still usePreferred Qualifications
as it's not in the list but maybe allowed? The instruction says use for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It gives examples but not exclusive? Likely they expect only those headings. So we should map content to those headings.
Thus:
- About the role: job description summary.
- Responsibilities: essential + additional responsibilities combined.
- Qualifications: qualifications / experience required.
- Skills: maybe we can include proficient in Python/PySpark, SQL, Power BI etc. Could be part of Qualifications but we could make Skills section.
- Benefits: Benefits and Compensation section.
- Pay: pay ranges.
- Schedule: mention "This is a 100% in-office position. Candidates must be able to work on-site at a designated company office during standard business hours." That's schedule info.
- Core Values maybe not a standard heading; could be omitted or put under About the role? Probably we can include as a separate section? Not in list; maybe we can omit as not required. But we need to preserve ALL substantive information; we cannot omit core values. Could we put core values under About the role as extra paragraph? That would preserve. Yes.
Thus we will not create a separate Core Values heading; we'll include it in About the role paragraph.
Now we need to remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, application instructions. The text includes "Please Note Applicants must be legally authorized to work in the United States..." that's legal; we should remove. Also "Benefits And Compensation" we keep as Benefits section. Also "Core Values" we keep as paragraph.
Also need to not include Job ID/requisition numbers.
Now construct HTML.
Structure:
About the role
Company Shared Services Argo and Farm Family are specialty property and casualty insurance brands whose underwriting companies are wholly-owned subsidiaries of Clearbrook Holdings Inc. Argo and Farm Family partner with agents and brokers to provide insurance solutions that enable businesses to manage risks with confidence. Job Description Summary: The Sr Data Analyst partners with stakeholders across P&C Operations (Underwriting, Product, Actuarial, Claims, and Marketing) to deliver advanced analytical insights that inform business strategy and operational decision-making. This role’s responsibility includes performing data analysis (e.g., conceptualization, mining/modeling, and presentation of data) and developing methods to efficiently capture, manage, and analyze data. The position serves as a trusted partner to business leaders by translating complex data into clear, actionable insights and identifying opportunities to improve processes and outcomes. This is a 100% in-office position. Candidates must be able to work on-site at a designated company office during standard business hours. Core Values At Clearbrook our Core Values are Integrity, Collaboration, Pursuit of Excellence and Forward Thinking. These values reflect who we are today and who we aspire to be - guiding how we work, how we lead and how we succeed.
But we separated schedule later; maybe we should keep schedule separate. However we included schedule info in About the role; but we also have a Schedule section. To avoid duplication, we could move schedule info to Schedule section and remove from About the role. Let's do that. Thus About the role paragraph excludes schedule sentence. Now Responsibilities: combine essential and additional responsibilities into a list. We need to preserve each bullet. Let's list them: Essential Responsibilities: - Partners with stakeholders to define business problems, translate data needs into analytical solutions, and ensure alignment between business objectives and data outputs. - Develops and maintains methods to distribute management information, as appropriate, throughout P&C Operations using tools, standards, and platforms in use at the time with minimal guidance. - Designs, develops, and maintains dashboards (Power BI), reports, and data products for use throughout P&C Operations using the tools, standards, and platforms in use at the time with minimal guidance. - Develops and optimizes SQL queries, Python/PySpark scripts, and data pipelines to extract, transform, and validate data for analysis and reporting. - Independently leads analytics initiatives, managing priorities, timelines, and deliverables from intake through deployment. - Responds to support questions promptly, courteously, and accurately, with an analysis of the results and any issues or changes made with minimal guidance. - Synthesizes analytical findings into clear insights and recommendations, tailoring communication for both technical and non-technical audiences. - Ensure enterprise reporting and analytics adhere to defined data governance standards, business rules, and data quality expectations. - Validates data accuracy and completeness across source systems and downstream reporting layers, identifying trends, anomalies, and data quality issues. - Performs quality assurance checks to validate completeness and accuracy of data and/or deliverables for release with minimal guidance. - Supports recurring operational data needs (e.g., month‑end, quarter‑end, and ongoing production reporting cycles) by ensuring timely, accurate delivery of analytics and reports. - Identifies trends, patterns, and opportunities within data to support process improvements and strategic initiatives. Additional Responsibilities: - Document, update, and utilize the policies, procedures, and processes used throughout P&C Operations. - Mentor junior analysts by reviewing policies, procedures, and processes and validating the queries/code, reports, and dashboards for accuracy and quality. - Proactively identify opportunities with the appropriate stakeholders to remedy the errors timely with minimal guidance. - Ensures that the data produced remains secure, respecting corporate privacy and security procedures. - Assists with training for stakeholders in areas such as proper data usage, SQL, or Power BI. - Collaborate with data engineering and platform teams to ensure alignment between analytics solutions and enterprise data platforms (e.g., cloud data warehouses, semantic models, and BI environments). We'll combine into one- list.
Now Qualifications: list.
Qualifications / Experience Required:
- Four to six years of relevant work experience
- Bachelor’s degree in mathematics, computer science, data science, data analytics, or a related field. Equivalent work experience in a business or technical environment will be considered in lieu of a bachelor’s degree.
- Proficient in Python/PySpark, SQL (CTE, window functions) and Power BI using graphs, charts, and map features.
- Experience in data quality control/governance, data mining, and modeling
- Working knowledge of emerging analytics technology (e.g., Agentic AI/ML concepts)
- Strong soft skills with clear, effective oral and written communication.
Preferred Qualifications:
- Experience in Microsoft Fabric, Snowflake Ecosystem, and Visual Studio Code
- Strong understanding of Property & Casualty insurance data concepts and operational workflows is preferred.
We could put preferred qualifications under Skills or Qualifications. Perhaps we make a Skills section for technical skills: Python/PySpark, SQL, Power BI, etc. But we already have qualifications includes those. Could split: Qualifications for education/experience, Skills for technical proficiencies, Preferred Qualifications separate.
But we need to avoid thin sections. Let's make:
- Qualifications: education/experience.
- Skills: technical proficiencies (Python/PySpark, SQL, Power BI, data quality control/governance, data mining/modeling, emerging analytics tech, soft skills).
- Preferred Qualifications: the two items.
But the instruction says use headings like Skills, Benefits, Pay, Schedule. So we can have Skills section.
Thus:
Qualifications
- Four to six years of relevant work experience
- Bachelor’s degree in mathematics, computer science, data science, data analytics, or a related field. Equivalent work experience in a business or technical environment will be considered in lieu of a bachelor’s degree.
Skills
- Proficient in Python/PySpark, SQL (CTE, window functions) and Power BI using graphs, charts, and map features.
- Experience in data quality control/governance, data mining, and modeling
- Working knowledge of emerging analytics technology (e.g., Agentic AI/ML concepts)
- Strong soft skills with clear, effective oral and written communication.
Preferred Qualifications
- Experience in Microsoft Fabric, Snowflake Ecosystem, and Visual Studio Code
- Strong understanding of Property & Casualty insurance data concepts and operational workflows is preferred.
Benefits
We offer a competitive compensation package, performance-based incentives, and a comprehensive benefits program—including health, dental, vision, 401(k) with company match, paid time off, and professional development opportunities.
Pay: we have pay ranges.Pay
Omaha & Albany Pay Range $95,000 - $115,000
But we should avoid
Chicago Pay Range $103,000 - $133,000
NYC Pay Range $113,000 - $143,000
maybe useeach line. Could use separate
elements. We'll do:
Omaha & Albany Pay Range $95,000 - $115,000
Chicago Pay Range $103,000 - $133,000
NYC Pay Range $113,000 - $143,000
Schedule: we have schedule info.Schedule
This is a 100% in-office position. Candidates must be able to work on-site at a designated company office during standard business hours.
Now About the role paragraph we need to include job description summary and company description, but not schedule sentence. Let's craft About the role:Company Shared Services Argo and Farm Family are specialty property and casualty insurance brands whose underwriting companies are wholly-owned subsidiaries of Clearbrook Holdings Inc. Argo and Farm Family partner with agents and brokers to provide insurance solutions that enable businesses to manage risks with confidence. Job Description Summary: The Sr Data Analyst partners with stakeholders across P&C Operations (Underwriting, Product, Actuarial, Claims, and Marketing) to deliver advanced analytical insights that inform business strategy and operational decision-making. This role’s responsibility includes performing data analysis (e.g., conceptualization, mining/modeling, and presentation of data)