Contract Analytics Engineer (São Paulo, Brazil)

Pie Insurance - Contracts

United States

Remote

USD 31,000 - 49,000

Full 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 an analytics engineer for a 12-month contract, remote in Brazil. You will build Looker models and carry data from Snowflake into explores and dashboards to provide trusted numbers across finance, billing, and underwriting.

The ideal candidate has 2+ years in analytics engineering, strong SQL and LookML skills, and experience with BI platforms. You will collaborate with data engineering, support SOX controls, and use AI tools to accelerate development.

Qualifications

  • 2+ years as an analytics engineer or BI engineer.
  • Strong SQL writing, optimization and validation skills.
  • Excellent data quality mindset and troubleshooting abilities.
  • Ability to translate business requirements into clear reporting solutions.
  • Experience with documenting and governance (SOX) is a plus.

Responsibilities

  • Build and maintain Looker explores, views, and dashboards used by finance, billing, claims, pricing, and underwriting.
  • Model data in Snowflake and SQLDBM, ensuring consistent metrics across platforms.
  • Own data accuracy, reconcile discrepancies, and close definition gaps in the model.
  • Translate stakeholder requests into scoped work tracked in Jira with guidance from senior teammates.
  • Collaborate with data engineering via GitHub; monitor data quality and participate in on-call rotations.

Skills

SQL proficiency
Communication
English fluency

Tools

Looker LookML
Power BI
Tableau

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.

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 • United States

Remote
USD 90,000 - 150,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
GAAP Accountant
GAAP Accountant

pieinsurance • United States

Remote
USD 65,000 - 80,000
Health plans
Generous PTO
401(k) match
+1
Contract Recruiter (Remote, US)
Contract Recruiter (Remote, US)

Pie Insurance - Contracts • Denver (CO)

Remote
USD 55,000 - 83,000
Remote Contract Analytics Engineer - Looker & Snowflake
Remote Contract Analytics Engineer - Looker & Snowflake

Pie Insurance • United States

Remote
USD 90,000 - 150,000
Senior Contract Recruiter (Remote, Colombia)
Senior Contract Recruiter (Remote, Colombia)

Pie Insurance • United States

Remote
USD 55,000 - 96,000