Data Architect / Data Modeler
Seattle, WA (On-Site)
Job Description:
- Should have 11+ years of experience
- Strong experience in data modeling tools (e.g. Erwin, ER/Studio, Power designer)
- Deep understanding of relational dimensional Strong SQL skills for analysis and validation.
- Experience with data warehousing (star/snowflake schema, fact/dimension modelling) Ability to integrate new data sources into existing data models.
- Analyze new source system and identify new data objects, entities, and relationships.
- Merge and align new data objects with the existing data model while maintaining consistency.
- Design and develop conceptual, logical and physical data models for OLTP and OLAP.
- Collaborate with business stakeholders to capture data requirements and translate them into scalable models.
- Provide impact analysis and recommendations for incorporating new data sources into existing ecosystems.
- Partner with Data engineers, ETL, and BI teams to implement data models and mappings.
- Maintain metadata, data dictionary, and lineage documentations.
Key Skills:
- Strong experience in data modeling tools (e.g. Erwin, ER/Studio, Power designer)