Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Analytics Engineer
Job
Pomona Farming LLC
Oakdale, CA (In Person)
$85,000 Salary, Full-Time
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
78
out of 100
Average of individual scores
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
Analytics Engineer Pomona Farming LLC Oakdale, CA Job Details Full-time $75,000 - $95,000 a year 23 hours ago Benefits Health savings account Health insurance Dental insurance 401(k) Flexible spending account Paid time off Employee assistance program Vision insurance 401(k) matching Life insurance Qualifications Dashboard development Computer Science XML Phone communication Snowflake Analysis skills Attention to detail REST Integration with Third-Party Services (system development) JSON Query management Data analytics technologies Full Job Description Job Description 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. Requirements 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.