Database Engineer at Civis Analytics

| Chicago
!Sorry, this job was removed at 4:47 p.m. (CST) on Thursday, November 21, 2019

What we do

Civis Analytics helps leading businesses, nonprofits, and government use data to identify, attract, and engage customers, constituents, and citizens. With a blend of proprietary data, technology and advisory services, and an interdisciplinary team of data scientists, developers, and survey science experts, Civis helps organizations stop guessing and start using statistical proof to guide decisions. Learn more about Civis at www.civisanalytics.com.

What we are looking for

Are you a self-starter? Do you want to work where you can make an immediate impact? Civis is looking for a Database Administrator to join our team!

As a Database Engineer, you will be responsible for improving how Civis manages and supports Redshift, our product’s primary data warehouse, as well as with other database technologies. You will serve as a subject matter expert in all things database and work on initiatives across multiple departments to implement best practices and improve the user experience of our clients.

Responsibilities

  • Work with our Client Success organization to develop tools that automate database administration and instill best practices.
  • Help our Client Success organization troubleshoot and respond to database related support requests from our clients.
  • Consult with various teams to tune SQL queries.
  • Serve as a subject matter expert for database security best practices, partnering with our Cybersecurity team.
  • Work with Systems and Data Engineering teams to optimize our database infrastructure.
  • Consult with engineering teams on how to optimize the use of Redshift and other databases in our software.
  • Stay up-to-date with database releases and notify Client Success and Engineering teams of changes that could impact the stability of our products.

Minimum Requirements

  • 2-3 years’ experience working with and administering distributed databases
  • Comfortable navigating the database system catalog
  • Comfortable working with cloud hosted infrastructure
  • Ability to work both independently and collaboratively with peers, across teams, and with management
  • Ability to communicate technical concepts to both non-technical business users as well as client technical stakeholders
  • An ability and eagerness to constantly learn and teach others

Preferred Qualifications

Experience with one or more of the following:

  • 2-3 years’ working with and administering Redshift
  • Database permission management and best practices
  • Optimizing database workload management
  • Tuning SQL queries via both SQL tuning and optimizing schema design
  • Working with both very wide (1,000+ columns) and large (500+ GB) data sets

Who we are

At Civis, we have opportunities for applicants who are newcomers, seasoned professionals, and anywhere in between. Our teams are energized by complex challenges and value diversity of thought. Opportunities to stand out and inspire happen daily and we trust and encourage you to act on your ideas – no matter how big they are. We offer you the tools and community you need to do your best work. Each of us is committed to holding ourselves accountable for results, challenging the status quo and finding new ways to grow our company and each other.

Why Civis Analytics?

  • The opportunity to be part of a growing tech startup focused on continued learning, mentorship, and internal promotion 
  • Competitive benefits including flexible PTO, 401K match with immediate vesting, as well as health, dental, and vision benefits
  • Downtown open office environment near great restaurants and all public transportation options

Civis embraces the individuality of our employees and we celebrate each other's differences. Our products, services, and culture benefit from and thrive on the unique perspectives brought by each person in our Civis community. We're proud to be an equal opportunity workplace, and we are committed to equal employment opportunity regardless of race, age, sex, color, ancestry, religion, national origin, sexual orientation, gender identity, citizenship, marital status, disability, or Veteran status. If you have a disability or special need that requires accommodation, please contact [email protected]

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States.

EEO IS THE LAW

EEO Supplement

Pay Transparency 

Read Full Job Description
Apply now

Technology we use

  • Engineering
    • PythonLanguages
    • RLanguages
    • RubyLanguages
    • ReactLibraries

Location

As one of the popular hubs for tech startups, Chicago is the perfect backdrop for Civis's growing team.

An Insider's view of Civis Analytics

What's something quirky about your company?

One of my favorite parts about Civis is the culture of learning—talking about academic papers is encouraged as well as sharing weird facts about things people are interested in. I also love the people at Civis because they genuinely care about each other and also serving the wider world.

Evelyn

Software Engineer

What are Civis Analytics Perks + Benefits

Civis Analytics Benefits Overview

- The opportunity to be part of a growing tech startup focused on solving interesting and meaningful problems, invested in internal promotion, and committed to fostering a diverse, equal and inclusive workplace. 
- Competitive benefits, including unlimited PTO, 401K match with immediate vesting, health, dental, and vision benefits, paid parental leave, breastfeeding support including breastmilk shipping services for traveling moms, flexible work from home policy, commuter benefits, wellness initiatives including weekly group meditations, monthly on-site massage therapy, and pet insurance.
- Modern office, conveniently located in the Loop. Close to public transportation, great restaurants and beautiful city views.

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Diversity, Equity, and Inclusion; Civis-for-Good; Reading Groups/Journal Clubs
Open door policy
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Acme employees can contribute up to $2700 annually to their FSA.
Disability Insurance
Disability insurance covers 60% of annual salary up to $6000 monthly maximum payout.
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Life insurance is equal to 50000 times an employee's annual salary.
Pet Insurance
Wellness Programs
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Acme Co. provides employees with a 401(k) matching plan managed by [provider]. We match 1% of contributions up to 100% of an employee's annual gross pay.
Child Care & Parental Leave Benefits
Generous Parental Leave
We provide up to 12 weeks of parental leave for the primary caretaker. Acme Co. also provides 8 weeks of leave for the secondary caretaker.
Flexible Work Schedule
Family Medical Leave
Employees who have been with the company for 12 months are eligible for 12 weeks of family medical leave.
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Our employees receive 4 hours per year of paid volunteer time.
Paid Holidays
Paid Sick Days
Civis believes that if you are sick you should stay home. We have a flexible sick policy with no stated limits.
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Happy Hours
Professional Development Benefits
Job Training & Conferences
Acme Co. offers employees professional development opportunities like The ability to attend job related conferences and seminars.
Lunch and learns
Cross functional training encouraged
Promote from within
More Jobs at Civis Analytics1 open job
All Jobs
Operations