Data Engineer
BrainStorm
Software Engineering, Data Science
Posted on Tuesday, May 21, 2024
Company
BrainStorm (www.brainstorminc.com) is a B2B SaaS company that drives digital adoption and organizational change for outstanding companies around the world, including PepsiCo, American Express, Land O'Lakes, Inc., MasterCard International Inc., Mattel, Inc., Panasonic, Merck Company, and more.
BrainStorm thrives on a dynamic and fun-loving atmosphere, paired with a steadfast commitment to excellence. Our high-performing team is composed of self-starters who play a pivotal role in driving our success. Once we walk through the door, it’s definitely ‘Go Time’.
Opportunity
BrainStorm is currently seeking a Data Engineer to help build and drive the overall data, collecting, processing and analytics infrastructure and strategy for BrainStorm. The Data Engineer will help build, design, and drive the data, strategies, processes, and modeling for all aspects of the business, including Finance, Marketing, Operations, and more. BrainStorm takes pride in delivering industry-leading learning experiences for our clients, and the Data Engineer will be instrumental in helping BrainStorm drive more success for our customers through data and analytics. Along with helping current and prospective clients, the Data Engineer will help to drive the monetization of the data being collected, stored, and analyzed at BrainStorm.
Responsibilities
- Be active and involved with the business to design and build new data solutions that correspond to the business and data strategies
- Write SQL-first transformation workflows by creating DBT models
- Develop a variety of data workflows, pipelines, and ETL processes using BrainStorm tools and products
- Create new datasets and processes to power our different systems, run models, empower analytics, or to be used in our visualization tools, like Microsoft PowerBI
- Help develop data quality and governance strategies and automations, aligned to the business and data strategies, to ensure the accuracy and quality of the data
- Build and maintain data that support our Sales, Customer Success, Strategic Partners, and Channel Partners
- Partner with our Sales and Customer Success teams to understand their business goals (Power 10 inside BrainStorm) and help design and iterate on the BrainStorm Data and Analytic Strategy to empower and help these goals reach success
- Appropriately prioritize incoming and existing requests to ensure alignment across teams, with the ability to execute and reach desired and agreed upon deadlines
Must Have
- Strong understanding of ETL, data modeling, and data architecture
- Proficiency with at least one data warehouse (Snowflake, Redshift, Synapse, BigQuery, etc.)
- Experience with at least one relational database (MsSQL, MySQL, PostgreSQL, etc. )
- Expertise in SQL
- Strong communication, interpersonal, problem solving, analytical, and project management skills
- Feels a sense of ownership in whatever they work on
Nice to Have
- Experience with Snowflake
- Experience with DBT
- Experience with NoSQL databases
BrainStorm provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
Medical, dental, 401k, and other benefits are included. The position is available in the American Fork, UT office.
BrainStorm, Inc. is not open to third party solicitation or resumes for our posted FTE positions. Resumes received from third party agencies that are unsolicited will be considered complimentary.