Database Engineer

| Chicago

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

Technology we use

  • Engineering
    • PythonLanguages
    • RLanguages
    • RubyLanguages
    • ReactLibraries

Location

"With a central location in Chicago’s Loop, our newly renovated office depicts glass conference rooms named after famous scientists!"

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 does your typical day look like?

Even though our department has the primary responsibility for our customers' success, we work with people from every single department to make it happen. Helping our clients succeed is something that every department actively wants to be involved in.

Sean

Team Lead, Solutions Architects

What are some things you learned at the company?

At Civis, I get to use my interest and abilities in science to solve real problems that matter to real people. I get to learn from my colleagues every day, and often get to teach in the places where I'm the one with expertise. There's a real diversity of backgrounds, interests, and experiences.

Katie

Director of Data Science

What are Civis Analytics Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Open door policy
Group brainstorming sessions
Open office floor plan
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.
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

Additional Perks + Benefits

Parental Leave. Short & Long Term Disability + Life Insurance. Halloween Costume Contest, Monthly Birthday Celebrations, Happy Hours, & Other Fun Events!

More Jobs at Civis Analytics16 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Internships
Internships
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Internships
new
Chicago
Internships
new
Chicago
Internships
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago