[Remote] Lead Data Engineer
Note: The job is a remote job and is open to candidates in USA. RMI is transforming the global energy system to secure a clean, prosperous, zero-carbon future for all. The Lead Data Engineer will support the Data and AI Engineering team by developing data pipelines, cloud infrastructure, databases, and AI-enhanced applications while collaborating with technical and 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
- 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
- All candidates must have current, independent authorization to work in the U.S. without present or future sponsorship from RMI
- This role can be located from anywhere in the continental United States
- Be ready to travel for occasional in-person meetings (and of course, we cover travel costs)
- 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
Benefits
- 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
- Essential IT equipment
- A one-time home technology payment
- A monthly work from home/commuter allowance
- Travel costs for occasional in-person meetings are covered
Company Overview