> Markdown version of [/jobs/ext/529892-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/529892-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Analytics Engineer - **Company:** POMONA FARMS, LLC - **Location:** Oakdale, CA, United States - **Experience:** Experienced - **Salary:** $75,000.0 - $95,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Data Analysis, Business Logic, Business Systems, Information Systems, Data Validation, Extract Transform Load (ETL), Data Mart, Data Transformation, Data Retrieval, Data Warehousing, Relational Databases, Hypertext Transfer Protocols (HTTP), JSON, Python (Programming Language), Power BI, Software Engineering, SQL Databases, Systems Integration, Extensible Markup Language (XML), Scripting, Snowflake, Core Data, Information Technology, Data Analytics, Quickbase, Data Management, Tools for Reporting, Data Pipelines, Web Api - **Published:** June 13, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=c73e9e478212484b ## About the Role 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. ## 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. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Web APIs you might not know about](https://www.wearedevelopers.com/videos/281-web-apis-you-might-not-know-about) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)