Data Engineer

Summary

Join Lattice as a Data Engineer and play a key role in designing, building, and optimizing our data infrastructure. Collaborate with data scientists and other stakeholders to deliver high-quality data solutions. Your responsibilities include writing data transformations, managing ETL processes, and ensuring data warehouse performance. You will leverage your expertise in SQL, Python, and data orchestration tools. Contribute to best practices and the continuous improvement of our tech stack. The role offers a competitive salary and a comprehensive benefits package.

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

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

Preferred Qualifications

Experience with a BI Tool (preferably Looker)

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