About the job
With over a decade of expertise, the Business Intelligence (BI) Solution Architect will lead the charge in architecting, designing, implementing, and managing advanced OLTP, OLAP, database, ETL, as well as analysis and reporting systems.
Key Responsibilities:
• Conduct thorough assessments of business requirements and technical specifications to develop viable technology solutions.
• Engage in data modeling, integration, and report design.
• Demonstrate extensive experience in ETL processes across diverse source systems.
• Formulate and recommend best practices to optimize the performance and efficiency of the database/data warehouse ecosystem.
• Develop and implement complex data models for data warehouse applications.
• Advise on integration, reporting, and analytics tools.
• Lead requirement gathering, functional and technical analysis both onsite and offshore in BI solutions, particularly in customer support domains.
• Design comprehensive BI strategies and roadmaps, troubleshoot technical issues, support technical solutions in proposals, and create proof of concepts in new BI areas.
• Deliver customer presentations on Microsoft BI capabilities and conduct solution demonstrations.
• Contribute to the overall enterprise data architecture and conceptual data modeling.
• Establish and recommend standards for maximizing the performance and efficiency of the data warehouse ecosystem.

