Browse JobsCareer BlogJob Search ResourcesAI Interview PreparationWorkzil HomeJob ListingsPricing PlansContact UsCreate AccountHiring SolutionsSecurity & PrivacyAffiliate ProgramFree CV BuilderAI CV ReviewerFree Resume BuilderAI Resume ReviewerSalary CalculatorSalary Comparison ChartsLayoff TrackerLayoff NewsHiring Trends 2026Startup Funding TrackerCompany Expansion TrackerVisa Sponsorship CompaniesBest Companies to Work ForBlog ArticlesCareer ResourcesAI Interview PrepTerms of ServicePrivacy PolicyCookie PolicyPost a JobAI Candidate ScreeningEmployer PricingEnterprise SolutionsJobs in New YorkJobs in San FranciscoJobs in AustinJobs in SeattleJobs in ChicagoJobs in Los AngelesJobs in BostonJobs in DenverJobs in AtlantaJobs in MiamiJobs in DallasJobs in Washington DCJobs in San JoseJobs in RaleighJobs in NashvilleSoftware Engineer JobsData Scientist JobsProduct Manager JobsData Analyst JobsUX Designer JobsFrontend Developer JobsDevOps Engineer JobsMarketing Manager JobsFinancial Analyst JobsCybersecurity Analyst JobsSoftware Engineer Salary GuideData Scientist SalaryProduct Manager SalaryUX Designer SalaryDevOps Engineer SalaryCloud Architect SalarySoftware Engineer Salary CalculatorData Scientist Salary CalculatorProduct Manager Salary CalculatorSoftware Engineer Salary San FranciscoSoftware Engineer Salary New YorkData Scientist Salary SeattleProduct Manager Salary AustinDevOps Engineer Salary CalculatorUX Designer Salary CalculatorSoftware Engineer Interview QuestionsProduct Manager Interview QuestionsData Scientist Interview QuestionsUX Designer Interview QuestionsFrontend Developer Interview QuestionsRemote Software Engineer JobsRemote Product Manager JobsRemote Data Analyst JobsRemote UX Designer JobsRemote Frontend Developer JobsElectrician JobsPlumber JobsHVAC Technician JobsRegistered Nurse JobsTruck Driver JobsWarehouse Worker JobsCarpenter JobsWelder JobsRestaurant Manager JobsConstruction Manager JobsDental Hygienist JobsReal Estate Agent JobsElectrician Salary GuidePlumber Salary GuideRegistered Nurse SalaryTruck Driver SalaryHVAC Technician SalaryWelder Salary GuideElectrician Interview QuestionsNursing Interview QuestionsTruck Driver Interview QuestionsRestaurant Manager Interview QuestionsLayoffs 2026Layoffs 2025Layoffs 2024Layoffs 2023Google LayoffsMeta LayoffsAmazon LayoffsMicrosoft LayoffsSoftware Engineer Resume BuilderData Scientist Resume BuilderProduct Manager Resume BuilderRegistered Nurse Resume BuilderMarketing Manager Resume BuilderTechnology Industry JobsFinance Industry JobsHealthcare Industry JobsConstruction & Trades JobsRetail & E-Commerce JobsSoftware Engineer vs Data ScientistSoftware Engineer vs Product ManagerData Scientist vs Data AnalystFrontend vs Backend DeveloperProduct Manager vs Project ManagerElectrician vs Plumber
    WorkzilWorkzil
    Find Jobs
    Pricing
    Sign inGet Started
    • Find Jobs
    • Companies
    • AI Interview Prep
    • For Employers
    • Intelligence
    • Pricing
    • Support
    • Free Tools
      • CV / Resume Builder
      • CV / Resume Reviewer
      • Salary Calculator
      • Salary Comparison
    • Company Intelligence
      • Layoff Tracker
      • Hiring Trends
      • Funding Tracker
      • Expansion News
      • Visa Sponsorship
      • Layoff News
    • Career Research
      • Best Companies
      • Industry Guides
      • Compare Roles
      • Salary Guides
      • Interview Questions
      • Remote Jobs
    • Resources
      • Blog
      • Resources
      • Community
    • Post a Job
    • Sign Up
    • Sign In
    • Contact
    WorkzilWorkzil
    Find Jobs
    Pricing
    Sign inGet Started
    • Find Jobs
    • Companies
    • AI Interview Prep
    • For Employers
    • Intelligence
    • Pricing
    • Support
    • Free Tools
      • CV / Resume Builder
      • CV / Resume Reviewer
      • Salary Calculator
      • Salary Comparison
    • Company Intelligence
      • Layoff Tracker
      • Hiring Trends
      • Funding Tracker
      • Expansion News
      • Visa Sponsorship
      • Layoff News
    • Career Research
      • Best Companies
      • Industry Guides
      • Compare Roles
      • Salary Guides
      • Interview Questions
      • Remote Jobs
    • Resources
      • Blog
      • Resources
      • Community
    • Post a Job
    • Sign Up
    • Sign In
    • Contact
    Skip to main content
    Search jobsRemoteInterview practice
    What is WorkzilSign inGet started
    JobsChicagoData Architect | US · Cuesta Partners
    C
    Cuesta Partners10-50 employees

    Data Architect | US

    Chicago · Remote · Posted Jan 28, 2026

    Pay
    Pay not published
    Where
    Chicago · Remote
    Level
    Not stated
    Posted
    Jan 28, 2026
    Date from the source

    About the role

    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) • 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.) Architecture transformations: • Considerations / experience evaluating lift & shift vs re-model trade-offs • Considerations / experience when consolidating decentralized silos • Considerations / experience when moving to modern cloud stacks • Considerations / experience when enabling unified operational & analytics data hubs Communication & leadership skills: • 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 • Ability to teach / leverage experience to develop 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 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 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 • Collaborate and coordinate with team members, clients and external SMEs What 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 space • Active, 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 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 aligned to technologies listed in Key Areas of Focus Benefits: 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 & 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 base salary (outlined in this listing) and target bonus of 20-25% • 401k, healthcare benefits, paid time-off, and more!
    Apply on the employer's siteAI interview

    Opens the employer's application page in a new tab.

    AI interview

    Practise this interview with AI

    A mock interview for this exact role, with feedback you can act on.

    Workzil

    Workzil is one cycle: find work, read the market behind it, and hire. Every number names its source and its date.

    Back to Workzil

    Workzil sites

    • WorkzilWhat we do: one cycle, from finding work to hiring.
    • Workzil JobsOpen roles with real posting dates and published pay.
    • Workzil MarketPay and hiring for your role and place, with sources.
    • Workzil EmployersCompany pages with live roles, claimed by work email.
    © 2026 WorkzilPrivacyTerms