Data Engineer

EZT is seeking a Data Engineer to lead and execute on our data pipeline, data integrity, data security, and data infrastructure efforts with our world-class data tech stack including BigQuery, Fivetran, Apache Airflow, and dbt. You will serve as an internal consultant to our Business Intelligence Analysts, Analytics Engineers, and eventually Data Scientists. This position reports to the Director of Business Intelligence.

Primary Responsibilities:

• Build data pipelines, data integrity testing, data security, and other data engineering infrastructure alongside the Sr Data Engineers and management.
• Work with Analytics Engineering and Business Intelligence to supply the data required for various data products and multiple stakeholders.
• Design & continuously improve data workflows using systems including BigQuery, Fivetran, Apache Airflow, and dbt.
• Manage and communicate through a project and understanding to project management, business stakeholders, and technical resources.
• Build your Product Manager and/or Scrum Master skills by planning and managing project tasks.
• Consultative approach to development, execution, and recommendations.
• Create technical documentation.
• Deliver high-quality code and design documents with mentorship from Sr Data teammates and management.
• Be versatile and willing to take on new challenges across different projects and technologies.
• Have a high sense of urgency to deliver work on time as well as the ability to prioritize and properly estimate the complexity of the work in advance.

Required Skills:

• 2+ years’ experience writing complex SQL.
• 2+ years’ experience in Python.
• 2+ years’ experience building ETL workflows, including reverse ETL.
• 2+ years’ experience building complex orchestration pipelines.
• Experience building automated testing into the data infrastructure.
• Experience with Relational Database structures and dimensional modeling and data warehousing.
• Familiarity with CI/CD pipelines.
• Experience working with Git and JIRA.

Working knowledge of:

• GCP & BigQuery.
• Fivetran.
• Apache Airflow.
• Census or other reverse ETL solution.
• Jira/Confluence or another project management and documentation solution.
• Experience with Agile methodologies and a desire to work on a cross-functional Scrum team.

Experience working for a SaaS company in a startup environment is a plus.