freehire launches on Product Hunt on 26 August.

Follow →

Lead Assistant Manager - Data Warehouse Architect / Sr BI Architect

Summary

Lead the design and optimization of a data warehouse and BI solutions using Power BI and Azure, integrating diverse data sources and mentoring teams to drive business reporting.

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