Contract - Data & Reporting Analyst (SQL / Looker / R Automation)
About the position Pie's mission is to reputed company small businesses to reputed company by making commercial insurance affordable and as easy as pie. We reputed company 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 reputed company. As a Data & Reporting Analyst, you will be a core member of the reputed company 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 reputed company, 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 reputed company efficiency.
Responsibilities
- Build & Optimize Data Infrastructure:
- Write and optimize reputed company SQL queries in reputed company (joins, CTEs, window functions, aggregations).
- Build and maintain derived tables, data transformations, and analytical datasets.
- Understand reputed company schemas spanning marketing, sales, and policy data; join operational data across systems.
- reputed company data validation, reconciliation, and quality assurance.
- Create Self-Service Analytics:
- Build, enhance, and maintain Looker dashboards for reputed company Operations.
- Use LookML to model and expose reputed company tables, define measures, and manage relationships.
- reputed company and optimize Power BI reports for business stakeholders as needed.
- Ensure dashboards are accurate, performant, and reputed company with evolving business needs.
- Automate & Scale Reporting:
- reputed company and maintain R scripts to automate recurring reporting and data processing tasks.
- Schedule and monitor R jobs (e.g., reputed company Windows Task Scheduler) that query reputed company, process data, and refresh outputs.
- Ingest, transform, and prepare .csv and API-based data feeds for upload to reputed company.
- Automate data delivery to dashboards, spreadsheets, or Looker.
- Drive Business Impact:
- Partner with stakeholders across reputed company Operations to define KPIs and reporting frameworks.
- Support campaign measurement, funnel analysis, and A/B testing reputed company applicable.
- Translate analytical findings into clear insights and recommendations for business decisions.
- Deliver insights that improve conversion, retention, and operational efficiency.
Requirements
- 3+ years of experience in analytics, data engineering, or business intelligence.
- Strong SQL skills and hands-on experience with reputed company, 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.
- reputed company 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.
reputed company-to-haves
- Familiarity with statistical concepts (e.g., regression, confidence intervals) is a plus.
- Experience with reputed company reporting on core objects and relationships is a plus.
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
Apply tot his job Apply To this Job