Rocky Mountain Institute

Lead Data Engineer

Rocky Mountain Institute$93K — $115K *
US-AnywhereRemote in United States
Energy & Utilities
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 3-5 years of experience in data engineering or related field
  • Proficient in Python for data processing and automation
  • Working knowledge of R for data analysis
  • Experience with Git or similar version control
  • Familiar with integrating LLM APIs into workflows
  • SQL query writing and relational database experience
  • Exposure to cloud data workflows, preferably Microsoft Azure
  • Strong communication skills for interacting with non-technical stakeholders

Responsibilities

  • Develop and maintain data ingestion pipelines between internal systems
  • Support AI-enhanced application development and integration
  • Build and maintain relational databases for internal applications
  • Implement data reliability and monitoring features
  • Manage Azure cloud resources based on project needs
  • Develop various API connectors for AI tools
  • Write clean, reusable code for automated data processing
  • Collaborate with non-technical staff on data processes
  • Migrate siloed data processes to centralized systems
  • Ensure cloud data service security with IT team

Benefits

  • Medical, dental, vision insurance
  • 403b retirement match with immediate vesting
  • Comprehensive leaves of absence, including parental leave
  • Generous paid time off and sick leave
  • Paid sabbatical leave
  • Health savings or flexible spending accounts
  • Learning & development opportunities with budget
  • Work from home and home tech allowances
  • Hybrid/remote work options
  • Team retreats and geographic meetups
Full Job Description
Job Description:

Job Description

RMI is a data-driven organization, and it is critical for there to be a successful and robust data strategy at the organization to improve the impact of our programs. RMI is building a Data and AI Engineering team to enhance access to both internal business systems and external data sources. The Lead Data Engineer will support this initiative, working alongside a multi-disciplinary team, and will be a key contributor to pipelines, infrastructure, and AI-enhanced capabilities. You will report to the Data Engineering Manager on the Strategic Operations team. A successful candidate will be adept at cloud data storage and design, ETL/ELT pipelines, and associated coding languages, with keen attention to detail and a strong desire to support the energy transition.

Key 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


Minimum 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
  • Working knowledge of integrating LLM APIs (e.g., OpenAI, Anthropic) into data workflows or applications, including via MCP servers
  • Experience writing SQL queries and working with relational databases
  • Exposure to cloud-based data workflows; familiarity with Microsoft Azure is a plus
  • Comfort working across multiple projects simultaneously in a collaborative, evolving environment
  • Strong written and verbal communication skills, including the ability to collaborate with non-technical stakeholders


Preferred Qualifications
  • Hands-on experience with Azure cloud services (Azure SQL, Azure Functions, Azure Blob Storage, or similar)
  • Familiarity with ETL/ELT concepts and data pipeline design patterns
  • Experience with data modeling best practices
  • Experience building lightweight internal web tools or APIs
  • Experience with data visualization tools such as Power BI
  • Familiarity with Salesforce, Workday, or similar enterprise data sources, especially working with their APIs
  • Experience working in a non-profit environment
  • Demonstrated interest in energy, climate, or sustainability sectors


We encourage anyone who is interested in this role to apply, regardless of whether you feel you meet 100% of the qualifications. The top candidates will bring their own unique perspectives, experiences, and backgrounds from a variety of industries along with many but not necessarily all the skills listed above. We offer professional learning and training opportunities to help you develop the skills you may not have had the opportunity to cultivate yet.

Visa Sponsorship

Please note: At this time, RMI is not able to sponsor employment visas or hire candidates who require visa sponsorship to work in the United States. All candidates must have current, independent authorization to work in the U.S. without present or future sponsorship from RMI. We will update our hiring pages if this status changes.

Location

We are a remote-ready company with team members around the globe. Our beautiful and welcoming offices are available for meetings or focused work, whether you are traveling through or living nearby. Our U.S. offices are in New York City; Washington DC; Oakland, California; Boulder, Colorado, and Basalt, Colorado. This role can be located from anywhere in the continental United States.

We provide you with the essential IT equipment plus a one-time home technology payment and a monthly work from home/commuter allowance to ensure you have a comfortable home office set up and necessary supplies.

We love seeing each other in person! We occasionally gather for shared time together like retreats and learning experiences. Be ready to travel for occasional in-person meetings (and of course, we cover travel costs). Some roles may require more travel, which will be discussed during the hiring process.

Compensation

At RMI, we prioritize fairness in our pay practices. Salaries are determined based on a mix of experience, market benchmarks, and internal equity across similar roles. The salary range of this position is $93,890 - $115,720. New hires typically start toward the lower end of the range, depending on experience and alignment with the role's scope. In addition to base salary, this position includes an annual bonus target of 10% and eligibility for merit-based increases, which are tied to both individual and organizational performance.

Benefits

We offer an array of benefits including:
  • Medical, dental, vision insurance
  • 403b retirement match with immediate vesting
  • Group life, AD&D, and short- and long-term disability
  • Optional voluntary life, AD&D and accident plans
  • Health savings or flexible spending accounts
  • Fertility and hormonal health support
  • Mental health and wellness support
  • Comprehensive leaves of absence (including generous parental leave)
  • Generous paid time off and sick leave
  • Paid sabbatical leave
  • Regional holidays with at least one extended break in each geography
  • Work from home and home technology allowances
  • Learning & development opportunities (LinkedIn Learning and an annual individual professional development budget)
  • Potential for bonuses and merit increases
  • Discount marketplace (gym memberships, pet insurance, etc.)
  • Hybrid / remote work options
  • Team retreats and geographic meetups
  • Rewards and recognition programs


About Rocky Mountain Institute

The Rocky Mountain Institute (RMI) is a non-profit organization that focuses on research, consulting, and education in the fields of energy and resource efficiency, renewable energy, and sustainable design. The organization was founded in 1982 by Amory Lovins and Hunter Lovins, and is headquartered in Basalt, Colorado. RMI works with businesses, governments, and communities to develop and implement innovative solutions to energy and environmental challenges. The organization has a staff of over 200 people, including experts in engineering, economics, policy, and design. RMI has been recognized for its work by numerous organizations, including the United Nations and the World Economic Forum.
Learn more about Rocky Mountain Institute
Size
221 employees
Industry

Similar Jobs

More Jobs at Rocky Mountain Institute

More Energy & Utilities Jobs

Find similar Lead Data Engineer jobs: