**Introduction** You will serve as a leader in defining solutions for clients. You'll be the advocate for the client while guiding the technical team to implementation. **Your role and responsibilities** You will serve as a leader in defining solutions for clients. You'll be the advocate for the client while guiding the technical team to implementation. You'll collaborate with client stakeholders and internal partners to understand the business problem and requirements, constraints of the system to facilitate, iterate and document the design and adoption of a hybrid cloud model. Your primary responsibilities include: * Strategic Advisory for Integrated Solutions: You will act as a trusted advisor aligned to industry trends that develops the framework and integrated solutions that meet the customer's business needs. * Collaborative POC Execution and Solution Development: Collaborate with members of the client and IBMers team to define and execute proofs of concept and minimum viable solutions. * Hands-On Solutions Architecture Ownership: Own the solutions architecture plan while being a "hands-on" builder in a client-facing engagement. * Entrepreneurial Innovation for Client Success: Champion an entrepreneurial mindset and deliver unique value by leveraging industry and technology expertise to drive innovative strategies to accelerate clients' success. * Understand business needs, design, and optimize end-to-end data solutions with AWS platform. * Ensure data architectures comply with enterprise security, privacy, and compliance standards. * Proven experience in migrating from traditional data warehouses (e.g., Oracle) to Redshift while ensuring data consistency. * Expertise in integrating Redshift with BI tools (e.g., Tableau, Power BI) to support business analytics needs. * Hand-on experiences in Redshift architecture, including data modeling, partitioning, and query optimization. **Required technical and professional expertise** * Understand business needs, design, and optimize end-to-end data solutions with AWS platform. * Ensure data architectures comply with enterprise security, privacy, and compliance standards. * Proven experience in migrating from traditional data warehouses (e.g., Oracle) to Redshift while ensuring data consistency. * Expertise in integrating Redshift with BI tools (e.g., Tableau, Power BI) to support business analytics needs. * Hand-on experiences in Redshift architecture, including data modeling, partitioning, and query optimization. **Preferred technical and professional experience** * Hand-on experiences in Spark, Python or Scala, Glue, Lambda, Event Bridge, Kinesis, S3, RDS such as Postgres, Aurora. * Proficient in analyzing query execution plans, identifying performance bottlenecks, and optimizing queries. * Proficiency in monitoring Redshift performance using CloudWatch and Redshift logs, with the ability to configure alerts for potential issues.