Lead Assistant Manager - Data Warehouse Architect / Sr BI Architect

Job Description: We are seeking a Senior BI Architect to join our dynamic team at ExlService Philippines, Inc. In this role, you will play a crucial part in integrating data from diverse sources, creating essential data elements to support New Story's operations. Your expertise will be instrumental in building a robust warehouse strategy in collaboration with our trusted vendor. Additionally, you will engage with data consumers to design and optimize reports that drive our business forward.

• 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.

• Qualifications: Bachelor's degree in Information Technology, Data Science, or a related field.

• A minimum of 8 years of experience as a BI Developer/Architect, demonstrating a strong track record of success.

• Expertise in ETL, SQL, SSRS, and Power BI, with a proven ability to apply these skills in complex data environments.

• Exceptional problem-solving and analytical skills, with a keen attention to detail.

• Strong teamwork and collaboration skills, with the ability to manage and nurture vendor relationships.

• Excellent communication skills, both written and verbal, to effectively interact with diverse stakeholders.

• Experience in leading and mentoring a team, fostering a positive and productive work environment.

• A proactive and innovative mindset, with a passion for staying updated with the latest trends and technologies in BI.

• Ability to work independently and manage multiple projects simultaneously, ensuring timely delivery.

• A commitment to continuous learning and professional development, staying ahead of industry trends.