Develop, maintain, and review data processes and architecture for both on-premise and cloud-based data systems; conduct team reviews and recommend data modeling, administrative, and design improvements.
Analyze business, data and systems requirements in order to perform data modeling and design (high level conceptual business/data models, entity-relationship and dimensional logical data models, and detailed physical database design models).
The Business Intelligence Solution Architect will be the subject matter expert responsible for analyzing business requirements and problems to determine the architectural framework, technology requirements, overall design and the right set of tools for the best possible business intelligence/data warehousing solution to fulfill the needs of our clients.
This person will build a new data warehouse from the ground up - levering data from the company's consumer-facing websites along with advertising campaigns, to help the company gain more insight and knowledge from consumer trends, behaviors, etc.
Work with the business and IT to document reporting and data requirements, performs the functional and technical design, and scopes the level of effort needed to deliver the solution to the business community.
Current experience providing services in architecting, designing and implementating data warehouse solutions for applications and Business Intelligence solutions for large scale/complex environments including: IAS, SFS, SFS-EE1, SiteManager,and AS400.
Provide leadership in architecting the Cloud Based Data Platform (Azure, AWS, Google Big Query) for US technology team; design high performing cost effective cloud based multi-tenant (multi- client) structures.