Analytics Engineer

About Beam:Beam was founded in 2012 by three engineers who saw the opportunity to modernize the dental benefits industry using technology. The first product was the Beam Brush, which was one of the earliest examples of the Internet of Things in healthcare. Today, Beam Benefits is available in 40+ states and has expanded beyond dental.

Beam is now simplifying and modernizing a robust suite of ancillary employee benefits through an intuitive digital platform, self-service tools, AI-powered pricing, and support from Beam’s helpful representatives. This winning combination allows us to deliver a simple, smart, and wellness-focused experience for brokers, employers, and members.

Joining Beam Benefits Means:Joining Beam Benefits means working in a complex and dynamic business that operates simultaneously across insurance, employee benefits, and technology. You’ll be supported and encouraged to improve every day while collaborating with a diversely skilled team.

Our energizing, committed, and fun work environment empowers you to take ownership of your subject matter and work. You’ll also join us in our mission to forever change the way people access benefits, all while embodying high character, emotional intelligence, and exceptional talent.

What We’re Looking For:Beam is looking for an experienced Analytics Engineer to join our Engineering Team. In this role, you will be working cross-functionally with business domain experts, analytics, and engineering teams to build and maintain our data warehouse. You will have a significant part in building a solid data foundation for a data-driven company.

What You Will Do:

• Work with engineering, product, and analytics teams to understand and scope requirements to improve the useability, quality, and reliability of data for the business
• Collaborate with Data Engineers to further the development of our overall data platform
• Drive the development and maintenance of our data warehouse
• Apply software engineering best practices to uplift analytics processes
• Work with the data team to develop and maintain data quality rules, documentation and definitions

What Skills Will Help You Be Successful:

• Data warehousing experience, preferably with AWS or GCP at a hyper-growth company
• Advanced SQL concepts such as window functions
• Proficient with Python or another programming language
• Experience with or awareness of dbtBI visualization and administration experience such as Looker or Tableau
• Familiarity with data pipeline platforms such as Fivetran or Stitch
• Awareness of orchestration tooling such as Dagster or AirflowAbility to read Ruby code is a plus
• Experience working with SaaS data such as Salesforce, Zendesk, etc is a plus