Data Engineer

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.

• 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.