Collaborate with analysts and data consumers, and document data models, transformation logic, and operational procedures.
Minimum Qualifications / Other Expectations
- Strong SQL skills with ability to write and optimize analytical queries
- Python proficiency for building data ingestion pipelines and scripting
Bachelor's degree in Computer Science, Engineering, or a related technical field, or equivalent practical experience
Experience with dbt or willingness to learn quickly (we use dbt extensively)
Familiarity with data warehousing concepts on Snowflake, BigQuery, or similar comfort with Git-based development workflows
Experience with dbt in a production environment
Familiarity with dimensional modeling (fact and dimension tables)
Experience with layered data architectures (staging, intermediate, mart patterns)
Exposure to workflow orchestration tools (Dagster, Airflow, Prefect)
Understanding of data quality testing approaches
Preferred
3 - 5 years in analytics engineering or data engineering
Compensation
Base Pay Start Rate: $65 - 95/hour
The Company also offers competitive benefits for full time employees including paid time off, matching 401(k), and health benefits.
About Us
Irvine Company is a privately held real estate investment company and master-planner committed to creating and sustaining communities that thrive for generations.
Irvine Company is respected for its master planning and environmental stewardship of the Irvine Ranch in Orange County, including diversified operations throughout coastal California. Irvine Company brings to life neighborhoods and sustainable communities with a full range of housing, jobs, retail centers, schools, parks and open space.
We take as much pride in our employee community as we do the communities we create. It’s an environment populated with talented and experienced people, a collaborative spirit and abundant opportunities.
Apply today to join our employee community, and learn more about Irvine Company, our legacy and our guiding principles.
Irvine Company is committed to providing equal opportunity in all of our employment practices, including selection, hiring, promotion, transfer, compensation, termination, and training, without regard to race, religion, color, sex, sexual orientation, gender, gender identity, national origin, ancestry, citizenship status, marital status, pregnancy, age, medical condition, genetic information, military and veteran status, disability, or any other basis protected by federal, state, and local law. Reasonable accommodation is available for qualified individuals with disabilities, upon request.
#LI-Onsite