Lead Assistant Manager - Data Warehouse Architect / Sr BI Architect

Responsibilities

• Provide expert guidance and leadership in Business Intelligence (BI) skills and technologies.
• Manage and lead projects for data and analytics solutions, utilizing Power BI and Azure to accommodate growth.
• Participate in the design and development of EDW implementations, ensuring best practices and procedures are followed.
• Lead Dimensional Modeling efforts, defining standards for Data Model Design and Naming to maintain consistency across layers.
• Write complex queries and design tailored analysis and reporting solutions for relational and multidimensional databases.
• Collaborate with Developers and Analysts to ensure successful development of BI reporting and analysis solutions.
• Work closely with business groups and technical teams to maintain and enhance the data warehouse platform for efficient BI reporting.
• Support BI tools upgrades, contributing to development, testing, and documentation processes.
• Diagnose and resolve capacity issues and performance bottlenecks in BI tools, providing root cause analysis and recommendations.
• Foster a collaborative environment, managing vendor relationships, and ensuring effective communication across teams.
• - Provide expert guidance and leadership in Business Intelligence (BI) skills and technologies. - Manage and lead projects for data and analytics solutions, utilizing Power BI and Azure to accommodate growth. - Participate in the design and development of EDW implementations, ensuring best practices and procedures are followed. - Lead Dimensional Modeling efforts, defining standards for Data Model Design and Naming to maintain consistency across layers. - Write complex queries and design tailored analysis and reporting solutions for relational and multidimensional databases. - Collaborate with Developers and Analysts to ensure successful development of BI reporting and analysis solutions. - Work closely with business groups and technical teams to maintain and enhance the data warehouse platform for efficient BI reporting. - Support BI tools upgrades, contributing to development, testing, and documentation processes. - Diagnose and resolve capacity issues and performance bottlenecks in BI tools, providing root cause analysis and recommendations. - Foster a collaborative environment, managing vendor relationships, and ensuring effective communication across teams.