Data Warehouse

Role- Data Warehouse Data Architect

Location- Denver CO (Day1 Onsite)

Duration- Contract


Job Duties and Responsibilities

? Collect/Analyze business requirements to build logical/physical
data models

? 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
business requirements.

? 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
delivery timeframes.

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
Star-schema/Snowflake

? Hands-on experience with Structured Query Language

? Strong exposure to MPP Database implementation (Teradata, Netezza,
AWS-Redshift, Snowflake)

? Experience in Designing the best architecture for EDW/Data Lake on
Public/Private Cloud

? 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