Jobs · Engineering · Missouri

Sr. Data Architect (Databricks)

Techwave · Kansas City, Missouri, United States · 2 mo ago
EngineeringFull-time

About Us

Techwave is a leading global IT and engineering services and solutions company revolutionizing digital transformations. Founded in 2004 and headquartered in Houston, TX, USA, we enable clients to maximize their potential through a wide array of technology services, including Enterprise Resource Planning, Application Development, Analytics, Digital, and the Internet of Things (IoT). We foster a culture of growth and inclusivity, challenging our team at every step to excel and pushing the boundaries of what's possible.

Responsibilities

  • Solution Architecture
    • Design end-to-end Lakehouse architectures using Databricks.
    • Define enterprise data architecture aligned with business and technology strategies.
    • Lead cloud data modernization and migration initiatives.
    • Develop scalable, secure, and highly available data platforms.
  • Data Engineering
    • Design ETL/ELT frameworks using Apache Spark and Databricks.
    • Architect batch and real-time streaming data pipelines.
    • Design Medallion Architecture (Bronze, Silver, Gold).
    • Define data ingestion strategies for structured, semi-structured, and unstructured data.
    • Implement Change Data Capture (CDC) and incremental processing.
  • Data Modeling
    • Design enterprise data models using Dimensional Modeling, Star Schema, Snowflake Schema, and Data Vault.
    • Build semantic models for reporting and analytics.
  • Databricks Platform Architecture
    • Design and optimize Delta Lake, Unity Catalog, Databricks Workflows, Delta Live Tables (DLT), Databricks SQL, MLflow, and Lakeflow.
    • Establish workspace standards and architecture patterns.
    • Define notebook, job, and code organization strategies.
  • Performance & Cost Optimization
    • Optimize Spark jobs and SQL workloads.
    • Improve partitioning, clustering, and file layouts.
    • Reduce cloud infrastructure costs through autoscaling and efficient cluster sizing.
    • Implement monitoring for compute utilization and query performance.
  • Security & Governance
    • Implement Unity Catalog for centralized governance.
    • Design role-based access control (RBAC).
    • Configure row-level and column-level security.
    • Establish metadata management, lineage, and auditing.
    • Ensure compliance with enterprise security and regulatory standards.
  • AI & Advanced Analytics
    • Architect AI/ML platforms using Databricks.
    • Enable ML lifecycle management with MLflow.
    • Design data pipelines for machine learning workloads.
    • Support Generative AI and Retrieval-Augmented Generation (RAG) solutions by integrating Databricks with vector databases and AI services.
  • DevOps & Automation
    • Define CI/CD strategies using Azure DevOps or GitHub Actions.
    • Implement Infrastructure as Code (Terraform preferred).
    • Automate deployment of notebooks, jobs, workflows, and platform configurations.
    • Establish version control and branching strategies.
  • Leadership & Governance
    • Lead architecture reviews and design workshops.
    • Define technical standards and best practices.
    • Mentor Data Engineers and Technical Leads.
    • Collaborate with business stakeholders, project managers, and cloud architects.
    • Provide technical leadership during project delivery.
  • Typical Project Responsibilities
    • Design enterprise Lakehouse architectures.
    • Migrate legacy data warehouses to Databricks.
    • Build scalable ETL/ELT pipelines using Spark.
    • Implement Delta Lake and Unity Catalog.
    • Establish governance, security, and metadata management.
    • Optimize performance and cloud costs.
    • Deliver curated datasets for BI, AI/ML, and analytics.
    • Define DevOps, CI/CD, and operational best practices.
    • Lead architecture reviews and guide technical teams throughout the project lifecycle.

Requirements

  • Technical Skills
    • Databricks: Databricks Lakehouse Platform, Apache Spark (PySpark and Spark SQL), Delta Lake, Unity Catalog, Delta Live Tables, Databricks Workflows, Databricks SQL, MLflow, Structured Streaming.
    • Cloud Platforms: Microsoft Azure (preferred), including Azure Data Lake Storage Gen2, Azure Data Factory, Azure Synapse Analytics, Azure Key Vault, Microsoft Entra ID. AWS or Google Cloud experience is also valuable.
    • Data Engineering: ETL/ELT Architecture, Data Lakes, Data Warehousing, Data Modeling, CDC, Streaming Architecture, Metadata Management.
    • Programming: Python, PySpark, SQL, Scala (preferred).
    • Databases: SQL Server, Oracle, PostgreSQL, Snowflake.
    • BI & Analytics: Power BI, Tableau, Semantic Modeling.
    • DevOps: Git, Azure DevOps, GitHub, Terraform, CI/CD Pipelines.
  • Experience
    • 10–15+ years of IT experience.
    • 5+ years of hands-on Databricks architecture and implementation experience.
    • Experience designing enterprise data platforms on Azure, AWS, or GCP.
    • Proven experience in large-scale data migration and cloud modernization projects.
    • Experience integrating enterprise systems such as SAP, Oracle, Salesforce, Workday, or other business applications.
  • Qualifications
    • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
    • Master's degree is preferred.
  • Preferred Certifications
    • Databricks Certified Data Engineer Professional
    • Databricks Certified Data Engineer Associate
    • Databricks Certified Machine Learning Professional (preferred)
    • Microsoft Certified: Azure Data Engineer Associate
    • Microsoft Certified: Azure Solutions Architect Expert
    • Azure Fundamentals (AZ-900)
  • Key Competencies
    • Enterprise architecture and solution design
    • Distributed data processing expertise
    • Data governance and security
    • Performance tuning and optimization
    • Cost optimization
    • Stakeholder management
    • Leadership and mentoring
    • Problem-solving and analytical thinking
    • Communication and presentation skills
    • Strategic planning

Similar jobs