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.
Requirements
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), Matillion, FiveTran & HVR, Keboola), Data transformation & orchestration (ETL, DBT, Python / SQL, Apache Airflow etc.), Vis: PowerBI, Tableau, Looker, Domo / ThoughtSpot / Qlik / platform BI vendors (ORCL, SAP, AWS etc.)
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
Responsibilities
Design the business data model based on the discovered business processes and data analysis
Translate business requirements into technical design specifications, including data streams, integrations, transformations, databases, and data warehouses.
Develop work estimates for Data Warehouse & Data Lake deliverables
Coach and mentor a team of a few dozen data engineers, analysts and ML Engineers on data architecture and modeling best practices
Define the data architecture framework, standards, and principles, including modeling, metadata, security, reference data such as product codes and client categories, and master data such as clients, vendors, materials, and employees
Define reference architecture, which is a pattern others can follow to create and improve data systems
Define data flows, i.e., which parts of the organization generate data, which require data to function, how data flows are managed, and how data changes in transition
Other
Collaborate and coordinate with team members, clients and external SMEs
Able to identify & evaluate most important criteria when making design decisions
Able to look around corners – recognize likely issues before they happen
Able to communicate complex subjects with executive leaders
Able to solicit input & feedback to model and design decisions
