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.
2+ years as analytics engineer or BI engineer; advanced SQL; experience with Looker/LookML or Power BI/Tableau; data modeling; strong communication; daily AI tool use; fluent English; authorized to work as contractor in Brazil.
Key Responsibilities
- building Looker models
- modeling data in Snowflake
- reconciling data discrepancies
Skills & Tools
Looker, LookML, Snowflake, SQLDBM, SQL, Jira, GitHub, Monte Carlo, Power BI, Tableau, Python
Job Details
- Category: Data and Analytics
- Seniority: Mid Level
- Commitment: Contract
- Workplace: Remote — Brazil
- Languages: English
About Pie Insurance
A technology-driven small business insurance company making commercial insurance simpler, smarter, and more affordable. — Industry: Finance