Contract - Data & Reporting Analyst (SQL / Looker / R Automation)

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.
Contract Position

Location: Buenos Aires, Argentina (Remote)
Reports To: Sr Director Commercial Operations
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.

As a Data & Reporting Analyst, you will be a core member of the Revenue Operations & Analytics team. You will partner with stakeholders across sales, marketing, and operations to build scalable analytics solutions that drive smarter, faster, and more informed business decisions.

We are seeking a technically strong analyst who combines data engineering expertise with analytical thinking and the ability to translate data into actionable insights. You will manage and enhance our analytics ecosystem through performant SQL development in Snowflake, Looker dashboards and LookML schemas, and R-based automations that power cross-functional reporting.

This is a high-impact contract role where the dashboards, pipelines, and insights you build will directly shape how Pie measures growth and drives revenue efficiency.

How You'll Do It

Build & Optimize Data Infrastructure:

• Write and optimize complex SQL queries in Snowflake (joins, CTEs, window functions, aggregations).
• Build and maintain derived tables, data transformations, and analytical datasets.
• Understand Snowflake schemas spanning marketing, sales, and policy data; join operational data across systems.
• Perform data validation, reconciliation, and quality assurance.

Create Self-Service Analytics:

• Build, enhance, and maintain Looker dashboards for Revenue Operations.
• Use LookML to model and expose Snowflake tables, define measures, and manage relationships.
• Develop and optimize Power BI reports for business stakeholders as needed.
• Ensure dashboards are accurate, performant, and aligned with evolving business needs.

Automate & Scale Reporting:

• Develop and maintain R scripts to automate recurring reporting and data processing tasks.
• Schedule and monitor R jobs (e.g., via Windows Task Scheduler) that query Snowflake, process data, and refresh outputs.
• Ingest, transform, and prepare .csv and API-based data feeds for upload to Snowflake.
• Automate data delivery to dashboards, spreadsheets, or Looker.

Drive Business Impact:

• Partner with stakeholders across Revenue Operations to define KPIs and reporting frameworks.
• Support campaign measurement, funnel analysis, and A/B testing when applicable.
• Translate analytical findings into clear insights and recommendations for business decisions.
• Deliver insights that improve conversion, retention, and operational efficiency.

The Right Stuff

• 3+ years of experience in analytics, data engineering, or business intelligence.
• Strong SQL skills and hands-on experience with Snowflake, Looker, and LookML.
• Proficiency in R or Python for data transformation, automation, and ETL tasks.
• Experience building and maintaining production dashboards in Looker; Power BI experience is a strong plus.
• C1 or C2 English proficiency required for effective communication with US-based stakeholders.
• Excellent problem-solving and communication skills, with the ability to translate technical work into actionable insights.
• Familiarity with statistical concepts (e.g., regression, confidence intervals) is a plus.
• Experience with Salesforce reporting on core objects and relationships is a plus.

Compensation & Benefits 

• Competitive cash compensation
• A piece of the pie (in the form of equity)
• Comprehensive health plans
• Generous PTO
• Future focused 401k match
• Generous parental and caregiver leave
• Our core values are more than just a poster on the wall; they're tangibly reflected in our work 

Our goal is to make all aspects of working with us as easy as pie. That includes our offer process. When we've identified a talented individual who we'd like to be a Pie-oneer , we work hard to present an equitable and fair offer. We look at the candidate's knowledge, skills, and experience, along with their compensation expectations and align that with our company equity processes to determine our offer ranges. 

Each year Pie reviews company performance and may grant discretionary bonuses to eligible team members.

Location Information 

Unless otherwise specified, this role is remote. Remote team members must live and work in the United States (territories excluded) and have access to reliable, high-speed internet.

Additional Information

Pie Insurance is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, marital status, age, disability, national or ethnic origin, military service status, citizenship, or other protected characteristic.

Pie Insurance participates in the E-Verify program. Please click here, here and here for more information.

Pie Insurance is committed to protecting your personal data. Please review our Privacy Policy.  

Safety First: Pie Insurance is committed to your security during the recruitment process. We will never ask you for credit card information or ask you to purchase any equipment during our interview or onboarding process.

Pie Named to 2025 America's Best Startup Employers

Pie's Ford Pro Insure Coverage expanded to Pennsylvania and Texas

Pie Insurance 2025 State of Workplace Safety Report

#LI-REMOTE
#BI-REMOTE

---