Business Intelligence/Microstrategy Lead Architect - Data Warehouse

Position Summary:
Business Intelligence/Microstrategy Lead Architect - Data Warehouse
Job Description:
• Business Intelligence/Microstrategy Lead Architect will be part of Pharmacy Data Warehouse team responsible for designing, developing and deploying business intelligence and data warehousing projects.
• The Business Intelligence/Microstrategy Lead Architect must evaluate functional and technical business requirements.
• Provide leadership and direction on Business Intelligence/Microstrategy portion of project using Microstrategy, OBIEE, SAS, other BI tools. Teradata is being used as data warehouse with a variety of databases, applications and flat files as data sources.
• Subject Matter Expert on enterprise data, OLAP, data analysis, data modeling, SQL constructs and workload management.
• Must be able to work independently and have the ability to gain understanding of requirements/data specifications and any data discrepancies from interaction with others.
• Primary responsibility is to review, update, maintain Microstrategy related system architecture documentation, and create Microstrategy design documents that will be followed by the developers to build a Microstrategy suite of applications.
• Transform requirements into MicroStrategy solutions that efficiently enable expected application, reporting, and analytic capabilities to support the business and strategic initiatives of the enterprise.
• Provide technical oversight for the development of integrated Microstrategy solutions through expert guidance, review and validation of existing reporting and new solutions to ensure continuous accuracy and front end ease-of-use.
• Create design pattern templates for deliverable objects
• Find opportunities in the areas of user experience as well as innovative ways (R&D) to deliver powerful analytical insight.
• Explain functional/technical requirements to application development teams and track work status.
• Contribute to the review of test plans, test cases to ensure all requirements are covered and documents are thorough.
• Work with team lead and business analyst to provide support and contribution in preparing critical User Acceptance scenarios.
• Assist in deploying/migrating product within the production environment; serve as the subject matter expert for systems in production - helping to ensure a stable, robust production environment.
• Must be able to work with off-shore leads and oversee projects that will be developed by off-shore teams
• Capable of communicating across a diverse workforce to ensure work transitions effectively without interruption or incident.
Requirements:
• Bachelor Degree preferred.
• Five plus years of experience in large scale high velocity analytics production environments.
• Ideal candidate must have at least five plus years of experience working with large Enterprise Data Warehouse projects in the role of Business Intelligence/Microstrategy Lead architect/developer.
• Strong experience with Business Intelligence and Data Warehousing design principles and industry best practices. Expert knowledge of the Microstrategy suite of analytical tools. OBIEE, SAS, other BI tools is a plus.
• Excellent communication (verbal and written), interpersonal, organizational, documentation, and presentation skills (to executive level staff and to large groups).
• Demonstrated ability to lead, persuade, and gain consensus from very diverse audiences.
• Ability to interact with people from diverse backgrounds and different experience levels.
• Ability to train and mentor others in the use of Microstrategy software and techniques.
• Involved in gathering requirements and created architectural, detail design documents and reports
• Performance Tuning of Microstrategy Reports.
• Working knowledge of Teradata database platform as well as SQL.

CVS Caremark is a Fortune 18 company with 200,000 employees and over $100B in revenue. It is the only fully integrated pharmacy health care company in the United States. Our offerings across the entire spectrum of pharmacy care allow us to provide greater convenience and choice for patients, improve health outcomes, and lower overall health care costs for plan sponsors and participants.


Country: USA, State: Rhode Island, City: Woonsocket, Company: CVS Caremark.
View more jobs in Rhode Island