share us. Apply

SR DATA ARCHITECT

Location(s)   New York, NY; Jersey City, NJ; Warren, NJ; Franklin Lakes, NJ; Wilton, CT; Tampa, FL; Fort Lauderdale, FL; Charlotte, NC; Chennai, India; Pune, India; Hyderabad, India; London, UK; Sydney, AU; Melbourne, AU
Type   Full-time
Experience   Senior- level
Functions    Consulting, Finance, Information Technology, Project Management
Industries   Healthcare, Financial Services, Management Consulting, Information Technology and Services

Requirements

  • BA or equivalent in computer science, engineering (all branches) or related
  • 10-12 years of Data Warehouse experience designing large scale data models for data warehouse environments and
  • Proven demonstration of strong Logical, Canonical, Rational, Dimensional and Physical Data Modeling skills
  • 6-8 years of experience designing large scale data models for data warehouse environments using ORACLE.
  • Diverse experience with database technologies including MPP appliances (Teradata, Netezza, Exadata, etc.)
  • Superior interpersonal, communication skills and documentation skills with ability to be both directive and collaborative 
  • Industry experience in Finance including banking, corporate finance, insurance, investments banks and other financial institutions
  • Strong experience with large data sets ( >50TB)
  • Knowledge and appreciation of business concepts and requirements
  • Ability to gather business requirements, perform analysis and establish/recommend a data integration architecture
  • Extensive background in database systems along with a strong knowledge of SQL
  • Experience with agile/scrum is valuable
  • Ability to exercise initiative, problem-solving and decision-making skills
  • Proven ability to work creatively and analytically in a teamwork-oriented environment; apply policies and procedures to solve every day and/or complex company issues
  • Ability to travel 25%
  • Authorized to work in the U.S. (H1 B Visa , OPT , Green Card or U.S. citizen)

Job Description
The position is for a senior-level Data Modeler/Architect in Financial Services vertical for a leading BI/DW organization. The candidate will work closely with Project Managers, Data Analysts, ETL, Data Distribution and Data Operations team members and to centralize and streamline processes and functional requirements across different business units. Depending on the level of experience, candidate will be assigned the appropriate role and level in the team. Relocation to other parts of the U.S. may be available with relocation assistance.

Job Duties

  • Provide consultative approach with business users, asking questions to understand the business need and deriving the data flow based on those needs
  • Perform the detail data analysis
  • Identify the key facts and dimensions necessary to support the business requirements
  • Experience with Dimensional, Canonical, Rational, Logical and Physical data modeling
  • Develop the logical dimensional model(s)
  • Develop entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved
  • Conduct User Interviews and Data Analysis Review meetings
  • Perform source data quality assessments
  • Identify the appropriate data sources with the assistance the business analyst
  • Perform the activities necessary to support the standardization of facts and dimensions
  • Prepare prototype models to support the development efforts
  • Assist the business analyst in mapping the data from source to target
  • Assist the business analyst and Data Acquisition team with data related issues such as assessing data quality, data consolidation, evaluating existing data sources
  • Perform re-engineering of source models when necessary
  • Assist the Data Acquisition Architect to ensure the Data Architecture is applied properly
  • Assist the DBA in converting the logical model(s) to physical
  • Maintain data in the metadata repository

About ITI 
ITI is an industry-leading information and data management solutions firm with business-driven technology designed for the world’s largest banks, financial services and healthcare companies. Headquartered in One World Trade Center at the heart of New York City’s Financial District, ITI has over 300 employees across 10 branch and satellite offices in key global, financial services markets including London, Singapore, Mexico and Australia.

Send resume to ITI Data, One World Trade Center 83E, New York, NY 10007 or email to [email protected].