Company Overview:

Beam (fka Edquity) is an anti-poverty technology company that helps institutions and governments administer various cash assistance programs in a manner that is faster, more equitable, and more effective. Beam works with over 40 postsecondary institutions and multiple local governments and has administered over $110M in funding in an average of 25 hours from application.

Beam is a Series A stage, venture-backed company and has received support from many of the leading impact and postsecondary success investors, and has also received non-dilutive support from foundations like the Bill and Melinda Gates Foundation.

Job Overview:

Beam is seeking an experienced Data Analyst II who is passionate about enhancing financial stability and social mobility for Americans.

The data team at Beam is small but mighty. We are seeking an experienced data analyst who wants to add value across multiple teams, including but not limited to Operations, Product, Design, Reporting products, and Data Infrastructure. The ideal candidate for this role has worked with similar organizations in a data function and has technical expertise applying SQL and Python and/or R to analytics and data problems. They should have experience with building data products (e.g. dashboards) from start to finish, including requirements gathering, pipeline design, prototyping and automation. At Beam, we value stewardship and solutions, so this candidate should have a strong sense of ownership and independence.

We are building a robust data analytics suite on an AWS toolset. Tools we use include RDS, S3, Glue, and Redshift. We are building our data viz out in Glean and we work with Heap for product analytics. Familiarity with these or similar tools is preferred.

Ideal Start Date: by January 2023

What you might do:

• Serve as a primary point of contact for reporting requests from our partners
• Design and develop scalable data models where highly complex data relationships exist
• Architect and maintain highly automated and scalable ETL/ELT data pipelines
• Provision, optimize, and maintain data feeds to external systems
• Create visualization and reporting as needed
• Creating well-written technical documentation
• Design new functionality in our existing components for the team to leverage
• Evangelize best practices around data and team processes

This posting lists a lot of qualifications, but we recognize that the right candidate may not match 100% of the job qualifications. Importantly, we want you to grow with the company, so we are open to a candidate who is willing to grow in core competencies. Therefore, we encourage you to apply if you can demonstrate many, but not all of these skills and competencies and are willing and excited to grow!

Core Skills, Behaviors, and Experiences:

• Experience writing SQL and Python, solving complex data problems, good data modeling, as well as building automated data pipelines
• Expert at writing and optimizing SQL scripts
• Comfortable reading, editing, and potentially contributing to Python or PySpark scripts.
• Be a quick learner, self-starting, and have the ability to maintain and build within a horizontal and vertical scaling data system
• Experience with cloud data environments
• Experience building data visualizations in dashboarding software
• Experience working in government technology or the social impact space is not required but is a plus
• Experience with statistical analysis, including A/B testing, regression, and contingency analysis methods is not required but is a plus

Compensation and Benefits:

The salary range for this position has been benchmarked in relation to the scope of the role, market rate, company stage, and internal equity. The salary for this role will be between $90,000 - $110,000. Where a candidate falls within the band is determined by skillset, experience level, and geographic location. In addition to base salary, this role will come with a total compensation package that includes equity shares and competitive benefits. Some of our benefits include:

• Fully paid health insurance (Medical/Vision/Dental)
• Unlimited PTO, Sick and Mental Health Benefits
• 11 paid company holidays
• 401k with a 4% match
• Generous parental leave
• Annual Professional Development Stipend
• One-time Home Office Setup Stipend
• Equity in Beam
• Many more!

Beam (fka Edquity) 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.