As an Architecture Senior Advisor, you will join the team to design and implement major components of data architecture and models to modernize Reporting & Analytics applications. You will perform data analysis, define business requirements, and create conceptual, logical, and physical data models within an agile environment. Your daily work involves collaborating with upstream owners and stakeholders to build scalable data flows, mentoring junior staff on query performance, and developing a data access layer in the data lake. The role requires expertise in AWS services like Redshift and PostgreSQL, along with proficiency in SQL, Spark, Erwin, and Informatica. You will manage data within regulated healthcare environments while integrating systems such as Oracle, MySQL, and Salesforce. Technical tasks include building distributed pipelines, creating mapping documents, and developing dashboards in Tableau to solve complex reporting challenges.