Contract Analytics Engineer (São Paulo, Brazil)

Pie Insurance

United States

Remote

USD 90,000 - 150,000

Part time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Pie Insurance is seeking a contract analytics engineering professional to build and maintain Looker models, dashboards, and semantic views. You will model data in Snowflake using SQLDBM, ensuring consistency of metrics across Looker, the warehouse, and AI-driven layers.

The role requires strong SQL, Looker experience, and a passion for data quality. You will collaborate closely with finance, billing, claims, pricing, and underwriting while contributing to on-call incident response and

Qualifications

  • 2+ years as analytics/BI/data engineer.
  • Advanced SQL writing and validation.
  • Looker experience preferred; alternatives considered.

Responsibilities

  • Build and maintain Looker explores, views, and dashboards used by finance, billing, claims, pricing, and underwriting.
  • Model data in Snowflake and SQLDBM, including semantic views, to ensure consistency across Looker and warehouse.
  • Own the accuracy of numbers; reconcile discrepancies and define gaps to meet SOX standards.
  • Turn stakeholder requests into scoped work tracked in Jira, with guidance from senior team members.
  • Collaborate with data engineering via GitHub; monitor data quality in Monte Carlo and participate in on-call incidents.
  • Utilize AI tools to accelerate development and build AI agents that answer business questions atop models.

Skills

Advanced SQL
LookML
Data modeling
Data quality
Strong communicator
English fluency
AI tools usage
SOX knowledge

Tools

Snowflake
SQLDBM
Monte Carlo
GitHub

Job description

Contract Position

Location: Brazil (Remote)

Reports To: Sr. Analytics Engineering Manager

Employment Type: 12-month contract with possibility of extension

Pie’s mission is to empower small businesses to thrive by making commercial insurance affordable and as easy as pie. We leverage technology to transform how small businesses buy and experience commercial insurance.

Like our small business customers, we are a diverse team of builders, dreamers, and entrepreneurs who are driven by core values and operating principles that guide every decision we make.

This is a hands-on analytics engineering role. You will build the Looker models the business actually uses and take modeled data in Snowflake the last mile into explores, dashboards, and trusted numbers. The work sits next to finance, billing, claims, pricing, and underwriting.

How You’ll Do It
  • Build and maintain the Looker explores, views, and dashboards that finance, billing, claims, pricing, and underwriting rely on.
  • Model the data behind them in Snowflake and SQLDBM, including semantic views, to the team’s standards so a metric means the same thing in Looker, in the warehouse, and in the AI agents built on top of them.
  • Own the accuracy of the numbers: reconcile discrepancies, close definition gaps in the model, and meet SOX change standards on finance reporting.
  • Turn stakeholder requests into scoped work tracked in Jira, with guidance from senior team members, and flag requirements that leave gaps.
  • Partner with data engineering through GitHub, monitor data quality in Monte Carlo, and join the on-call rotation, responding to incidents and tracing root cause.
  • Use AI tools for efficient development, help build the AI agents that answer business questions on top of our models, and stay accountable for whether the number is right.
The Right Stuff
  • 2+ years as an analytics engineer, BI engineer, or analytics-focused data engineer.
  • Advanced experience writing, optimizing and validating SQL queries.
  • Experience with Looker (including LookML development) is strongly preferred. Candidates with strong, hands-on experience in other leading BI/visualization platforms such as Power BI or Tableau will also be considered.
  • Experience modeling data for consumption, such as marts, semantic views, or dimensional models.
  • Proven ability to translate business requirements into clear, scalable, and well-governed reporting/visualization solutions.
  • Genuine passion for data quality — proactively identifying, troubleshooting, and resolving data issues, and implementing checks/monitoring that build organizational trust in the data.
  • Strong communicator who can clearly explain data quality findings and build confidence in reporting across technical and non-technical stakeholders.
  • Insurance and/or financial data experience preferred. SOX or audit familiarity strongly preferred. Willingness to learn the domain required.
  • Daily use of AI tools in development, with the habit of checking what they write. Experience building AI agents or Python is a plus.
  • Fluent written and spoken English, with at least four hours of daily overlap with US business hours.

The use of AI in Application Review: To support a fair, efficient, and consistent hiring process, we use AI-powered tools to assist in the initial screening of applications. These tools help us identify qualifications and prior work experiences that align with the requirements of the role. All AI-reviewed applications are still subject to human oversight and decision-making at multiple stages of the process. By submitting your application, you acknowledge and consent to Pie utilizing these AI technologies to assist in our evaluation process.

About Pie Insurance

Pie Insurance is a technology-driven small business insurance company focused on making commercial insurance simpler, smarter, and more affordable. Our Analytics Engineering team sits at the intersection of technology and business operations, and this role is a critical part of how we scale.

This is a contract role. The position is fully remote and based in Brazil. Candidates must be authorized to work as contractors in Brazil.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Contract Analytics Engineer (São Paulo, Brazil)
Contract Analytics Engineer (São Paulo, Brazil)

Pie Insurance - Contracts • United States

Remote
USD 31,000 - 49,000
Contract Analytics Engineer (São Paulo, Brazil)
Contract Analytics Engineer (São Paulo, Brazil)

pieinsuranceinternationalcontracts • United States

Remote
USD 90,000 - 130,000
Remote Contract Analytics Engineer: Looker & Snowflake
Remote Contract Analytics Engineer: Looker & Snowflake

Pie Insurance - Contracts • United States

Remote
USD 31,000 - 49,000
Remote Contract Analytics Engineer – Looker, SQL & Data Quality
Remote Contract Analytics Engineer – Looker, SQL & Data Quality

pieinsuranceinternationalcontracts • United States

Remote
USD 90,000 - 130,000
Contract Recruiter (Remote, Mexico)
Contract Recruiter (Remote, Mexico)

Pie Insurance • United States

Remote
USD 48,000 - 83,000
Contract Recruiter (Remote, Colombia)
Contract Recruiter (Remote, Colombia)

Pie Insurance • United States

Remote
USD 55,000 - 96,000
Senior Contract Recruiter (Remote, Colombia)
Senior Contract Recruiter (Remote, Colombia)

Pie Insurance • United States

Remote
USD 55,000 - 96,000
GAAP Accountant
GAAP Accountant

pieinsurance • United States

Remote
USD 65,000 - 80,000
Health plans
Generous PTO
401(k) match
+1
GAAP Accountant
GAAP Accountant

Remote • San Francisco (CA)

Remote
USD 65,000 - 80,000
Competitive cash compensation
Generous PTO
Future-focused 401k match
+1
Premium Auditor I
Premium Auditor I

Risk Hub • United States

Remote
USD 55,000 - 70,000
Competitive cash compensation
Comprehensive health plans
Generous PTO
+2