• Data Warehouse Architect Jobs in United States Of America - 25719930

  • CGI Information Systems and Management Consultants Pvt Ltd
  • United States Of America, Usa
  • Save Job
  • 5 - 8 Years
  • Posted : above 1 month

Job Description:

Data Warehouse Architect Category Development/Engineering

City San Juan, Puerto Rico, United States

Position ID J0819-1418

Employment Type Full Time

Meet our professionals CGI An employer of choice

Position Description CGI is looking for a Data Warehouse Architect who will be responsible for architecting, designing and providing oversight to the implementation of system data modifications to a project in the Healthcare Industry In addition to data modeling experience, the data architect will have a key role in translating business requirements to physical database structures and architecting the movement of data throughout the system originating from external and internal sources

Your future duties and responsibilities Architect solution to identify and load data from disparate sources originating from multiple applications across the enterprise
Provide oversight to design and develop the database logical and physical data model for normalized and non-normalized data structures
Architect data migration strategy for the system
Architect reusable and proven design patterns to extract, transform and load data
Design schema definitions for OLTP and OLAP databases
Provide oversight to design and develop data warehouse model
Develop standards that govern the strategy to collect metadata
Implement best practices and standards to analyze, profile and store data
Develop and document standards and guidelines to govern the use of data integration tools and processes
Additional experience in sizing, tuning and data analysis is a plus

Required qualifications to be successful in this role 5 years experience as a data architect/modeller for a large scale production data warehouse system or comparable product
Hands on experience with Data Analysis, Data Modeling (Logical and Physical), Database Design, Data Integration, Data Warehousing methodologies
Possess an end-to-end vision to understand a logical design translates into one or more physical databases and how data flows through successive stages of the overall solution
Hands on experience working with Oracle and SQL Server relational databases in a large scale project environment
Deep knowledge of SQL
Experience with modeling and metadata management tools
Hands on Experience working in Windows operating systems
Possess a strong desire to establish standards and implement best practices
Ability to document reusable standards, guidelines and best practices to be used by the project team
Work with Solution Architect to ensure that solutions complement the system architecture and conforms to the enterprise architecture strategy
Ability to work in an integrated team environment that includes designers, developers, other architects
Good communication and presentation skills
Experience in the Insurance or Healthcare industries, including IT solutions for MMIS, HIX and Healthcare reform initiatives a plus
Bachelors Degree
Additional industry certifications a plus

Skills Data Analysis
Data Architecture
Data Modeling
SQL

What you can expect from us Build your career with us It is an extraordinary time to be in business As digital transformation continues to accelerate, CGI is at the center of this changesupporting our clients digital journeys and offering our professionals exciting career opportunities

At CGI, our success comes from the talent and commitment of our professionals As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership All of our professionals benefit from the value we collectively create

Be part of building one of the largest independent technology and business services firms in the world

Learn more about CGI at

No unsolicited agency referrals please

CGI is an equal opportunity employer

Qualified applicants will receive consideration for employment without regard to their race, ethnicity, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity, and gender expression, familial status, political affiliation, genetic information, or any other legally protected status or characteristics

CGI provides reasonable accommodations to qualified individuals with disabilities If you need an accommodation to apply for a job in the US, please email the CGI US Employment Compliance mailbox at You will need to reference the requisition number of the position in which you are interested Your message will be routed to the appropriate recruiter who will assist you Please note, this email address is only to be used for those individuals who need an accommodation to apply for a job Emails for any other reason or those that do not include a requisition number will not be returned

We make it easy to translate military experience and skills! Click to be directed to our site that is dedicated to veterans and transitioning service members

All CGI offers of employment in the US are contingent upon the ability to successfully complete a background investigation Background investigation components can vary dependent upon specific assignment and/or level of US government security clearance held

CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGIs legal duty to furnish information

Have you been referred by a CGI Member for this position* Yes No

CGI members email (cgicom)*

First Name

Last Name

I agree to allow CGI to contact the CGI member who referred me to obtain additional information about my application and to confirm my referral *

* This field is required

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Software Services
Functional Area : IT Software : Software Products & Services
Role : Software Engineer
Salary : As per Industry Standards
Deadline : 22nd Jul 2020

Key Skills:

Taking these free online tutorials can help you get your next job

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status