Data Architect | US
Cuesta Partners, Chicago
About the job
Cuesta Partners is looking for a Data Architect to engage with us on transformational data programs with companies looking to take their AI & data capabilities to the next level.
Key Areas of Focus
Business data modeling
- Trade-offs between different modeling philosophies – dimensional, 3NF, Data Vault
- Conceptual vs physical modeling
- Modeling techniques such as inheritance, parent / child tables, ragged structures, slowly changing dimensions etc.
- Normalization vs de-normalization trade-offs
- Detailed understanding the design trade-offs around different modeling approaches
- Ability to lead model review sessions, and being able to lay out the design "options" and implications, and also present it in a way that both executives and technical-minded people can understand
Modern data delivery design patterns
- Data as product
- Design compromises & considerations
- Know what exemplar deliverables look like
- Team composition and responsibilities / work to be done
- Streaming vs batch design patterns / considerations