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 modelingTrade-offs between different modeling philosophies – dimensional, 3NF, Data VaultConceptual vs physical modelingModeling techniques such as inheritance, parent / child tables, ragged structures, slowly changing dimensions etc.Normalization vs de-normalization trade-offsDetailed understanding the design trade-offs around different modeling approachesAbility 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 understandModern data delivery design patternsData as productDesign compromises & considerationsKnow what exemplar deliverables look likeTeam composition and responsibilities / work to be doneStreaming vs batch design patterns / considerationsPros / cons of data mesh delivery model vs alternativesComparison of modern cloud native platforms vs legacy on-premises data solutionsMaster data governanceTypes and most common root cause of DQ issuesRemediation approachesMDM architecture styles / patternsKey capabilities of MDM & DQ vendorsExpert in technologies including 1 or more of each class:Data management layerSnowflakeDatabricksMicrosoft FabricGCP Big Query/ AWS DB OptionsData acquisition & integrationAzure Data Factory (ADF)MatillionFiveTran & HVRKeboolaData transformation & orchestrationETLDBTPython / SQLApache Airflow etc.Vis:PowerBITableauLookerDomo / ThoughtSpot / Qlik / platform BI vendors (ORCL, SAP, AWS etc.)Architecture transformations:Considerations / experience evaluating lift & shift vs re-model trade-offsConsiderations / experience when consolidating decentralized silosConsiderations / experience when moving to modern cloud stacksConsiderations / experience when enabling unified operational & analytics data hubsCommunication & leadership skills:Able to identify & evaluate most important criteria when making design decisionsAble to look around corners – recognize likely issues before they happenAble to communicate complex subjects with executive leadersAble to solicit input & feedback to model and design decisionsAbility to teach / leverage experience to develop team/talent around themUse past experiences to help with change management to eases concerns over shifts in approachWhat You'll Do:Design the business data model based on the discovered business processes and data analysisSet the standard for AI-augmented development practices — ensuring projects are structured and tooled in ways that allow coding agents to operate effectively, and coaching the team to work the same way.Translate business requirements into technical design specifications, including data streams, integrations, transformations, databases, and data warehouses.Develop work estimates for Data Warehouse & Data Lake deliverablesCoach and mentor a team of a few dozen data engineers, analysts and ML Engineers on data architecture and modeling best practicesDefine 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 employeesDefine reference architecture, which is a pattern others can follow to create and improve data systemsDefine 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 transitionCollaborate and coordinate with team members, clients and external SMEsWhat We're Looking For:Bachelor’s degree in a technical or quantitative field (e.g. Computer Science, Math, Economics Statistics)10+ years of work experience in the data analytics spaceActive, hands-on experience using AI-assisted development tools (e.g., Cursor, Claude Code, Codex, or similar) in your daily workflow — including building working prototypes, agentic pipelines, RAG systems, or LLM-powered data and analytics products — is a strong asset.Previous experience in the consulting space is a plusA passion for exploring and solving different kinds of problemsA desire to learn and assimilate technical information quicklyHands-on experience deploying solutions in large-scale, high performing databasesExpertise aligned to technologies listed in Key Areas of FocusBenefits: What you’ll gain:At Cuesta, we value entrepreneurship, humility, diversity, learning, speed, and balance. We provide our team members with:Constant opportunities for exposure & learningFlexible working location and enabling personal-life harmony with workAgency and influence in the company’s total strategy and directionCollaboration with a high-performing teamCompetitive base salary (outlined in this listing) and target bonus of 20-25%Supplemental Health, Dental, Vision, and Life insurance The offered salary may vary within this range depending on the candidate’s experience and the team’s feedback at the end of the process.
1 day ago