Sr. Data Engineer

New York, New york city, 10045

Permanent

Vacancy expired!

Sr. Data Engineer

NYC (On-site, must be local to NYC area)

Summary:

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
Assemble large, complex data sets that meet functional/ non-functional business requirements
Identify, design, and implement internal process improvements
Automating manual processes
Optimizing data delivery
Redesigning infrastructure for greater scalability
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
Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs
Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader
Work with data and analytics experts to strive for greater functionality in our data systems

Requirements:

Good SQL know-how to write optimized datasources for tableau
Experience with big data tools: RedShift, Spark, Kafka, etc.
Experience with relational SQL and NoSQL databases, including Postgres and Cassandra
Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
Experience with AWS cloud services: EC2 EMR, RDS, RedShift
Experience with report building tools like Tableau
Experience with object-oriented function scripting languages: Python, Java, C, Scala, etc.

Vacancy expired!

Report job