Operate as a member of the internal Data Architecture team, and be responsible for producing required deliverables for data analysis and data architecture 
-Support BI reporting by designing new data models and integrating them into the existing data warehouse model.
-Support transactional application development and support by developing new data models, or integrating new structures into existing models.

·         10+ years in IT Industry

·         Proven data architecture and data modeling skills including demonstrated expertise managing data requirements, data flow diagramming, and conceptual data modeling skills including Logical and physical design using ER methodologies and Data warehouse/ data mart design skills.

·         Strong dimensional modeling skills (star/snowflake) with experience designing conformed dimensions for a large enterprise in addition to normalized modeling skills.

·         Extensive experience in OLTP, ODS, and OLAP design patterns with an emphasis on conformed dimension design.

·         Proven ability to work with the ETL team to understand the source/target data mapping and with the BI/Reporting team to ensure entities/attributes needed for reporting plan is being captured in accordance to timeline. Working knowledge of BI tools is a plus.

·         Alternatively have Strong operational modeling skills with demonstrated experience in designing structures for complex, high volume transactional systems. 

·         Proven experience creating enterprise models incorporating master and reference data.

·         Data access and service design experience is a big plus.

·         Familiarity with industry standard modeling tools such as Erwin.

·        Good SQL skills on most major DBMS platforms (DB2, Oracle, SQLServer, Teradata).  Strong analytical and problem solving skills.

·         Excellent verbal and written communication skills, able to explain and document the Enterprise Information Architecture to diverse audiences (technical, business, etc