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.
- 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
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
Desired, but not required
- Demonstrated experience with AWS Lambda, Fivetran, Snowflake, DBT, MDM and OLAP concepts, Data modeling/Architecture
The Company has offices in downtown Boston and Oakland. We offer a number of employee benefits, including stock options, 401k with matching, substantial paid time off, health coverage, health savings accounts, and commuter benefits.
