Beyond Finance
Lead Data Warehouse Engineer
Beyond Finance, Chicago, Illinois, United States, 60290
At Beyond Finance, we've made it our mission to help everyday Americans escape the endless cycle of crippling debt and step into a brighter financial future. Through compassionate, individualized care, a culture focused on compliance and ethics, supportive user-centric technology, and customized financial solutions, we've helped over 300,000 clients on their path to a brighter future.
While we're proud of what we've already accomplished, we're searching for new collaborators to help us get to the next level! If you're looking to join a forward-thinking, rapidly growing organization with helping people as its number one goal, we want to hear from you.
About The Role
You'll be a thought leader to help contribute to our best practices of modeling standards and pipeline standards, and ensure the models and pipelines you and the team build will adhere to these standards. You'll learn the domain, contribute on your own projects, and coach and assist other junior contributors helping to share the wealth of knowledge you have.
We're a Chicago-based company looking for candidates willing to come into our downtown office 2-3 days a week. Enjoy in-person team collaboration, mentorship, and catered lunches — not to mention a free fitness center and relaxation lounge! If you're not in the Chicagoland area, we are able to offer relocation as well!
What You'll Do
Determine the best practices of what happens with the warehouse, gaining consensus with other engineers and publish data modeling standards and expectations, and ETL methodologies.
Build curated data models which will be used by data consumers to address business questions today and in the future, ensuring the data model is extensible and flexible.
Research and analyze the nature of the data to understand nuances and patterns of the data.
Collaborate with BI Engineers and various other groups to ensure they get the data they need in an easy to use manner.
Code review other engineers' code including data models and pipelines for adherence to standards and best practices.
Be the go-to person for helping with pipeline performance issues, data modeling approaches, and overall best practices within the warehouse.
Be a team player in contributing your thoughts and ideas to the overall goals of the team.
What We Look For
Bachelor's degree in Computer Science or other technical field or equivalent work experience.
3+ years of developing in the cloud; 7+ years of data warehouse implementations.
Experience using cloud analytics platforms which could include Google Big Query, AWS Redshift, or Snowflake and standard relational databases such as Postgres, MySQL, or other transactional databases.
Excellent SQL experience with working through complex queries.
Great understanding of warehouse data modeling methodologies such as Kimball Dimension models, and its practical implementation.
3+ years of relevant experience working with data load and transformation tools which might include Airflow, Lambda's, DBT, Presto, AWS Glue, or similar platforms.
Ability to coach/mentor other team members as appropriate.
Why Join Us?
While you make a difference for others, we'll work to make a difference for you, providing an uplifting, collaborative work environment and benefits that reflect your value to us. For eligible full-time employees, we offer:
Considerable employer contributions for health, dental, and vision programs.
Generous PTO, paid holidays, and paid parental leave.
401(k) matching program.
Merit advancement opportunities.
Career development & training.
And finally, our team spirit and culture! We cultivate an environment of community, connection, and belonging across our entire organization.
#J-18808-Ljbffr
While we're proud of what we've already accomplished, we're searching for new collaborators to help us get to the next level! If you're looking to join a forward-thinking, rapidly growing organization with helping people as its number one goal, we want to hear from you.
About The Role
You'll be a thought leader to help contribute to our best practices of modeling standards and pipeline standards, and ensure the models and pipelines you and the team build will adhere to these standards. You'll learn the domain, contribute on your own projects, and coach and assist other junior contributors helping to share the wealth of knowledge you have.
We're a Chicago-based company looking for candidates willing to come into our downtown office 2-3 days a week. Enjoy in-person team collaboration, mentorship, and catered lunches — not to mention a free fitness center and relaxation lounge! If you're not in the Chicagoland area, we are able to offer relocation as well!
What You'll Do
Determine the best practices of what happens with the warehouse, gaining consensus with other engineers and publish data modeling standards and expectations, and ETL methodologies.
Build curated data models which will be used by data consumers to address business questions today and in the future, ensuring the data model is extensible and flexible.
Research and analyze the nature of the data to understand nuances and patterns of the data.
Collaborate with BI Engineers and various other groups to ensure they get the data they need in an easy to use manner.
Code review other engineers' code including data models and pipelines for adherence to standards and best practices.
Be the go-to person for helping with pipeline performance issues, data modeling approaches, and overall best practices within the warehouse.
Be a team player in contributing your thoughts and ideas to the overall goals of the team.
What We Look For
Bachelor's degree in Computer Science or other technical field or equivalent work experience.
3+ years of developing in the cloud; 7+ years of data warehouse implementations.
Experience using cloud analytics platforms which could include Google Big Query, AWS Redshift, or Snowflake and standard relational databases such as Postgres, MySQL, or other transactional databases.
Excellent SQL experience with working through complex queries.
Great understanding of warehouse data modeling methodologies such as Kimball Dimension models, and its practical implementation.
3+ years of relevant experience working with data load and transformation tools which might include Airflow, Lambda's, DBT, Presto, AWS Glue, or similar platforms.
Ability to coach/mentor other team members as appropriate.
Why Join Us?
While you make a difference for others, we'll work to make a difference for you, providing an uplifting, collaborative work environment and benefits that reflect your value to us. For eligible full-time employees, we offer:
Considerable employer contributions for health, dental, and vision programs.
Generous PTO, paid holidays, and paid parental leave.
401(k) matching program.
Merit advancement opportunities.
Career development & training.
And finally, our team spirit and culture! We cultivate an environment of community, connection, and belonging across our entire organization.
#J-18808-Ljbffr