Sr Data Engineer

Location: Seattle, WA
Date Posted: 04-26-2018

We are looking for someone who will be the data storage domain expert; that knows how to tune, administer, maintain postgresql, redshift, and other data stores.  This person will do data modeling, work with the BI team to help their existing and ongoing needs and determine how we should store data to support fast API development, as well as answer the business questions the BI team is trying to solve.  Should be able to write code in Python, mainly API’s.

Your responsibilities:  

  • Operate and maintain our relational and non-relational databases, along with our ETL pipelines & data lakes, and occasionally help users with ad hoc data analysis.
  • Administer database users, roles and ensure best security practices are upheld.
  • Architect software with scalability, redundancy, and seamless netsplit survival/recovery
  • Help build APIs that scale for both internal and external consumption by contributing to database selection, design, and optimization.
  • Build and maintain the continuous integration & deployment pipeline for data related projects.

Your qualifications:

  • Solid Postgres experience is a must. 
  • You consider yourself a SQL expert. 
  • Expert at crafting queries and designing performant database schemas, with and without ORMs.  
  • Experienced administering, maintaining and providing security for database systems and users.
  • Experienced using Python with relational and non-relational databases. (Django or Flask experience is a huge plus.)
  • Experienced working with cloud based providers such as AWS, Azure and Google Cloud Platform.
  • Experienced building REST APIs and server side web development a plus.
  • Experienced with agile methods, and like to work collaboratively with others.
  • Passionate about building software and designing database systems the "right" way and teaching that software craftsmanship mentality to others.

Technologies we use:

  • Primary languages: SQL, Python
  • Secondary languages: Unix Shell, GoLang
  • Datastores: PostgreSQL & MySQL in Amazon RDS, AWS DynamoDB, Redis, Redshift
  • Streaming Data: AWS Kinesis, Firehose, SNS, SQS
  • Orchestration tools: Docker, Kubernetes, Amazon ECS
  • Frameworks such as: Django (+ Django-Rest-Framework), Flask, AWS Lambda
  • Configuration management: Ansible, CloudFormation
  • Operating systems: Linux Operating System (Ubuntu, Debian primarily)
  • Protocols: SIP, SMPP, HTTP
  • SIP servers: Kamailio, FreeSwitch, Asterisk
this job portal is powered by CATS