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.

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

What You Will Bring to the Table

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