Senior Data Analyst (Data Warehouse)// Purchase, NY; Florham Park, NJ, Conshohocken, PA // 6+ Month's contract.

Stellar Consulting Solutions is a boutique business & technology consulting company headquartered in Atlanta, GA. We deliver high quality, agile, and experienced workforce for niche technology projects of any scale. We help forward thinking clients to solve specific problems by understanding their needs and align talent that can move fluidly to match skill supply and demand on a real-time basis. Stellar Consulting has a unique combination of technical and digital skills to recruit, engage, and retain qualified talent. We have a stellar reputation for striving to achieve high ethical standards. Our use of Innovative techniques and industry best practices has made us one of the fastest growing boutique firms delivering to enterprise business. We have an urgent requirement of Senior Data Analyst (Data Warehouse), if you are available and interested, please share your resume and let me know the best time to speak to you. ROLE SUMMARY ROLE TITLE: Senior Data Analyst (Data Warehouse) ROLE LOCATION(S): Purchase, NY; Florham Park, NJ; Conshohocken, PA (On-site in any one of these location) DURATION: 6 months with option to extend The Data Analyst is a hands-on position focused on defining a business-driven data warehouse architecture supported by policies, principles and guidelines that are aligned with data management and data governance. The position will work within IT to help Sompo International create an industry-leading data warehouse infrastructure that measures performance of all aspects of the company's operations. Required:

• 10+ years of data warehouse experience
• 10+ years of hands-on data modelling and data architecture experience
• 5 years P&C Insurance experience (Policy and Claims)
• Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts and frameworks
• Capable of creating and tuning Semantic layer Reporting Views
• Capable of facilitating data discovery sessions involving business subject matter experts
• Knowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL
• Familiar with metadata ingestion and translation

• Translates business requirements into usable enterprise information which may include an enterprise data model, common business vocabulary, taxonomies to be used to guide enterprise solution development, and achieve consistency of information assets across the application portfolio
• Develops and implements strategies for data acquisitions, archive recovery, and implementation of a database
• Develops and maintains a formal description of the data and data structures including the data models, data flow diagrams, data dictionaries and technical metadata
• Creates source to target mapping documents to capture application data elements for loading into data warehouse
• Collaborates with ETL team on data model, its maintenance and optimization as well as end-to-end data driven integration strategy
• Monitor and guide design of a semantically rich business model of the enterprise domain, independent of any technology solution
• Work directly with all application development teams to ensure that data is aligned between systems

• BS in Computer Science, Information Management or Statistics