Ability to architect and implement BI and Datawarehouse solutions in a cloud environment and good understanding of cloud technologies.
Define, design, and implement Business Intelligence (BI) strategies for operational, ad-hoc, and self-service solutions.
Work directly with IT and business users to facilitate, define and document data requirements as the foundation for data base design, data extraction, analysis and cleansing.
Develop and build comprehensive data validation and error processes as a component within the “End to End” BI solution architecture.
Assist in the definition, documentation and development of mapping rules for movement of data from disparate data sources and into the various components and subject areas of the BI environment.
Develop strategies for data acquisition, archive recovery, and enterprise level database implementation.
Create data models including robust data definitions, entity-relationship-attribute models, as well as relational and/or dimensional models.
Transition logical models to physical implementation of data structures.
Provide hands-on data modeling (relational and dimensional) for Data Warehouse/Data Marts and overall BI environment.
Provide best practices and guidance regarding use of ETL, data modeling (relational and dimensional), and reporting deliverables.
A good understanding of the design and development of complex business reports.
Work in a small team environment with Project Managers, BI developers, Business Analysts, and internal business users.
Work with technical and business users to understand requirements then identify, and design multiple solution options as well as determine and recommend a right-sized approach.