Please Note: This is a Utah-based hybrid position which will require some regular in-office days each week.
Essential Job Duties
As a Data Engineer focused on analytics engineering, we'll rely on your expertise to develop, automate, operate, and maintain data warehouses and data marts. Crafting performant and reliable data pipelines, effective data structures, and thoughtful data models will be key to your success.
You will:
Collaborate with data analysts, data scientists, AI software engineers, and stakeholders to make effective use of core data assets
Meet with stakeholders to define and document modeling requirements
Design ERDs and data flow diagrams mapping business processes to data
Build and maintain data marts, facts, and dimensions for business analytics
Support key performance indicators and other business or operational metrics
Leverage a combination of tools and SQL code to automate and orchestrate data modeling
Monitor and improve the health, quality, and performance of data pipelines and modeled objects
Develop SQL based data quality control tests
Participate in peer SQL code reviews, code approval, and pull requests
Provide expertise in operation, troubleshooting, and tuning of tools, code, SQL, and systems
Contribute to the evolution of tools, systems, and methods for harnessing data
Help ensure appropriate data privacy and security
You'll be part of a team applying data to analyze and optimize key business processes such as finance, marketing, sales, product, customer experience, and more.
What You Need to Get the Job Done
Knowledge of data warehouses and data marts
Experience modeling data across a wide range of business systems and use cases
An extroverted personality ready to engage with business leaders and stakeholders
An excitement around and desire to evangelize data modeling methodology
Ability to quickly gain data domain knowledge in multiple areas
Demonstrated SQL skills
UDF programming abilities
Exposure to various data modeling methodologies and use cases
Strong understanding of Kimball data modeling methodology
Experience with Databricks, Snowflake, Redshift, Vertica, Greenplum, or other similar engines
Ability to automate data modeling pipelines with tools like dbt
Git-based team coding workflows
Cloud-based computing environments like AWS and GCP
What Will Make Us REALLY Love You
Python programming
Strong experience with Databricks and Snowflake
Experience with streaming data
What You'll Love About Us
Great Company Culture. We've been recognized by multiple organizations like Inc, Salt Lake Tribune, Glassdoor, & Comparably for our great workplace culture.
Make an Impact. We care about your individuality by giving you freedom to grow and create within the company, regardless of your position.
Rest and Relaxation. 4 weeks paid time off, 11 paid holidays, and we pay you to go on vacation (ask us about this)!
Health Benefits. Medical with HSA and FSA options, dental, and vision.
Prepare for the Future. 401(k) with a generous company match, access to a personal financial planner, and both legal and life insurance.
Financial Peace University. We pay for a one year subscription and you walk away with financial savvy and a bonus.
Give back. Get paid to give your time to the community: ask us about this!
Educational Benefits. Whether you are a previous student, or currently enrolled in higher education, we can help cover some of those expenses.
Amazing Office Amenities. We've got incredible benefits at our Draper headquarters including a full size gym, pickleball courts, a great office cafe, and free fountain drinks! Ask us more about our office!
In-Person Onboarding! All new hires get to experience our in-person onboarding class, Bamboo Beginnings, at our Draper, UT headquarters! Ask us more about Bamboo Beginnings!
Flexible Work Models. In-office, work-from-home, or hybrid, depending on position and location.
About Us
Our mission is simple: we want to set people free to do meaningful work. People love our software—and it turns out that people love working here too. We've been recognized as a "Best Company to Work For" and we're proud of our team for creating software that makes an impact in the lives of HR pros and employees all over the world.
BambooHR is committed to the full inclusion of all qualified individuals and will ensure that persons with disabilities are provided reasonable accommodations throughout the hiring process. If you would like to request accommodations, please let your recruiter know.
BambooHR is An Equal Opportunity Employer--M/F/D/V
Because our team members are trusted to handle sensitive information, we require all candidates that receive and accept employment offers to complete a background check before being hired.
For information on California Privacy Policy, click here.
Seniority level
Entry level
Employment type
Full-time
Job function
Information Technology
Industries
Technology, Information and Internet
Referrals increase your chances of interviewing at BambooHR by 2x