Logo
Cuesta Partners

Data Architect

Cuesta Partners, Chicago, Illinois, United States, 60290

Save Job

Overview

Join to apply for the

Data Architect

role at

Cuesta Partners . This range is provided by Cuesta Partners. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range

$175,000.00/yr - $225,000.00/yr Cuesta Partners

is a technology strategy consulting firm supporting organizations of various sizes throughout their technology journey. We help firms: Identify, scope, prioritize, design and deliver AI and Data Solutions that create transformative value for middle and enterprise class organizations Consider or prepare for acquisition – often by improving the company\'s data posture Through new product development or reinvigoration, new team structures, or adopting new practices and tools – including the use of modern data technologies Guide leadership teams in developing vision, direction, and scalable strategies for their technology business – including implementation of comprehensive data programs We believe in the power of technology to create sustained, differentiated advantage for our clients. We are a unique, energetic firm that believes in challenging convention, moving quickly, and seeking ongoing personal growth. Every team member has agency in helping to build the firm where they\'ve always wanted to work. Sound like you? 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 Focus Areas

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 of the design trade-offs around different modeling approaches Ability to lead model review sessions, present design options and implications to both executives and technical teams 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 Expertise areas

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 Consolidating decentralized silos Moving to modern cloud stacks Enabling unified operational & analytics data hubs Communication & leadership

Able to identify & evaluate most important criteria when making design decisions Able to anticipate 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 Use past experiences to help with change management What You\'ll Do

Design the business data model based on 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 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, and master data Define reference architecture to guide data system creation and improvement Define data flows: data producers, data consumers, data transitions and governance 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 or Statistics) 10+ years of work experience in the data analytics space 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 Focus Areas Benefits

Constant opportunities for exposure & learning Flexible working location and personal-life balance Agency and influence in the company\'s total strategy and direction Collaboration with a high-performing team Competitive base salary and target bonus of 20-25% 401k, healthcare benefits, paid time-off, and more Seniority level

Mid-Senior level Employment type

Full-time Job function

Engineering and Information Technology Industries: Business Consulting and Services Note: This refined description preserves the core content and structure while eliminating extraneous boilerplate and formatting irregularities from the original posting.

#J-18808-Ljbffr