Please Note: This is a Utah-based hybrid position which will require some regular in-office days each week.
Essential Job Duties
Our data engineering team is expanding. We believe data and algorithms can be a bionic arm to do some heavy lifting. Through our mission we have the opportunity to help millions of users in growing businesses achieve more with their teams by providing timely insights and intelligent interactions.
As a Senior Data Modeler 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.
Your initial areas of focus will include:
- 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
- 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 advanced SQL coding and optimization skills
- UDF programming abilities
- Exposure to various data modeling methodologies and use cases
- Strong understanding of Kimball data modeling methodology
- Experience with modern analytics engines, systems, and tools
- Ability to automate data modeling pipelines with tools like dbt
- Git-based team coding workflows
- Cloud-based computing environments like AWS and GCP
Bonus Skills (Not Required, So Apply Anyway!)
- Experience developing attribution, sales funnel, customer retention, financial, or product usage models
- Knowledge of common business KPIs across multiple data domains
- Deep experience modeling data sourced from Salesforce, Marketo, Gainsite, Zuora, or Pendo
- Strong experience with Databricks and Snowflake
- Experience with streaming and change data capture data
- Python programming
Beyond the technical skills, we’re looking for individuals who are:
- Clear communicators with team members and stakeholders
- Analytical and perceptive of patterns
- Creative in modeling and coding
- Detail-oriented and persistent
- Productive in a dynamic setting
If you love to learn, you’ll be in good company. You’ll likely have a Bachelor’s degree in a quantitative field, or equivalent experience in working with 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.
•
Last updated on Jan 8, 2024