Analytics Expert for Nature-Positive Agriculture

Invaio Sciences is hiring an Analytics Expert for Nature-Positive Agriculture in Cambridge, MA. The role involves developing and maintaining analytics solutions using Looker and Snowflake, collaborating with scientists and engineers to ensure data integrity and quality. Candidates should have strong SQL skills and experience with data visualization tools. A Bachelor's or Master's degree in a relevant field and approximately 3 years of experience are preferred.
About the Opportunity

Invaio Sciences is seeking an Analytics & Data Visualization Engineer to join our team in Cambridge, MA. This role sits at the intersection of data engineering and analytics, ensuring seamless reporting and visualization of scientific data. You will work primarily with Looker and Snowflake, building scalable analytics solutions for our R&D and Commercial teams. The ideal candidate will have strong SQL skills and experience with Looker and Snowflake. This role requires collaboration with scientists, analysts, data scientists, and engineers to understand data needs and deliver high-quality analytics solutions. Additional responsibilities include ensuring data integrity, accuracy, and consistency across the platform.

Responsibilities and Requirements

You will develop and maintain Looker Explores, Dashboards, and custom data visualizations. Writing and optimizing LookML to create user-friendly, performant data models is also part of this role. Designing and implementing ELT pipelines in Snowflake to transform raw data into structured, analytics-ready datasets is required. Leveraging Snowflake Dynamic Tables, UDFs, and other advanced features to enhance data accessibility and performance is crucial. Collaborating with cross-functional teams to understand data needs and deliver high-quality analytics solutions is essential. Ensuring data integrity, accuracy, and consistency across the platform is also required.

Desirable Skills and Qualifications

A Bachelor's or Master's degree in a relevant field, such as data science, Computer Science, Bioinformatics, or a related area, is desirable. Approximately 3 years of experience working with Looker (LookML, Explores, Dashboards, Visualizations) and Snowflake, or equivalent business intelligence and data warehousing tools, is necessary. Strong SQL skills, including query optimization and performance tuning, are essential. Experience with ELT processes, data transformation, and building analytics-friendly datasets is also required. Familiarity with custom Looker visualizations (D3, e.g.) is a plus.