Data Engineer

At ProducePay, we believe strongly in driving business strategies and decisions with evidence-based data, rather than intuition, opinion, or assumption. As a senior member of our top-notch and fast-paced engineering team, we are looking for a Senior Data Engineer who will design, implement, and optimize ProducePay's vast and diverse data platform (ELT/ETL) and modern data warehouse architecture, ensuring scalability, reliability, and security for mission-critical analytics. This role will own the entire data lifecycle, working closely and collaboratively with other engineers, as well as other functional teams to define requirements, integrate data from a variety of sources, and deploy high-quality data pipelines in support of the analytics needs of ProducePay. As a thought leader and mentor on the engineering team, you will establish best practices for data quality, pipeline development, and platform optimization, while actively guiding junior team members.

Responsibilities:

• Design and implement robust data governance, quality, and observability frameworks to ensure accuracy across all data products.
• Own the architecture, modeling, and optimization of the data warehouse (e.g., dbt transformations, dimensional modeling) to support business intelligence and data science initiatives.
• Build, deploy, and monitor high-volume, reliable data pipelines using appropriate workflow orchestration tools (e.g., Apache Airflow, Dagster).
• Reviewing and analyzing data sets to identify patterns or trends that may have business implications.
• Assisting and providing feedback for new and existing data models, databases.
• Providing consultation on data management and integrity issues to other members of the company.
• Recommending changes to existing databases to improve performance or resolve issues.

• 5+ years of professional experience in Data Engineering.
• At least a Bachelor’s Degree in Computer Science, Engineering, or a related quantitative field.
• Familiar developing ELT pipelines using Python, REST, and SQL in a Linux environment.
• Passionate about data and the power of data.
• Willing to step outside of comfort and immediate responsibility zones to drive results and desired outcome.
• Committed to making data a key focus for overall company strategy, growth, and product development.
• Deep expertise in advanced SQL and data modeling concepts (e.g., Dimensional Modeling, 3NF).
• Hands-on production experience with Snowflake and PostgreSQL.
• Proficiency in Python or Scala, including experience with data processing libraries (e.g., Pandas, Spark).
• Production experience building and maintaining data services on AWS (e.g., S3, EC2, Lambda, Kinesis/MSK).
• Excellent communication and presentation skills.
• Highly organized with good time management skills.
• Strong attention to detail.
• Strong understanding of Infrastructure as Code (IaC) principles; experience with Pulumi or Terraform is highly preferred.
• Exceptional problem-solving ability.
• Ability to succeed in a collaborative work environment and work cross-functionally.

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Family Leave (Maternity, Paternity)
• Short Term & Long Term Disability
• Training & Development
• Work From Home
• Wellness Resources