Data Engineer (Analytics) - Join BambooHR

Work Mode: Please note: This is a Utah-based hybrid position which will require some regular in-office days each week.

Essential Job Duties

What You'll Do

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.

Qualifications: 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: Recognized by organizations like Inc, Salt Lake Tribune, Glassdoor, & Comparably for our great workplace culture.
• Make an Impact: Enjoy the 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