Data Engineer

Company:
Location: New York, NY 10002

*** Mention DataYoshi when applying ***

About Amplify

Amplify Partners, one of Washington’s 100 Best Places to Work 2019 and 2020, is a Pacific NW company focused on creating a new approach to consulting. We invest in our consultants through mentorship, advancement, and empowerment. We believe in complete transparency with our clients, even when transparency is hard. We bring our thought leadership to the table and execute with rigor to develop meaningful long-term partnerships with our clients.


Job Description

Amplify is looking for an Eastern Time Zone-based Data Engineer to join our growing team and collaborate with our Paris team. You will be designing pipelines and warehouses to model data from multiple sources that will allow us to derive business insight. Using AWS and open-source technologies, such as Airflow and Spark, you will design and build our next-generation ETL pipelines and data models.


Responsibilities


  • Build data pipelines and Python-based ETL tools for acquiring, processing, and delivering data
  • Develop data models and schemas in our data warehouse that enable performant, intuitive analysis
  • Handle the challenges that come with managing terabytes of data
  • Collaborate with business leaders and analysts to define key metrics and build reporting to monitor and understand company performance
  • Develop the server applications and APIs that are used by our Data Team

Qualifications


  • 3+ years of experience as a data engineer, business intelligence analyst, or in a highly analytical role
  • 3+ years of experience with a scripting language (preferably Python) for data processing and analysis
  • Experience designing SQL tables, choosing indexes, tuning queries, and optimizations across different functional environments
  • Experience writing complex SQL queries and using a BI tool

Additional Qualifications


  • You have a passion for sharing the value of data and communicating insights to a broad audience with varying levels of technical expertise
  • You have experience with data lakes and designing and maintaining data solutions using Spark and AWS serverless services such as Kinesis, Lambda, or SQS
  • You have experience administrating, ingesting, and monitoring data in data warehouses such as Amazon Redshift or Microsoft SQL Server
  • You are a self-starter that can work in a fast-paced, distributed environment, as you will be collaborating with our Paris and Lisbon teams

FTE Benefits Package

  • Fully paid medical/dental/vision benefits for you
  • 3 weeks of PTO, plus 10 paid holidays
  • 401(k) program
  • Company and team building events
  • Parental Leave program
  • Amplify You benefit program

*** Mention DataYoshi when applying ***

Offers you may like...

  • EXL Services

    Cloud Data Engineer - Healthcare
    Hartford, CT 06103
  • Nu Skin

    Principal Data Engineer
    Provo, UT 84601
  • Compass Group

    E15 DATA ENGINEER--REMOTE
    Chicago, IL 60651
  • Independent Recruiting

    Senior Data Engineer
    Indianapolis, IN 46262
  • UnitedHealth Group

    Sr Data Engineer - Telecommute
    Eden Prairie, MN 55346