GoGuardian
El Segundo, CA

Database Manager at GoGuardian

| El Segundo
Sorry, this job was removed at 4:05 p.m. (PST) on Thursday, February 27, 2020
Find out who's hiring in Los Angeles.
See all Data + Analytics jobs in Los Angeles
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.

See More
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Where we are

2030 E Maple Ave, El Segundo, CA 90245

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
Previous
Next

What are GoGuardian Perks + Benefits

Culture
Volunteer in local community
GoGuardian participates in local volunteer activities such as AngelHacks Hackathon, Teens Exploring Technology (TXT) and LA Food Bank.
Friends outside of work
Eat lunch together
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
On-site meditation twice per week
Onsite Gym
Team workouts
Team fitness initiatives include weekly in-office yoga classes
Retirement & Stock Options Benefits
401(K)
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
We provide up to 12 weeks of parental leave for all parents
Vacation & Time Off Benefits
Generous PTO
We offer a flexible time off policy for full-time exempt employees. Full-time non-exempt employees accrue 3 weeks of PTO annually. We also offer a paid 2 week end of the year holiday break.
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Company Outings
Free Daily Meals
Game Room
Stocked Kitchen
Happy Hours
Parking
Professional Development Benefits
Lunch and learns
Cross functional training encouraged
Promote from within
Continuing Education stipend
We offer a $1200 learning stipend annually for personal & professional growth

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.

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

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

GoGuardian Careers In El Segundo
6

All Jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Project Mgmt
Sales
Tap to close

Data Engineering Manager

GoGuardian
El Segundo
1 day ago
+33
As a manager of engineers, you’ll be responsible for understanding technical projects, ensuring high quality of work, reasonable delivery timelines, motivating a team, providing career growth opportunities, keeping tabs on performance (both rewarding high performers and taking corrective action for low performers) and understanding non-engineering needs/requirements, among other things. Day-to-day, you’ll be keeping engaged with your team (through 1:1s, evaluating code and pull requests, reviewing design proposals, etc.) and driving longer-term initiatives (e.g. changes to a team’s staff, new on-call rotations, quarterly performance reviews, hiring plans, etc.). Additionally, you’ll need to clearly and effectively communicate status of work upwards and be responsible for implementing and supporting larger, team-wide, department-wide or company-wide initiatives. Both your direct reports and your manager should trust you for support, autonomous execution and timely/accurate feedback.

Business Development Representative

GoGuardian
El Segundo
2 days ago
+33
As a Business Development Representative, your role will be to seek new business opportunities by contacting and developing relationships with potential customers. You’ll work to generate interest in the GoGuardian offerings through daily engagement with prospects and leads. You’ll use your top-notch communication skills to cultivate strong relationships with customers from first contact until you pass on the deal to the sales team to close. 

UX Design Lead

GoGuardian
El Segundo
2 days ago
+33
The GoGuardian UX Team is a close-knit group of thinkers and tinkerers who believe the best products are made with curiosity, optimism, and deep enthusiasm to craft products that make people’s lives better. We're looking for a Senior UX Designer who balances day-to-day design work with broader strategic planning in partnership with Research, Engineering, and Product Management to produce engaging, consistent, and innovative experiences for GoGuardian products.

QA Engineer

GoGuardian
El Segundo
2 days ago
+33
As a QA Engineer, you will support and help launch new features across multiple teams. You will be expected to develop and document strategies for testing, execute the strategies, and implement automation. You will also help shape best practices across the company, and be an advocate quality assurance in development. As a QA Engineer, you will play a key role in shaping our products from the early stages of development, and should have great communication skills in order to be able to provide clear and concise feedback to our teams.

Software Engineer - Full Stack

GoGuardian
El Segundo
2 days ago
+33
As a full stack engineer at GoGuardian, you’ll help build, optimize and maintain our infrastructure and applications that support millions of students and educators every day. You will work on production code and build rich feature sets that support the complex problems in education. You’ll be a key member of our engineering team, helping to embody the principles of fluidity, critical thinking, innovation, and collaboration.

Sr. Delivery Manager

GoGuardian
El Segundo
2 weeks ago
+33
The Sr. Delivery Manager will be managing Scrum teams using Agile, Scrum, Kanban. They may also manage enterprise projects utilizing various other project management methodologies.