Database Warehouse Architect

Job Title - Database Warehouse Architect (Fractional)

Work Mode- Dallas/Fort Worth/Austin (Texas)

Job Description:

We are seeking a senior, solution-oriented Data Warehousing & Lakehouse Architect to engage on an on-demand consulting basis. This role is designed for an expert who stays current with modern data warehousing trends and has deep hands-on expertise in Databricks-led lakehouse architectures. The consultant will advise on architecture, design scalable data platforms, lead solution discovery, and guide engineering teams. This is not a full-time or staff-augmentation role; it is a high-impact advisory and solution-architecture engagement focused on clarity, correctness, and execution readiness.

Required Experience :

• Senior-level experience in Data Warehousing and Lakehouse Architecture.Deep, hands-on expertise with Databricks (Apache Spark, Delta Lake, Lakehouse patterns).
• Strong experience designing cloud-native data platforms on AWS, Azure, or GCP.
• Solid understanding of modern data warehousing trends, including:
  o Lakehouse architectures
  o Open table formats (Delta Lake, Iceberg, Hudi)
  o Decoupled storage & compute
  o Cost and performance optimization strategies
• Strong knowledge of ETL/ELT pipelines, SQL, and analytical data modeling.
• Experience with data governance, security, metadata, and access controls.
• Ability to work independently and provide high-quality architectural guidance on demand.
• Strong communication skills with a solution-first, advisory mindset.

Responsibilties:

• Provide on-demand architectural leadership for data warehousing and lakehouse initiatives.
• Design and review modern lakehouse architectures with Databricks at the core.
• Translate business, analytics, and AI requirements into scalable, cost-efficient data
  solutions.
• Lead architecture discovery sessions and solution design workshops.
• Define best practices for data ingestion, transformation, and modeling (ETL/ELT).
• Guide implementation of Databricks (Spark, Delta Lake, Unity Catalog) and Snowflake where applicable.
• Ensure data quality, governance, security, and performance optimization.
• Perform architecture reviews, feasibility assessments, and modernization recommendations.
• Advise teams on data platform choices, trade-offs, and long-term scalability.
• Collaborate with data engineers, analytics teams, and stakeholders in a consultative
  advisory capacity.
• Stay ahead of emerging data warehousing and lakehouse trends, recommending
  practical adoption paths

Preferred Certifications:

• Databricks Certified Professional (highly preferred)
• Cloud Certification (AWS, Azure, or GCP)
• Snowflake Certification – nice to have
  
  Nice to have:
  
• Experience with streaming / real-time data architectures.
• Exposure to BI and analytics platforms (Power BI, Tableau, Looker).
• Experience supporting AI / ML and GenAI workloads on Databricks.
• Prior consulting or fractional architect experience.
  
  What This Role Is (and Is Not)
  This role is:
• On-demand, flexible, and outcome-driven Architecture and solution focused
• Ideal for senior consultants or fractional architects
  This role is not:
• A full-time employment role
• A pure data engineering or operations role
• A staff-augmentation position
  
  ABOUT ISHIR
  ISHIR is a digital innovation and enterprise AI services provider. We work with startups and enterprises to shape the future through accelerated innovation, deep technical expertise, access to global digital talent and a passion for complex problem-solving. With our help, our clients overcome their most difficult digital challenges leveraging AI.
  We are not just consultants, we are partners in our clients success, assisting them with re(gaining) competitive edge by identifying opportunities for differentiation, industry disruption, scalable innovation, and go-to-market strategies that deliver successful outcomes.
  At ISHIR, we help bold businesses accelerate innovation through Talent, Speed-to-Market, and AI. We help make an impact by solving real problems using innovation, improved customer experiences and the right technologies.
  As an ISHIR employee, you will get the advanced training you need to be successful, and the opportunity to apply it. You must be passionate about technology, crave responsibility, and be eager to apply your knowledge to real business solutions for our startup and enterprise customers. These are the qualities of a person destined for success at ISHIR.
  ISHIR attracts a special type of individual someone who is proactive, thrives on challenges, feeds off success, and looks at moving targets not as obstacles but as opportunities. ISHIR is an exciting place to work. It is imbued with an entrepreneurial spirit and promotes self-reliance, open communication, and collaboration.