Job Description :
Title::::ETL Developer (AWS Environment)
Location: NYC ,NY
Position:::Contract to Hire


MAIN DUTIES/FUNCTIONS:
Design, build, maintain, and optimize components of enterprise data architecture required
to meet the analytics and production data needs of the business using a range of tools
including Python, Amazon Redshift, Amazon Athena, among others
Architect and develop applications to onboard batch, micro-batch, or real time streaming
from a diverse array of data sources into the Enterprise Data Lake in AWS.
Partner with business stakeholders and Business Intelligence (BI) developers to define
data requirements and ensure accuracy of all metrics and master data
Develop and implement dimensional data models in a data warehouse platform to
optimally deliver on the needs of business stakeholders
Design, develop, and maintain ETL required to populate dimensional data models
Establish clean, robust master data for use across business functions
Evaluate and inform selection of technologies to build and optimize MSG39;s data solutions
Collaborate with business users and Analysts to triage and resolve issues across all areas
of MSG39;s data solutions

QUALIFICATIONS:
3 + years data platform development experience
Bachelor39;s degree in Computer Science, Engineering or related field
Expertise in dimensional data modeling, ETL, SQL coding plus working knowledge of
Big Data solutions and noSQL databases
Expertise with scripting languages (Python, Perl, Shell)
Experience with MPP data warehouse platforms (Redshift, Netezza, Teradata,
Greenplum)
Experience working in cloud-based environment (AWS, Azure, Google)
Experience working with ETL tools & IDE (SAP Data Services, Informatica, Talend,
Pentaho, Eclipse, Datagrip)
Strong problem solving and analytical skills
Strong project management and coordination skills
Excellent communication skills with ability to engage with business stakeholders to
effectively translate business requirements into technical solutions
High level of enthusiasm for building innovative data solutions