Applied Data Engineer, ETL at Civis Analytics

| Chicago
!Sorry, this job was removed at 1:06 p.m. (CST) on Wednesday, November 6, 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

In this role, you will structure, transform and clean complex data sets to enable our Applied Data Science Team to perform and deliver exceptional data science solutions to our clients. You will also collaborate internally and with our clients to build elegant and sustainable data pipelines for our clients. Role available in Chicago, IL or Washington, DC.

Responsibilities

  • Ingest data using connectors built by our Engineering Team.
  • Collaborate with clients and client-facing teams to define user requirements and database design specifications for our clients’ needs.
  • Transform data based on business requirements.
  • Apply data validation and/or software testing techniques to ensure data processes and pipelines are working properly.
  • Create pipelines that deliver data error-free and on-time with features such as logging, fault tolerance, notifications, and scalability.
  • Document and train others on data pipelines.
  • Serve as a technical resource in resolving issues related to data pipelines.
  • Work closely with client-facing teams.
  • Develop your technical skills by working with our Engineering Team to adhere to best practices.
Minimum Requirements
  • Passion for figuring out complex datasets and creating elegant solutions.
  • Demonstrated experience working with data and databases.
  • Demonstrated track record working with data warehouse concepts.
  • Experience using SQL, Linux, and Python or other query and scripting languages to aggregate and transform data.
  • Experience with data quality processes, data quality checks, validations, data quality metrics, definition, and measurement.
  • Ability to construct and debug complex SQL queries.
  • Prior exposure to working with large datasets.
  • Familiarity with source control (git preferred).
  • Ability to operate with cross-functional teams (for example, customer support, data science, engineering, and sales), including a willingness to balance the changing needs of a client-facing team with a demand for data engineering best practices and the ability to communicate the tradeoffs.
  • Strong communication and teamwork skills.
  • US work authorization
Preferred Qualifications
  • Bachelor’s degree in an analytical subject (statistics, math, economics, physics, engineering, business, political or social science, computer science, etc.).
  • Working on data pipelines in support of data analytics or data science applications.

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 us [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 Analytics5 open jobs
All Jobs
Data + Analytics
Design + UX
Dev + Engineer
Operations
Sales
Data + Analytics
new
Chicago
Developer
new
Chicago
Design + UX
new
Chicago