Senior Data Engineer

Sungage Financial•Boston, MA

About The Position

Sungage Financial originates thousands of loans each year through hundreds of different solar installation partners using our solar finance platform. Our lean team of professionals moves quickly and adapts to the ever-changing demands of our dynamic industry. This is an exciting opportunity to support the execution of Sungage’s new data warehouse and inform the company’s evolving data architecture. The Data Engineer will be responsible for expanding, enhancing, and maintaining Sungage’s data warehouse and related infrastructure for effective utilization by internal and external stakeholders. The position will report to the Director of Data Platform Engineering, and be a vital partner in implementing the company’s broader data strategy. The role involves data warehouse management (including SQL and Python-based programming to structure data flows and data sources, providing input on data architecture, as well as managing automated data flows, error handling, and other related tasks), and working closely with other members of the Business Intelligence team to promote effective data utilization.

Requirements

Minimum of 4+ years of experience in data engineering or a related role
Comfort with being responsible for a vital business resource, including taking ownership of its performance, articulating areas for improvement, and working to implement enhancements
Demonstrable experience in SQL and core data management principles (such as ETL/ELT, data warehousing architecture, OLAP principles, query design, and performance tuning)
Strong foundations in Python
Experience in requirements gathering
Strong communication skills and a willingness to learn
Excellent attention to detail

Nice To Haves

Demonstrated experience with AWS Lambda, Fivetran, Snowflake, DBT, MDM and OLAP concepts, Data modeling/Architecture

Responsibilities

Support & lead segments of data engineering efforts involving the implementation and management of Sungage’s new data warehouse architecture
Provide thought leadership on best practices for data warehouse management and design
Engage with various internal stakeholders in requirements gathering & test deployed code
Review peer code and help in setting coding standards
Take ownership over data flow errors, communicating about them and working to resolve them as efficiently as possible
Work closely with the rest of the Business Intelligence team and other internal stakeholders to understand the needs of the business and build data resources to best meet those needs