What are the responsibilities and job description for the Data Warehouse Architect position at absiusa?
Key Responsibilities
- Design, develop, and maintain logical and physical data models for Teradata-based
- Use Erwin Data Modeler to create, update, and maintain data models, metadata, and
- Analyze business requirements and translate them into effective database designs.
- Define and implement data modeling standards, best practices, and naming
- Collaborate with data architects and ETL teams to ensure consistency between data
- Perform data profiling, data analysis, and impact analysis on data model changes.
- Optimize data structures for performance, scalability, and maintainability in the
- Support data governance and metadata management initiatives.
- Participate in code reviews, design sessions, and data quality assessments.
- Provide documentation and support for production and development teams.
- Bachelor’s degree in Computer Science, Information Systems, or related field.
- 5 years of experience in data modeling for large-scale data warehouse environments.
- Strong experience with Teradata databases and architecture.
- Expertise in Erwin Model Mart.
- Strong understanding of normalized and dimensional modeling techniques.
- Experience with ETL design concepts, data governance, and metadata
- Solid understanding of SQL and database performance tuning.
- Excellent analytical, communication, and documentation skills.
- Experience in cloud data platforms (AWS, Azure, GCP) and integration with Teradata.
- Familiarity with BI/reporting tools (Tableau, Power BI, SAP Business Objects, etc.).
- Exposure to Agile / DevOps methodologies.