Key Responsibilities:API Integration with AWS services for tools such as Asana, ELM, and Sphera to enable seamless data transfer and communication.Design, configure and implement robust API architectures to ensure reliability, scalability, and security.Design, configure and implement data lake formation strategies leveraging AWS services.Develop processes to ingest and move existing data sources such as SIPP, Excel, etc. into a single database e.g., Amazon Redshift.Create sustainable ETL Extract, Transform, Load jobs to manage different data sources and changes to data.Automate AWS Glue jobs to trigger when new files are added to S3 or when new data is ingested via APIs into the data lake.Connect Quicksight dashboards to the new data lakedatabase, replacing existing data sources.Optimize existing dashboards for performance and usability.Explore methods for implementing Single SignOn SSO that are based on permission teamsAWS IAM roles to address current SSO issues.Requirements:Bachelors degree in computer science, Engineering, or related field5 years experience as a Solutions Architect or similar role.Expertise in integrating APIs with AWS services.Strong understanding of data lake architectures and experience with AWS data services e.g., Redshift, Glue, S3.Proficiency in Extract, transform, load ETL tools and processes.Experience with data visualization tools, preferably Amazon Quicksight.Solid understanding of identity and access management IAM concepts and AWS IAM roles.Excellent problemsolving skills and ability to think strategically.Strong communication and interpersonal skills, with the ability to collaborate effectively with crossfunctional teams.AWS Certified Solutions Architect preferred.
