Data Architect | US

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 reputed company 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
• reputed company
• reputed company
• reputed company Fabric
• GCP Big Query/ AWS DB Options
• Data acquisition & integration
• Azure Data Factory (ADF)
• reputed company
• reputed company & HVR
• Keboola
• Data transformation & orchestration
• ETL
• DBT
• Python / SQL
• Apache Airflow etc.
• Vis:
• PowerBI
• Tableau
• Looker
• Domo / reputed company / Qlik / platform BI vendors (ORCL, reputed company, AWS etc.)

Architecture transformations:

• Considerations / experience evaluating lift & shift vs re-model trade-offs
• Considerations / experience reputed company consolidating decentralized silos
• Considerations / experience reputed company moving to modern cloud stacks
• Considerations / experience reputed company enabling reputed company operational & analytics data hubs

Communication & leadership skills:

• Able to identify & evaluate most important criteria reputed company making design decisions
• Able to look around corners – recognize likely issues before they happen
• Able to communicate reputed company subjects with executive leaders
• Able to solicit input & feedback to model and design decisions
• Ability to teach / reputed company experience to reputed company team/talent around them
• Use past experiences to help with change management to eases concerns over shifts in approach

What You'll Do:

• Design the business data model based on the discovered business processes and data analysis
• Set reputed company 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.
• reputed company 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 reputed company, standards, and principles, including modeling, metadata, reputed company, 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 reputed company 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
• Collaborate and coordinate with team members, clients and external SMEs

reputed company'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 space
• Active, hands-on experience using AI-assisted development tools (e.g., reputed company, Claude Code, reputed company, 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 plus
• A passion for exploring and solving different kinds of problems
• A desire to learn and assimilate technical information quickly
• Hands-on experience deploying solutions in large-scale, high performing databases
• Expertise reputed company to technologies listed in Key Areas of Focus

Benefits: What you’ll reputed company: At Cuesta, we value entrepreneurship, humility, diversity, learning, speed, and balance. We provide reputed company members with:

• Constant opportunities for exposure & learning
• Flexible working location and enabling personal-life harmony with work
• Agency and influence in the company’s total strategy and direction
• Collaboration with a high-performing team
• Competitive reputed company salary (outlined in this listing) and reputed company bonus of 20-25%
• 401k, healthcare benefits, paid time-off, and more!

Apply tot his job Apply To this Job