Technical Skills:
Skill | Years/Level of Experience |
Dimensional Modeling | 3 to 5 years |
Data Warehouse Tools | 3 to 5 years |
Data Modeling | 3 to 5 years |
Oracle Data Warehouse Solution Architecture | 3 to 5 years |
ERwin | 3 to 5 years |
Role Summary:
The Data Architect is responsible for designing and maintaining enterprise data warehouse solutions that support reporting, analytics, and business intelligence initiatives. This role develops data models, integration strategies, and architecture standards to ensure data quality, security, scalability, and performance.
Key Responsibilities:
· Design and maintain data warehouse architecture, data models, and data integration solutions.
· Define data standards, governance practices, and data quality controls.
· Collaborate with business and technical teams to translate requirements into scalable data solutions.
· Support ETL/ELT processes, data migrations, and performance optimization efforts.
· Participate in architecture reviews, Agile ceremonies, and technical design sessions.
· Create and maintain architecture diagrams, data dictionaries, SOPs, and technical documentation.
Required Skills:
· Data warehouse architecture and dimensional modeling
· Design diagrams using ERWIN
· SQL and database design
· ETL/ELT and data integration
· Data governance and data quality management
· Agile/Scrum methodologies
· Strong analytical, communication, and documentation skills
Preferred Experience:
· Experience with enterprise data warehouse platforms and business intelligence tools.
· Knowledge of data migration, and performance tuning.
Education Level: Bachelor’s Degree, or higher (in a related discipline) Three to Five years of experience
