Data Analytics Intern

Our Mission:
ButterflyMX is on a mission to empower people to open and manage doors & gates from a smartphone. Our products are installed in more than 15,000+ multifamily, commercial, gated communities, and student-housing properties worldwide, including properties developed, owned, and managed by the most trusted names in real estate. Our features are designed for developers, owners, property managers, and tenants and our products lower operating costs and improve tenant satisfaction.

Our Solution:
Developers and owners no longer need to run building wiring or install in-unit hardware. Property managers can grant building access, revoke permissions, and review entry logs from an online dashboard. Residents can open doors from their smartphones, issue visitor access, and see who is trying to enter the building.

Our Culture & Values:
Fantastic people are the key to our success. As a distributed, primarily remote workforce, we’re looking for more intelligent, passionate, collaborative, ai-forward, and down-to-earth individuals to join our growing team. We’re driven by a shared commitment to excellence and innovation, grounded in our core values: We delight our customers, We take ownership, We are a community of collaborators, We speak up, We think big and do small, and We are tenacious.

The Data Analytics Intern would be helping restructure the joins performed in workbooks in Sigma into reusable data model documents that’ll be replacing redundant joins in said workbooks. The first 2-3 weeks will be dedicated to learning the ropes around our data stack, familiarizing themselves with our database, addressing smaller ad-hoc requests, and handling said responsibility. After familiarizing themself with the data, in the following 4-8 weeks we’ll be adding on the responsibilities of identifying and fixing data integrity issues, assisting in receiving larger requests for reports, working on minor changes in .dbt models, and suggesting larger organizational changes to our Sigma reporting structure. We’ll be maintaining this same level of responsibility for the remainder of the internship.

Requirements

Minimum Qualifications:

• Proficiency in Excel or other spreadsheet tools 
• Knowledge and/or experience working with relational databases
• Strong organization, communication, and time management skills
• Proficiency in SQL and visualization tools 

Preferred Qualifications:

• Experience using Sigma Computing or other BI tools
• Data modeling/analytics engineering experience using tools like .dbt 
• Based in Orange County or LA (for in-person training), or west coast timezone

Benefits

• Comprehensive Medical (ButterflyMX covers 90% of the cost), Dental, and Vision plans (ButterflyMX covers 100% of the cost) starting day 1
• 401(k) plan with a match
• 13 paid holidays, 25 PTO days
• Paid Family Leave
• Employee Assistance Program
• Quarterly self-care stipends
• Access to optional benefits including pre-tax flexible healthcare spending accounts (FSA and HSA), Dependent Care FSA, and Commuter Benefits, as well as optional Supplemental Life, AD&D, Hospital Indemnity, Disability, Legal, Accident, Critical Illness, Pet, and Personal Liability Insurance
• And more!

ButterflyMX is an equal opportunity employer and we value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. You must have the authorization to work in the US to become an employee. We strive to create an accessible and inclusive experience for all candidates and employees. If you need reasonable accommodations during the application or the recruiting process, please let our recruiting team know.