Lead Data Engineer: AI, Cloud & Pipelines

Rocky Mountain Institute; Denver (CO); Hybrid; USD 94,000 - 116,000; Full time

Benefits offered by this job

Health insurance

403b retirement match

Paid time off

Learning budget

Hybrid/remote work options

Job summary

Rocky Mountain Institute is seeking a Lead Data Engineer to drive data ingestion, ETL/ELT pipelines, and AI-enabled data tools. You will design scalable databases, integrate LLM APIs, and deploy Azure resources to support organizational dashboards and decision-making.

The role requires 3–5 years in data engineering or related fields, strong Python and SQL skills, and experience with cloud data workflows. This position offers a remote-ready arrangement across the continental US with travel as

Qualifications

• 3–5 years of professional or internship experience in data engineering, data science, or a related field.
• Proficiency in Python for data processing, scripting, and automation.
• Working knowledge of R for data analysis and statistical tasks.
• Familiarity with Git or similar version control technology.
• Experience writing SQL queries and working with relational databases.
• Exposure to cloud-based data workflows; familiarity with Microsoft Azure is a plus.
• Strong written and verbal communication skills, including the ability to collaborate with non-technical stakeholders.

Responsibilities

• Support the development and maintenance of data ingestion pipelines between internal business systems (e.g., Workday, Salesforce).
• Support the development of internal AI-enhanced applications, integrating LLMs via API and MCP
• Assist in building and maintaining relational databases, including MySQL and PostgreSQL schemas, to support internal dashboards, applications, and reporting.
• Help implement data reliability and monitoring features across existing data flows.
• Deploy and manage Azure cloud resources (database, storage, web app, function app) based on project needs and templates defined by senior staff.
• Assist with the development testing, and deployment of various connectors (i.e., MCP servers, APIs) for general purpose AI tools (i.e., ChatGPT, Claude).
• Write clean, reusable code primarily in Python and R to automate data processing tasks and support analytical workflows.
• Collaborate with operations staff and non-technical stakeholders to develop a strong working knowledge of data processes and upstream/downstream impact.
• Assist in migrating siloed or manual data processes into centralized, accessible systems.
• Work with the IT team to ensure security and fidelity of cloud data services.

Skills

Python

SQL

R

Git

LLM APIs

Azure

Data pipelines

Tools

Workday

Salesforce

MySQL

PostgreSQL

Azure SQL

Azure Functions

Job description

Rocky Mountain Institute is seeking a Lead Data Engineer to drive data ingestion, ETL/ELT pipelines, and AI-enabled data tools. You will design scalable databases, integrate LLM APIs, and deploy Azure resources to support organizational dashboards and decision-making.

The role requires 3–5 years in data engineering or related fields, strong Python and SQL skills, and experience with cloud data workflows. This position offers a remote-ready arrangement across the continental US with travel as