Analytics Engineer

The Analytics Engineer supports Pomona Farming’s enterprise data and analytics platform by developing and maintaining data pipelines, transforming raw data into reliable analytical datasets, and supporting reporting solutions used across Pomona Farming, Mahi Pono, and affiliated entities. Working closely with the Sr. Data Engineer and Business Systems Transformation team, this role leverages SQL and Python to ensure data is accurate, accessible, and well-documented for business users in finance, operations, labor, and procurement. This is a growth-focused position that begins with core data warehouse and analytics development responsibilities and provides opportunities to expand into Power BI semantic modeling, dashboard development, and QuickBase application development over time.

The primary responsibility of the candidate will be ultimately up to the Sr. Data Engineer, but some duties may include:

Responsibilities

• Write and maintain SQL queries against our Snowflake data warehouse to support reporting, analysis, and data transformation needs.
• Develop and maintain Python scripts to support ETL/ELT processes, data validation, and automation tasks.
• Consume third-party APIs (REST/HTTP) and parse XML and JSON responses to ingest external data into the warehouse.
• Build and maintain data models that translate raw source data into clean, well-structured analytical datasets.
• Partner with the Sr. Data Engineer to design and implement star-schema data marts that support downstream reporting tools.
• Document data sources, transformations, and business logic so that datasets are trusted and easy for others to use.
• Investigate and resolve data quality issues at the source, working with stakeholders to confirm correct business logic.
• Support the development of dashboards and reports in Power BI as skills are developed.
• Support QuickBase application development and integrations as skills are developed.
• Other duties as assigned.

Do you have experience in XML?, * 2+ years of relevant experience and/or a relevant college degree (Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, Engineering, or a related field).

• Demonstrated proficiency writing SQL queries against normalized relational databases, including the ability to write multi-table joins, aggregations, and subqueries.
• Working knowledge of Python (or a comparable scripting language used in analysis or ETL).
• Experience consuming APIs - making HTTP requests and extracting data from XML and JSON responses.
• Strong analytical skills and a demonstrated ability to connect data analysis with business questions.
• Strong attention to detail and a methodical approach to problem solving.
• Excellent written and verbal communication skills, with the ability to communicate clearly with both technical and non-technical audiences.
• Ability to manage competing priorities and work independently in a fast-paced environment.

Physical Requirements

• Ability to sit for extended periods while performing computer-based work and other office tasks.
• Ability to use hands and fingers to operate a computer, keyboard, mouse, telephone, and other standard office equipment.
• Ability to communicate effectively in person, by phone, and electronically.
• Ability to occasionally stand, walk, and move within an office environment to attend meetings or access files and office equipment.

Pulled from the full job description

• 401(k)
• Health insurance
• 401(k) matching
• Paid time off
• Vision insurance
• Health savings account
• Dental insurance, * 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance