Data Architect

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

• Pros / cons of data mesh delivery model vs alternatives

• Comparison of modern cloud native platforms vs legacy on-premises data solutions

Master data governance

• Types and most common root cause of DQ issues

• Remediation approaches

• MDM architecture styles / patterns

• Key capabilities of MDM & DQ vendors

Expert in technologies including 1 or more of each class:

• Data management layer

  • Snowflake

  • Databricks

  • Microsoft Fabric

  • GCP Big Query/ AWS DB Options

• Data acquisition & integration

  • Azure Data Factory (ADF)