Report this Job
Position:Data Warehouse Data Architect
Note : We are looking only for local candidates preferred only in Colarado
Location: Denver CO(Day 1 onsite)
Sample profile attached
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.
Alpha Silicon
