Senior Data Engineer

New york city, New York

Local Only

Full Time

$150k - $160k

Job Description

An NYC-based transportation and healthcare platform that partners up with hospitals to schedule transportation to and from hospitals via ambulances and private cars. Their mobile workforce of thousands of full-time traveling clinicians and our proprietary, AI-powered software leverages robust medical record integrations to drastically improve patient outcomes. They are seeking a Senior Data Engineer to join their team. This is an On-site role (5x/ week).

As a Senior Data Engineer, you will build out Data Warehouses, and ETL Pipelines. Knowledge of Redshift would be ideal. Working with patient, payroll, and billing. Very SQL and Python focused. 

Required Skills & Experience

  • Computer Science degree or relatable
  • 4 years of proven work experience
  • Experience in concepts and structures of Data Warehouses
  • SQL knowledge with ability to write optimized data sources for Tableau
  • Experience with big data tools: RedShift
  • Experience with relational SQL and NoSQL databases, including Postgres
  • Experience with AWS cloud services: EC2 EMR, RDS, RedShift
  • Preferred experience with report building tools like Tableau
  • Experience with object-oriented function scripting languages: Python, Ruby, etc.



What You Will Be Doing

  • Plan and set up a new Data Warehouse in Amazon Redshift:
    - Define the data catalogue
    - Optimized data transformation for our BI tool 
    - Implement a full reproducibility of all data changes
  • Create and maintain optimal data pipeline architecture 
  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using MySQL, RedShift
  • Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics
  • Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader


The Offer

You will receive the following benefits:

  • Vision plan
  • Annual bonus
  • Health and Dental Insurance
  • 401(k)
  • PTO


Applicants must be currently authorized to work in the United States on a full-time basis now and in the future.


Motion Recruitment network provides IT Staffing Solutions (Contract, Contract-to-Hire, and Direct Hire) in major North American markets. Our unique expertise in today’s highest demand tech skill sets, paired with our deep networks and knowledge of our local technology markets, results in an exemplary track record with candidates and clients.


Posted by: Mona Yu