Data Warehouse Architect
Location:
Boston , Massachusetts
Posted:
November 20, 2017
Reference:
6175148
Top Skills:
  • Must have 10+ years of experience in Data Warehouse design/architecture (creating technical specifications, leading design and modeling) Must have experience in large Data Warehouse environments.
  • Extensive experience with data analysis, profiling, and mapping.
  • Strong SQL skills
  • Experience with ETL tools- ideally informatica (this will not be hands on development, entirely design)




  • Job Description

    This position is a part of the Data Warehouse team at the client. This role is a Data Warehouse Design Lead position. There is a team of 9 Designer/Modelers and then a separate team of hands on Informatica/DW developers. This person will be needing to look at a fair amount of ambiguous data from different source systems and need to profile and make sense of it (understand the relationships, use SQL to profile and understand the structures and put together data models for the target DW in which the data can be moved to. Must have strong operational data modeling, dimensional modeling skills.

    This person will be creating data warehouse data models, need to understand and write the ETL specifications. This person will NOT be hands on coding, they will be designing the solution and working with the developer to implement. They will be describing to the developers who to write the code in the DW to transform it to be more meaningful. They are the designer and there is a development team and this person would need to walk that team through design, explain models, specifications, provide direction to developers

    About TEKsystems:

    Join TEKsystems®, a leading IT staffing, IT talent management and IT services firm, and get your career on the fast track. We have more than 100 offices worldwide, and we partner with over 6,000 clients and place over 80,000 consultants per year. At TEKsystems, we seek to understand our consultants' skills, goals and interests, allowing us to present targeted job opportunities on a contract, contract-to-hire or direct placement basis. TEKsystems' leadership in the market stems from our sincere and personal commitment to driving the success of our customers, consultants and each other.

    The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

    If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888 472-3411 or email accommodation@teksystems.com for other accommodation options.

    A little about us:
    TEKsystems provides corporations with IT staffing, talent management expertise and IT services, enabling them to meet their business objective.

    Know someone who would be interested in this job? Share it with your network.