Randstad - New York, NY
posted 2 months ago
As a Data Solutions Architect, you will play a pivotal role in leading the integration of complex data systems utilizing AWS and Redshift. Your primary focus will be on streamlining data flows across various platforms, including Salesforce and Adobe Analytics. This position demands a strong technical background and a comprehensive understanding of data-driven marketing strategies. You will be responsible for architecting and implementing solutions that integrate the in-house Customer Data Platform (CDP) with a centralized data warehouse, ensuring that data is efficiently processed and accessible for analysis. In this role, you will develop and maintain automated data ETL (Extract, Transform, Load) processes that connect disparate data sources such as Salesforce, Eloqua, Adobe Analytics, OnDemand, and Showpad to the centralized data warehouse. You will design, develop, and maintain automated data ETL workflows from various database platforms, ensuring that data is stored in 'Fit for Use' relational tables. Your analytical skills will be crucial as you analyze and interpret data from multiple database sources, including relational structures, dimensional data models, and cubes. Additionally, you will build and maintain API connections to integrate ad-hoc platforms with the centralized data warehouse. Your expertise in extracting, cleaning, and transforming data before ingestion into the Data Warehousing platform using tools such as SQL, Alteryx, and others will be essential. You will also ensure adherence to industry best practices for table schema standardization and data accuracy, contributing to the overall integrity and usability of the data.