Senior Data Engineer, Solutions Architecture

<h2 class="lumesse-section-header lumesse-section-header-0 jdesc-section-header"><span style="color: rgb(0, 32, 96);">What The Role Is</span></h2> <p>We are seeking a talented Senior Data Engineer to design, build, and maintain our data infrastructure supporting mission-critical energy operations. You'll work at the intersection of renewable energy and data, developing pipelines that process everything from real-time asset performance data to complex trading and risk analytics. This hybrid role offers the opportunity to make a direct impact on clean energy operations while working with a cutting-edge data stack including Snowflake, Dagster, dbt, Modal, and GitLab.</p> <h2 class="lumesse-section-header lumesse-section-header-1 jdesc-section-header"><span style="color: rgb(0, 32, 96);">What You'll Be Doing</span></h2> <h3>Analytics Infrastructure &amp; Data Warehouse Management</h3> <ul> <li>Design, deploy, and maintain scalable data infrastructure to support enterprise analytics and reporting needs</li> <li>Manage Snowflake instances, including performance tuning, security configuration, and capacity planning for growing data volumes</li> <li>Optimize query performance and resource utilization to control costs and improve processing speed</li> </ul> <h3>Data Pipeline Development &amp; Orchestration</h3> <ul> <li>Build and orchestrate complex ETL/ELT workflows using Dagster to ensure reliable, automated data processing for asset management and energy trading</li> <li>Develop robust data pipelines that handle high-volume, time-sensitive energy market data and asset generation and performance metrics</li> <li>Implement workflow automation and dependency management for critical business operations</li> </ul> <h3>Data Transformation &amp; Analytics Support</h3> <ul> <li>Develop and maintain dbt models to transform raw data into business-ready analytical datasets and dimensional models</li> <li>Create efficient SQL-based transformations for complex energy market calculations and asset performance metrics</li> <li>Support advanced analytics initiatives through proper data preparation and feature engineering</li> </ul> <h3>Data Quality &amp; Governance</h3> <ul> <li>Implement comprehensive data validation, testing, and monitoring frameworks to ensure accuracy and consistency across all energy and financial data assets</li> <li>Establish data lineage tracking and privacy controls to meet regulatory compliance requirements in the energy sector</li> <li>Develop alerting and monitoring systems for data pipelines, including error handling, SLA monitoring, and incident response</li> </ul> <h3>CI/CD