Job Responsibilities:
• End to End responsibility for data modeling (OLTP, OLAP)
• Data analysis experience with writing complex queries, unions, joins and aggregations.
• Data analysis experience using major RDBMS solutions like snowflake, redshift etc
• Experience with ELT, ETL processes using glue, glue brew transformations.
• Use airflow to schedule and time data transfers.
• Understanding of deep JSON structures and partitioning using Kafka, spark, Scala, s3 etc.
• Work with Data Scientist team to build segmentations, ML use cases, forecasting etc
• Experience working with sagemaker, jupyter notebooks for deep data analysis.
• Work with the BI specialists to design develop and enhance connectors to get closer to business use cases.
• Migration of existing custom pipelines to a normalized connector approach
• Help educate CT teams on data integration, validation standards and drive clean ingestion egestion patterns for the platform.
Experience Required: 9+ Years
