Keyrus USA, Inc. Senior Data Engineer in New York, New York
Senior Data Engineer needed in New York, NY. Responsible for: Engineer and automate integration of multiple APIs (Salesforce, Twitter, Facebook, Yahoo, Freewheel, AOL) to efficiently feed data into Redshift, providing actionable metrics to end users; Create end-to-end analytics platform solutions utilizing ETL pipelines, both backend and front-end tools - Snaplogic, SSIS, SSAS, Alteryx, Python, Tableau, Power BI to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics; Implement and maintain Tabular solutions with SQL Server Analysis Services, including querying to solutions using Oracle SQL procedures; Develop and implement a system to update PowerPoint files based on Redshift data using VBA; Design and engineer data platforms using modelling methodologies like Data Vault, 3NF, Dimensional to provide auditable long-term historical storage of data from multiple data sources for both structured and unstructured data; Maintaining AWS Lambda framework to automate the import sources of data to Redshift; Use Python scripts to sync FTP with S3 to achieve near real-time updating of logs in Redshift; Create monitoring platforms and data quality mechanisms using Splunk and Quilliup to achieve stable high-availability systems to minimize downtime, meet SLA requirements and maintain high quality of information; Automate architecture and infrastructure deployment using Terrafom, Ansible and Packer as well as redesigning infrastructure for greater scalability; Create and maintain BI dashboards using Power BI, in order to track effectiveness of initiatives and surveys done, as well as overall sales overview metrics like total volume, seasonality, and category share; Implement security models as required to restrict data access based on organizational hierarchies; Implement security and data protection; Engineer programs with cloud message APIs and usage of push notifications. Must have a minimum of a Bachelor's Degree in computer science or related field and 3 years of experience in BI data engineering. Mail resume to Recruiter, Keyrus USA, Inc., 252 W. 37th Street, Suite 1400, New York, NY 10018. Schedule: Monday-Friday, 9:00 a.m.-5:00 p.m.