Define, Design, Develop the necessary core reporting architecture to enable appropriate automated Business Intelligence software solutions with emphasis on Micro Strategy. Design cloud architectures to migrate on prem data warehouses/marts to Cloud. Conduct end to end technical discovery, identifying pain points, business, and technical requirements, “as is” and “to be” scenarios. Work with the data architect to ensure that logical and physical data models support the analytic needs of the business. Plan for hardware and environment growth.Develop and rioritize use cases as it relates to Clients’ data migration Journey to Cloud. Design, build and optimize complex SQL is used to manage large Data Warehouses. Develop design patterns and best practices and ensure compliance. Collaborate with key business users to identify needs and opportunities for improved data management and delivery Manage and guide teams of Data engineers, uccessfully delivering work efforts. MicroStrategy application cut over to Cloud (Snowflake, Athena) Procure, budget and maintain the necessary BI Licenses (Tableau) to relevant users in Digital Sales and key stakeholders. Ensure appropriate Information Security policies are implemented. Work with systems applications and analysis, integrated systems and providing user support services Support the systems administrative and self-service users with training, reporting, and troubleshooting, and performs tasks integral to the central use of the systems Develop documents, and maintain standards, policies, and procedures, and create new business processes or enhancements to existing processes that promote essential activities Design and implement data integration improvements including source to target mapping and transformation documentation used by data engineers to create pipelines in Teradata and Snowflake Work on Querying, analyzing and illustrating data scenarios to aid requirements gathering Prepare architecture for data, prepare strategies and provide business object solutions as per requirements. Manage all data for transactional sources to enable ffective reports/Dashboards. Manage and guide teams of Data engineers to optimize the Teradata workloads Responsible for building and implementing process improvement and data analytics solutions to support business needs Work with requesters and develop custom reports or supports application enhancements and conversions Analyze business processes and translate them into document user stories/functional requirements Work with various business units to gather requirements, create technical design documents and communicate business needs to appropriate technical resources.