| Location: Denver , Colorado , United States Of America
Role- Data Warehouse Data Architect
Location- Denver CO (Day1 Onsite)
Job Duties and Responsibilities
? Collect/Analyze business requirements to build logical/physical
? Conduct data architecture and integration design review meetings.
? Prepare/Review Source to Target Mappings (STM) based on the
business requirements and reviews with Analysts/Development & Testing teams
? Provide technical support; collaborate with business/ data analyst
team, ETL/ELT team and BI reporting team.
? Ensure quality control of data through the development and
maintenance of Data Quality rules and quality control procedures
? The candidate will be required to discover, analyze, profile and
document findings on source data systems.
? Candidates will assist the development team during the development
phase to resolve data issues and understand data constraints.
? Candidate will drive the initial system testing of the final data
output to ensure consistency with source data and that solution meets
? Candidates will be expected to proactively drive process
improvements by helping define standards and procedures; refining methods
and techniques for information modeling, and recommend tools to improve
Skills, Experience and Requirements
? At least 4 yrs in Design/Architecture/implementation of an
Enterprise Data warehouse (On-premise/Cloud Platform)
? Demonstrated understanding of EDW data modeling using
? Hands-on experience with Structured Query Language
? Strong exposure to MPP Database implementation (Teradata, Netezza,
? Experience in Designing the best architecture for EDW/Data Lake on
? Should have good expertise in non-functional aspects (performance,
scalability, volume, security)
? Should have exposure to any data modeling tool ( Erwin/Er-Studio)
? Excellent communication skills as the position require
communication with all levels of the organization, including stakeholders,
developers, architects, business users, and management.
? Should have exposure to AWS Cloud.
? Education and Experience:
? Bachelor's degree from a four-year College or University; 4 years
related experience building an Enterprise Data Warehouse and/or equivalent
combination of education and work experience
? Relevant AWS certifications are a plus.
Reference : Data Warehouse jobs