Data Warehouse Engineer

Mackinnon Bruce International; Indianapolis (IN); Remote; USD 80,000 - 120,000; Full time

Job summary

An innovative precision agriculture startup is on the lookout for a skilled Database Engineer to join their remote team. This exciting role involves designing and building a scalable data warehouse leveraging PostgreSQL and AWS technologies. You'll have the opportunity to integrate transactional databases, optimize queries, and develop real-time data pipelines that enhance agricultural insights. If you have a passion for data and a background in agronomics, particularly with corn and soybeans, this position offers a unique chance to make a significant impact in the Ag-Tech industry. Join a dynamic team and help shape the future of digital farming!

Qualifications

• Strong experience with PostgreSQL and SQL programming.
• Hands-on experience with AWS services for data storage and analytics.

Responsibilities

• Architect and implement a robust data warehouse using PostgreSQL.
• Develop streaming data pipelines for real-time processing.

Skills

PostgreSQL

SQL programming

AWS (Redshift, Kinesis Firehose, S3)

ETL processes

Scripting (Python, shell scripting)

Agronomics knowledge (corn and soybeans)

Tools

AWS Glue

ETL tools

Job description

Leading Ag-Tech at Mackinnon Bruce International | Digital Farming, Regenerative Agriculture, Ag-Robotics and CEA

Data Warehousing Engineer | Remote, Indianapolis | Ag-Tech

Industry – Ag-Tech

Description

We are seeking a skilled Database Engineer to design and build a scalable data warehouse from our transactional databases, leveraging PostgreSQL and AWS technologies. Knowledge of agronomics in row crops, particularly corn and soybeans, is a bonus for this role, as it will help tailor data solutions to support agricultural insights.

Who we are

We are a dynamic recruitment and executive search agency that has evolved since our first establishment in 2012. We work with several high-profile clients, startups, and SMEs globally to help them source and retain top-tier talent.

The client

Our client is a leading precision agriculture startup with an office in Indianapolis, providing growers agronomic insights gathered from remote sensing technologies.

Location: Remote, within 60 Miles of Indianapolis for occasional travel

Key Responsibilities

• Architect and implement a robust data warehouse using PostgreSQL.
• Integrate transactional databases into the warehouse while ensuring data quality and consistency.
• Utilize AWS services such as Redshift, Kinesis Firehose, and S3 for data storage and analytics.
• Develop streaming data pipelines for real-time processing.
• Optimize database schemas and queries for scalability and efficiency.
• Monitor ETL processes to handle large-scale data ingestion seamlessly.
• Collaborate with teams to incorporate row crop agronomic knowledge (corn and soybeans) into data models for enhanced decision-making.
• Partner with cross-functional teams to understand data requirements.
• Document technical specifications for ETL pipelines, database architecture, and AWS configurations.

Key Requirements

• Strong experience with PostgreSQL, including database management and query optimization.
• Proficiency in SQL programming.
• Hands-on experience with AWS services like Redshift, Kinesis Firehose, S3, or Glue.
• Familiarity with ETL tools and processes.
• Knowledge of agronomics in row crops (corn and soybeans) is a bonus.
• Experience with scripting languages like Python or shell scripting.

Job Type: Full Time

Interested? You can either apply directly or reach me at [e-mail]

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Industries: Farming and Agriculture, Construction, Mining Machinery Manufacturing