• Design, develop, and maintain dbt models to transform raw data into analytics-ready datasets • Refactor and modularize existing dbt implementations, simplifying complex SQL into reusable, testable components • Implement and enforce dbt best practices, including folder structure, macros, seeds, incremental models, and environment promotion patterns • Translate business reporting requirements into structured data models and transformation logic • Ensure data quality through dbt testing, documentation, lineage, and source freshness monitoring • Troubleshoot and resolve issues across the data pipeline, from ingestion through transformation and reporting layers • Optimize SQL queries and dbt models for performance, maintainability, and scalability • Support reporting go-live efforts and contribute to long-term data support planning • Partner with internal teams for knowledge transfer, documentation, and integration alignment

• Design and manage a distributed cloud-to-edge infrastructure across Kubernetes environments • Focus on implementing secure, scalable hybrid networking using Cilium and KubeEdge • Enable high-performance connectivity and secure workload communication between Kubernetes clusters and remote edge nodes • Establish a unified networking and identity layer across environments • Leverage eBPF-based policy enforcement, encrypted service communication, and workload identity frameworks • Centered on cloud-native networking, security, and infrastructure automation

• Analyze, interpret, and reverse-engineer existing Oracle Data Integrator (ODI) workflows and data transformation logic • Document and understand current data flows, dependencies, and legacy data structures • Design Snowflake-optimized data models and ELT patterns that improve performance and scalability • Write performance-aware SQL and implement ELT transformations within Snowflake • Restructure inefficient or “stair-step” legacy models into normalized, maintainable, and scalable architectures • Cleanse legacy artifacts, including redundant columns, null-handling inconsistencies, and outdated dependencies • Design conformed and curated data objects to support analytics and reporting needs • Build modular, testable transformation pipelines using DBT or approved transformation tools • Manage Snowflake development environments, including roles, access control, and governance for development work • Establish data validation and reconciliation patterns to compare Oracle vs. Snowflake resultsImplement data quality checks to ensure accuracy and consistency during migration • Collaborate closely with QA and review teams to validate transformation logic and performance outcomes

Resource Innovations is seeking an Energy Modeling Consultant in Indiana to support our Inflation Reduction Act Program field delivery in Indiana. As an early key hire in this role, you will be responsible for delivering high-quality energy assessments and ensuring quality energy modeling for our HOMES and HEAR programs. These programs will provide comprehensive in-home energy audits with a focus on income-based program participants and collaboration with contractor networks. Your oversight will extend to residential weatherization, HVAC, and water heating installation inspections, as you review QA/QC findings to ensure program integrity. This role will be a hybrid of a field and remote office position. You are a key role in serving as the liaison between the Energy Auditor field team and the software platform used for energy modeling. Following the comprehensive in-home energy assessment, you will take on responsibility for reviewing project inputs, calibrating the modeling software and finalizing the selected equipment with the customer. The ideal candidate will bring proven experience in energy auditing, energy modeling/data analysis and project management. Strong leadership skills, a focus on team building and customer service, and knowledge of relevant standards and practices, particularly BPI certifications, are essential. Excellent communication and problem-solving abilities will set you apart. Resource Innovations (RI) is a women-led energy transformation firm focused on impact. Building on our expertise in energy efficiency, we're constantly expanding our portfolio of clean energy solutions to guide utilities through increasingly complex, connected challenges. Load flexibility. Electrification. Carbon reduction. With every step, we're leading the charge to power change. Duties and Responsibilities - Energy Modeling: Reviews the data collected by the in-home energy audits for quality assurance and reviews all project inputs and recommendations. Refine and calibrate projects using the energy modeling software to ensure BPI requirements are met. - Customer Interaction: Finalizes the selected equipment with the customer, generates work order and collects customer signature. Ensures all necessary forms and materials are completed    - On-Site: May also conduct onsite assessments or field inspections; reviews/writes inspection reports, and provides solutions to remedy failed inspections. - Develops and implements Energy audit protocols, QA/QC requirements and implementation plans    - Reviews program QC findings, reports and remedies inaccuracies    - Leverages best practices and continuous improvement plans to implement long term solutions in partnership with the client and Resource Innovations’ Program Managers    - Generates weekly, monthly, and ad hoc reports to audit, monitor and measure performance and relevant metrics    - Works as part of a cross functional team that includes program operations, IT, Marketing, and Customer Service/Processing    - Other business operations-related tasks as assigned.