Data Engineer

Summary

Join Lattice as a Data Engineer and play a pivotal role in designing, building, and optimizing our data infrastructure. Collaborate with data scientists and stakeholders to deliver high-quality data solutions. Responsibilities include writing production-level data transformations, managing ETL processes, and ensuring data warehouse performance. Leverage your expertise in SQL, Python, and Airflow to drive best practices and improve our tech stack. The role requires fluency in SQL and dbt, proficiency in Python, and experience with cloud platforms. A strong commitment to Lattice’s mission and values is essential. The estimated annual cash salary is $123,000 - $154,000, with eligibility for incentive stock options.

Requirements

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

Responsibilities

• 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

Benefits

• 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
• Invest in Your People Fund