Job Description :
Position : Sr. Data warehouse Architect Location : Union, NJ Duration : Contract Please let me know if you are interested in this position contact, Email: Job description: Responsibilities: 1. Support the roadmap of data-related projects to support upcoming business changes and partners with internal and external teams to implement accordingly 2. Understanding of overall business and end-user data and insights needs 3. Understand business metrics, business rules and data requirements 4. Perform data discovery by exploring data from internal and external systems to derive business rules 5. Document, Implement and Operational business SOPs including data flow diagrams & related artifacts 6. Manage smooth operations, ensuring their stability and integrity, and meeting customer service levels 7. Analyzing data sets in support of data investigations 8. Developing Ad-hoc reports, analysis, insights and recommendations Experience & Personal Qualities: 1. 10+ years professional experience in data management 2. Proven professional experience with database development and data analysis 3. Professional experience in retail, consulting, technology with progressively increasing responsibility; strong understanding of technology, business systems 4. Excellent understanding of Retail data landscape (Sales, Marketing, Distribution, Real World, 5. Strong understanding of retail analytics data 6. Advanced understanding of Data systems and tools 7. Highly developed analytical, problem-solving, change management and consulting skills 8. Excellent interpersonal, teamwork & collaboration skills 9. Ability to work and achieve objectives independently and as part of a team 10. Proactive approach to meeting business needs and identifying business opportunities 11. Excellent written and verbal communication skills 12. Expert knowledge of SQL (Teradata, Netezza and Big Query) 13. Experience with Data Integration Technologies on the Cloud Platforms (We're a Google shop) 14. Experience with prototyping & automating Data Integration Processes 15. Excellent knowledge of cloud computing technologies and current computing trends (such as BIG QUERY) Required Skill Set: 1. Hands-on experience with ERWIN Data Modeler and Working on the Enterprise Data Mart 2. Understanding Metadata Management principles (Data Dictionary activities) 3. Hands-on experience with Creating the ETL Mapping 4. Should understand impacts of model changes on databases and to validate that a model supports straight-forward requirements 5. Hands-on experience with 3NF Data Modeling and NORMALIZED schema 6. Should be able to analyze business requirements to develop data models with minimal oversight 7. Hands-on experience implementing Data Warehouse presentation layer - including design and definition of logical tables, physical sources, columns, aggregation rules 8. Hands-on experience in writing SQL queries, views, and optimization of SQL queries 9. Comprehensive Knowledge of Bill Inmon's Data Modeling Concepts (Logical and Physical) including 3NF, Supertypes, Subtypes, Abstraction, Associative entities/tables 10. Requires strong decision-making, organizational, planning and problem-solving skills. Nice to have: 1. Knowledge on other Data Modeling tools like Power Designer, Visio, ER studio 2. Working experience of Analytical tools such as Tableau, MicroStrategy, DOMO and Looker. 3. Comprehensive Knowledge of Ralph Kimball's Data Modeling Concepts including Transaction dimensions, conformed dimensions and facts, slowly changing dimension, multi-Star/ Snowflake Schema Modeling, different types of Fact tables 4. Implementing a virtual semantic layer (virtual star schema) using views on a multi-tiered normalized Integrated 5. Operational Data Store is a huge plus 6. 3NF (Relational) Logical and Physical Modeling Education/Certification: A minimum Bachelor's degree in Computer Science, EngineeringCST provides its clients with complete, cost-effective, end-to-end personnel solutions across a range of industrial domains. CST''s mission is to empower businesses around the world to make better, faster operational decisions.