Database Manager

| El Segundo
Join us in our mission to provide students with a safe and stimulating learning experience. At GoGuardian, you’ll get to work with friendly and motivated people to solve challenging problems in a great environment. At GoGuardian, we pride ourselves on bringing the very best talent to empower millions of student lives in the most impactful way. You’ll be joining a talented science and analytics team at a company with a highly capable data infrastructure team.
GoGuardian is looking for a motivated database architect/administrator to help plan, maintain, and constantly improve our data warehouse. This is an exciting opportunity to transform an entire company by working closely with business decision makers, scientists, analysts, and researchers. We need a candidate experienced in OLAP systems, ETL operations, dimensional modeling, and business intelligence processes interested in cooperating with engineers and analysts to build a highly performant BI-focused data warehouse.

Responsibilities:

  • Partner with business intelligence analysts to identify important company data sources and participates in change management processes related to these data sources
  • Develop overall dimensional model for the data warehouse 
  • Develop reliable ETL processes to bring company data sources into an OLAP-focused data warehouse optimized for analytics and dashboarding
  • Monitor performance and completion of ETL processes, constantly attempt to optimize and improve ETL operations
  • Develop robust automated data quality and integrity tests, hunt down sources of data inaccuracies, develop solutions to ensure eliminate these problems
  • Strive to optimize the performance and cost of all systems related to the data warehouse
  • Ensure 99% uptime for data warehouse and scale warehouse systems as necessary to support demand and business growth
  • Ensure all systems related to the data warehouse are secure and that database backup and redundancy best practices are followed
  • Responsible for development and maintenance of company data dictionary as well as documentation of data warehousing architecture
  • Work with Data Scientists and Business Intelligence Analysts to assess SQL jobs with an emphasis on optimization opportunities
  • Partner with leadership in the company to help support data-driven decision making

Absolute Must Haves Before Applying:

  • Bachelor’s Degree
  • 5+ years experience with warehousing infrastructure and dimensional modeling
  • Experience with Amazon Web Services, specifically Redshift, S3, and EMR
  • Absolute rock-star SQL skills
  • Command line expertise
  • Experience with either Spark SQL, PySpark, or Scala
  • Some experience with infrastructure as code (Terraform, Chef, Puppet)

Bonus Points if you also bring the following:

  • Proficiency in Python and Scala
  • Experience with SalesForce backend structures
  • Experience with Tableau, Looker, PowerBI or other modern dashboarding tools
  • Experience working with data scientists
  • Docker experience

GoGuardian is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. GoGuardian does not discriminate against employees, applicants, interns, or volunteers on the basis of race, religion, color, national origin, ancestry, physical disability, mental disability, medical condition, pregnancy, marital status, sex, age, sexual orientation, military and veteran status, registered domestic partner status, genetic information, gender, gender identity, gender expression, or any other characteristic protected by applicable law.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • GolangLanguages
    • JavascriptLanguages
    • ScalaLanguages
    • SqlLanguages
    • ReactLibraries
    • ReduxLibraries
    • Node.jsFrameworks
    • MySQLDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • SketchDesign
    • ConfluenceManagement
    • JIRAManagement
    • SalesforceCRM
    • MarketoLead Gen

Location

200 N Sepulveda Ave, El Segundo, CA 90245

An Insider's view of GoGuardian

What’s the vibe like in the office?

Exciting! We’ve had tremendous growth and have gone through a lot of changes over the last couple of years, but have maintained the supportive, passionate, and energetic foundations that made me join the company in the first place. The vibe is simultaneously feels relaxed and open, and like everywhere you look, people are solving difficult problems

Terence

Director, Customer Success

What's the biggest problem your team is solving?

Our vision brings tall challenges; one of which is finding ways to sift through nearly insurmountable amounts of data, finding the important nuggets of information, then surfacing it to the right people. By using a combination of machine learning and cutting-edge data science (really), we're building better products for our users.

Zach

Senior Designer

What does career growth look like on your team?

Career growth is something that is talked over, thought through and planned out in open conversation and full collaboration between the team members and the manager of the team. It is clearly defined, from the very first day, as a line connecting your current areas for improvement to when they become areas of excellence.

Yola

Senior Data Scientist

What are some things you learned at the company?

Come in with an open mind, and you will find yourself in a breeding ground for self-discovery. By being given a high level of autonomy to do meaningful work, I have learned what it means to be authentic, lean into my fears, find my voice, build trust, and experience the greatest joy that life has to offer—connecting with others!

Michelle

Software Engineer

What are GoGuardian Perks + Benefits

Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Onsite Gym
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Flexible Work Schedule
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Perks & Discounts
Beer on Tap
Casual Dress
Company Outings
Free Daily Meals
Game Room
Stocked Kitchen
Happy Hours
Parking
Pet Friendly
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences

Additional Perks + Benefits

Relax, recharge, and refresh with weekly yoga classes & guided aromatherapy meditation. Whether you're a golfer or a gamer (or both), there's probably a weekly activity with your name on it.

More Jobs at GoGuardian23 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Data + Analytics
new
El Segundo
Project Mgmt
new
El Segundo
Sales
new
El Segundo
Sales
new
El Segundo
Sales
new
El Segundo
Product
new
El Segundo
Operations
new
El Segundo
Sales
new
El Segundo
Developer
new
El Segundo
Sales
new
El Segundo
Sales
new
El Segundo
Data + Analytics
new
El Segundo
Developer
new
El Segundo
Data + Analytics
new
El Segundo
Design + UX
new
El Segundo
Operations
new
El Segundo
Finance
new
El Segundo
Marketing
new
El Segundo
Project Mgmt
new
El Segundo
Data + Analytics
new
El Segundo
Sales
new
El Segundo
Sales
new
El Segundo