Data Systems Developer II

Department: Systems

Status: Full Time (40 hours per week)

Location: Corporate HQ (Orem)

Compensation: DOE

Benefits: Full-Time employees are eligible for Health, Dental, Vision, & Life and Accident insurance, an HSA Savings Account, and more.

Why Blue Raven Solar?

Blue Raven Solar has been named a top-20 workplace in America according to Glassdoor (https://www.glassdoor.com/Overview/Working-at-Blue-Raven-Solar-EI_IE1090285.11,27.htm)! Founded in 2014, Blue Raven quickly expanded to become a national top-selling solar brand. We have been recognized repeatedly for our rapid growth, executive leadership, and company culture by Inc. 5000 (https://blueravensolar.com/?press=for-the-3rd-consecutive-year-blue-raven-solar-appears-on-the-inc-5000), BusinessQ Magazine (https://blueravensolar.com/?press=blue-raven-solar-ranked-on-the-utah-valley-businessq-uv50-list-of-fastest-growing-companies-for-a-fifth-year), Comparably (https://www.comparably.com/companies/blue-raven-solar), and many more. Blue Raven is a values-driven organization. Every day, we strive to develop a high-trust culture, be efficient, and continuously improve. If that sounds like something you want to be a part of, apply today!

Position Summary:

We are seeking an experienced Data Engineer to lead the development and maintenance of our data warehouse in Snowflake. In this role, you will design, build, and maintain complex ELT data pipelines using Five Tran and Python, ensuring efficient and effective data flow. You will collaborate with data stakeholders to understand their needs, using dbt to model data into new dimensional datasets while designing and creating tests to ensure data quality and adherence to data governance principles. Your responsibilities will include administering and automating Snowflake management, including user, role, and privilege management, as well as automating and optimizing CI/CD of dbt using GitHub Actions. Additionally, you will lead the documentation of data warehouse tables and resources, create and maintain a data catalog, and model, develop, and maintain company KPI definitions in a semantic layer using dbt.

Essential Duties:

• Lead the development and maintenance of a data warehouse in Snowflake

• Design, build and maintain complex ELT data pipelines using Five Tran and Python

• Communicate with data stakeholders to understand their needs and use dbt to model data effectively into new dimensional datasets, designing & creating tests to ensure data quality and adherence to data governance principles

• Administer and automate the administration of Snowflake through ongoing management of users, roles and privileges

• Automate, maintain and optimize CI/CD of dbt using Github Actions

• Lead documentation of data warehouse tables and resources and own creation of a data catalog

• Model, develop, and maintain company KPI definitions in a semantic layer using dbt

Minimum Qualifications:

• Bachelor's degree in Business Analytics, Information Systems, Computer Engineering, or related field (or equivalent corporate experience)

• 3+ years of corporate experience with advanced knowledge of technologies such as Snowflake, Fivetran, dbt, Github, and Prefect.io

• Advanced understanding of data warehousing, SQL, and Python. Knowledge of ELT processes and data transformation tools

• Ability to analyze and model complex datasets to meet stakeholder needs

• Strong ability to communicate technical concepts to non-technical stakeholders

• Ability to tackle multiple complex problems with a combination of technical and business acumen at once, prioritizing effectively

• Proven ability to work collaboratively in a team environment

While performing the duties of this job, the employee is regularly required to talk or hear. Regular periods of sitting or standing may be required by this position. In addition, this position requires the ability to occasionally lift office products and supplies, up to 50 pounds. Specific vision abilities required by this job include close vision and ability to adjust focus.