As a Data Engineer on our Data Science team, you will play a pivotal role in designing, building, and optimizing our data infrastructure to support data-driven decision-making across the organization. You will collaborate closely with data scientists, analysts, and other stakeholders to deliver high-quality data solutions that meet business needs. Your responsibilities will include writing production-level data transformations, managing ETL processes, and ensuring the performance and reliability of our data warehouse. With your expertise in SQL, Python, and data orchestration tools like Airflow, you will drive best practices and contribute to the velocity of our team and the continuous improvement of our tech stack.
What You Will Do- Write production-level data transformations to support stakeholders across data and business intelligence applications
- Create documentation and testing to ensure that our data is accurate and easily understandable
- Maintain and optimize performance of our data warehouse by designing efficient tables and storage processes
- Share methodologies and instruct other data team members on how to best write data transformations
- Collaborate with cross-functional teams to support data-driven initiatives and projects.
- Discover and institute best practices to ensure data quality across all facets of the data team
- Research and implement new tooling to enhance our tech stack
- Manage our ETL and other orchestrated processes through third party tools and first-party tools such as Airflow
- Enforce code quality by identifying and reducing tech debt, standardizing styles, and removing deprecated objects from code and downstream locations
- Work closely with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions
- Fluency in SQL and dbt
- Proficiency in Python
- Experience with git and cloud platforms (e.g. AWS)
- Knowledge of data orchestration tools like Airflow, Prefect, or Dagster
- Excellent communication and collaboration skills
- High attention to detail and ability to think structurally about a solution
- Experience with a BI Tool (preferably Looker)
- A strong commitment to Lattice’s mission and values, including Ship Shipmate Self, Clear Eyes, Own The Outcome, and What’s Next?
The estimated annual cash salary for this role is $123,000 - $154,000. This position is also eligible for incentive stock options, subject to the terms of Lattice’s applicable plans.
Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: Medical insurance; Dental insurance; Vision insurance; Life, AD&D, and Disability Insurance; Emergency Weather Support; Wellness Apps; Paid Parental Leave, Paid Time off inclusive of holidays and sick time; Commuter & Parking Accounts; Lunches in the Office; Internet and Phone Stipend; One time WFH Office Set-Up Stipend; 401(k) retirement plan; Financial Planning; Learning & Development Budget; Sabbatical Program; and Invest in Your People Fund
*Note on Pay Transparency:
Lattice provides an estimate of the compensation for roles that may be hired as required by state regulations. Compensation may vary based on (a) location, as Lattice factors in specific location when benchmarking compensation for most roles; (b) individual candidate skills and qualifications; and (c) individual candidate experience.
Additionally, Lattice leverages current market data to determine compensation, so posted compensation figures are subject to change as new market data becomes available. The salary, other compensation, and benefits information is accurate as of the date of this posting. Lattice reserves the right to modify this information at any time, subject to applicable law.
Lattice is on a mission to build cultures where employees and their companies thrive. In an age where employees have more choices than ever before, businesses that put employees first are winning 🏅– and Lattice is building the tools to empower those people-centric companies.
Lattice is a people success platform that offers performance reviews, employee engagement surveys, real-time feedback, weekly check-ins, goal setting, and career planning in a way that allows companies to focus on employee development, growth, and engagement – yielding stronger employee retention, performance, and impact to the bottom line 📈. Since launching in 2016, we have grown to over 5,000+ customers globally, including brands like Loom, Robinhood, and Gusto.
Lattice is committed to equal treatment and opportunity in all aspects of recruitment, selection, and employment without regard to gender, race, religion, national origin, ethnicity, disability, gender identity/expression, sexual orientation, veteran or military status, or any other category protected under the law. Lattice is an equal opportunity employer; committed to a community of inclusion, and an environment free from discrimination, harassment, and retaliation.
By clicking the "Submit Application" button below, you consent to Lattice processing your personal information for the purpose of assessing your candidacy for this position in accordance with Lattice's Job Applicant Privacy Policy.
Top Skills
Similar Jobs
.jpg)
What you need to know about the Los Angeles Tech Scene
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
