Pay rate range - $90/hr. to $94/hr. on W2 100% Remote Must Have API Integrations – configuration is key AWS glue data Data Lake formation and management Bachelor’s degree in computer science, Engineering, or related field 5+ years’ experience as a Solutions Architect or similar role. Data engineer/analytics Job Description 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., 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 lake/database, replacing existing data sources. • Optimize existing dashboards for performance and usability. • Explore methods for implementing Single Sign-On (SSO) that are based on permission teams/AWS IAM roles to address current SSO issues. Requirements: • Bachelor’s degree in computer science, Engineering, or related field • 5+ 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, and transform load (ETL) tools and processes. • Experience with data visualization tools, preferably Quicksight. • Solid understanding of identity and access management (IAM) concepts and AWS IAM roles. • Excellent problem-solving skills and ability to think strategically. • Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams. • AWS Certified Solutions Architect preferred.