Sr. Data Warehouse Engineer

llaborative project work. These on-site sessions are designed to strengthen connections, share insights, and ensure a seamless experience for our team and customers. Equipment pick-up from a local branch will be required. We will provide advance notice whenever on-site attendance is required, making these times purposeful and rewarding.

Who We Are

Sunrun is on a mission to make solar energy affordable for more people. We help people upgrade their home to solar energy without the big upfront costs. Sunrun is dedicated residential solar company in the country and has a mission to bring clean, solar power service to the masses.

This position reports to our Lehi, UT office. May telecommute. Salary offered: $151,000/ year.

Responsibilities:

• Manage data integration solutions with third-party tools and external data sources. - 10%

• Build and maintain Sunrun database solutions in Snowflake, Single Store and MySQL. - 20%

• Optimize ELT processes to improve data reliability and performance. - 15%

• Continuously research new technologies and methodologies in data integration management. - 5%

• Manage data access and security using Role Based Access Control. - 15%

• Create and manage access to AWS cloud resources using Terraform. - 10%

• Collaborate with internal and external audit teams. - 5%

• Monitor status and respond to irregularities in daily scheduled data ingestion and model builds. - 5%

• Deploy changes engineered, tested, and approved through our SDLC and deployment pipelines. - 10%

• Participate in ongoing education initiatives. - 5%

Qualifications:

• Bachelor's in Computer Science or Information Systems

• 5 years of experience as a Database Architect doing data warehousing using Snowflake, Informatica administration and monitoring; designing databases and implementing data security models; database performance tuning and monitoring; creating real-time data and API integration solutions using Spark and SingleStore; using MySQL, Tableau and data visualization tools administration and monitoring, Python and Shell scripting, AWS, Azure, GCP cloud administration, Git and CI/CD process configuration, administration, and monitoring; and automation of Infrastructure with Terraform.

Recruiter:
Breanna Anderson ([email protected])

Please note that the compensation information is made in good faith for this position only. It assumes that the successful candidate will be located in markets within the United States that warrant the compensation. Please speak with your recruiter to learn more.

Starting salary/wage for this opportunity:

0.00 to 0.00

Compensation decisions will not be based on a candidate's salary history. You can learn more here.

This job description outlines the primary responsibilities, some essential job functions, and qualifications for the role. It may not include all essential functions, tasks, or requirements. If you are a qualified individual with a disability and you need reasonable accommodation during the hiring process or to perform this role, please contact us at [email protected].

Sunrun is proud to be an equal opportunity employer that does not tolerate discrimination or harassment of any kind. We believe that empowering people and valuing their differences are essential for our mission of connecting people to the cleanest energy on earth. Learn more here: EEO | Sunrun