search > Brooklyn jobs > Brooklyn computer/technical

Posted: Wednesday, April 12, 2017 5:55 AM

Title: Data ArchitectLocation: Brooklyn, NYDuration: 6 months+This is a 7 hour work dayIf interested, please send your resume to anita.olejnik@nttdata.comJob DescriptionDesign and Define models, including solution patterns, to guide solution decisions for the enterprise. Create, document, and communicate the integration approach of all the components of the data architecture & security framework.Performs a key role in the areas of data modeling, data access, data integration, data visualization, data discovery, and implementation.Rapidly developing dimensional models or analytical data sets based on specific business requirements. Experience in ER dimensional model design and implementation of STAR and SNOWFLAKE schemas is a must.Work with the IT team to set strategy for conformed dimensions, and enterprise hierarchy etc.Transform Logical Data Models into Physical Data Design for Columnar database, for the both the Integration and Access Layers in the three tier architecture.Engage with Data Architects, Directors and Business Users to understand data access paths and business use.Perform data profiling, and business rules investigations on source data, to ensure correct design of the Integration and Access layers.Map and document data transformations of data from a business terms perspective.QualificationsDimensional ModelingAt least 5+ years hands on experience designing and implementing Star SchemasAt least 5+ years experience implementing Data Warehouse presentation layer including design and definition of logical tables, physical sources, dimensions, columns, aggregation rulesAt least 5+ years experience in writing advanced SQL queries, views, and optimization of SQL queriesTransform Logical Data Models into Physical Data Design for Columnar database, for the both the Integration and Access Layers in the three tier architecture.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 tablesHands-on experience with BI application architecture and developmentProven ability to work in a team environmentExcellent communication, problem solving and critical thinking skills.NTT DATA is a leading IT services provider and global innovation partner with 130,000 professionals based in over 50 countries. NTT DATA recently acquired Dell Services. NTT DATA emphasizes long-term commitment and combines global reach and local intimacy to provide premier professional services, including consulting, application services, business process, IT outsourcing, and cloud-based solutions. We're part of NTT Group, one of the world's largest technology services companies, generating more than $100 billion in annual revenues and partner to 80% of the Fortune 100. Visit to learn how our consultants, projects, managed services, and outsourcing engagements deliver value for a wide range of businesses and government agencies. The Company is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result. Please refer to Job Description


• Location: Brooklyn

• Post ID: 96908511 brooklyn is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2017