Azure Databricks Data Architect | Ampcus Inc. | Michigan City, IN

Ampcus Inc.; Michigan City (IN); On-site; USD 140,000 - 180,000; Full time

Job summary

Ampcus Inc. is seeking an Azure Databricks Data Architect to lead analytics modernization in Michigan City, IN. This senior role drives cloud-native data platforms, lakehouse design, and distributed pipelines across a mission-critical cloud ecosystem on-site.

You will define standards, govern data, and align enterprise models with business goals to deliver scalable, secure analytics capabilities. Requires 10+ years in data architecture and Azure expertise.

Qualifications

• Bachelor's or Master's degree in a technical field (CS/IS/Data Engineering).
• 10+ years in enterprise data architecture and warehousing.
• 6+ years hands-on Azure data solutions experience.
• Proven expertise with Azure Databricks, Delta Lake, and Unity Catalog.

Responsibilities

• Lead the enterprise data architecture strategy and deployment of analytics solutions.
• Architect and govern lakehouse and warehouse solutions on Azure ecosystem.
• Design and optimize automated ELT/ETL pipelines using Azure Data Factory and Logic Apps.
• Author and performance-tune high-volume data transformations with Spark/PySpark.
• Define dimensional modeling and OLAP principles across BI needs.
• Enforce data governance, access control, and security standards.

Skills

Leadership

Data governance

Enterprise data architecture

Stakeholder collaboration

Education

Bachelor's or Master's degree in Computer Science/Information Systems/Data Engineering

Tools

Azure Databricks

Delta Lake

Unity Catalog

Azure Synapse Analytics

Azure Data Factory

Logic Apps

PySpark

Spark-SQL

Azure Data Lake Storage (ADLS Gen2)

Job description

Position Summary

As an Azure Databricks Data Architect at Ampcus Inc., you will serve as the principal enterprise data solutions authority leading large-scale analytics modernization in Michigan City, IN. Operating on-site across a mission-critical cloud ecosystem, this senior technical leadership role is dedicated to architecting high-performance lakehouse platforms, multi-tiered data warehousing, and distributed data pipelines. You will steer data modernization strategy, define architectural standards, and align enterprise data models with business objectives to deliver robust, scalable, and secure cloud analytics capabilities.

Detailed Job Description

The Azure Databricks Data Architect is responsible for the overarching architectural blueprint, technical governance, and end-to-end delivery of modern data platforms across Microsoft Azure. In this position, you will direct the technical design and optimization of data pipelines utilizing Azure Databricks, Unity Catalog, Azure Data Factory, and Azure Synapse Analytics. Your daily responsibilities encompass authoring distributed data models, architecting lakehouse storage layers with Azure Data Lake Storage (ADLS Gen2), and crafting high-throughput Spark-SQL and PySpark transformation frameworks to support complex analytical workloads.

Operating within an enterprise-scale environment, you will bridge technical design with business strategy, guiding data architecture decisions across multi-faceted programs and collaborating closely with engineering teams and executive stakeholders. You will implement enterprise-grade data governance, fine-grained access policies, encryption mechanisms, and regulatory compliance standards using Unity Catalog and Microsoft Fabric. The scope demands an experienced data leader with a proven background in dimensional modeling, OLAP cubes, and automated pipeline orchestration using Logic Apps to ensure high reliability, optimal query latency, and unified data democratization.

Key Responsibilities

• Lead the enterprise data architecture strategy, design, and deployment of modern analytics solutions leveraging Azure Databricks and Microsoft Fabric.
• Architect and govern scalable lakehouse and warehouse solutions utilizing Azure Databricks, Unity Catalog, Azure Synapse Analytics, and Azure SQL.
• Design, build, and optimize automated enterprise ELT/ETL ingestion pipelines utilizing Azure Data Factory, Logic Apps, and event-driven architectures.
• Author, refactor, and performance-tune high-volume data transformation routines utilizing advanced SQL, Spark-SQL, and PySpark.
• Establish dimensional data modeling frameworks, star/snowflake schemas, and enterprise OLAP architectures supporting business intelligence.
• Define and enforce unified data governance, access controls, data lineage, and metadata management strategies using Databricks Unity Catalog.
• Ensure stringent cloud data security, privacy compliance, network segmentation, and encryption across Azure Data Lake Storage environments.
• Provide senior technical guidance, architectural design reviews, and engineering best practices to distributed development and data engineering teams.
• Partner with executive stakeholders and program managers to evaluate analytics modernization roadmaps and influence technology investments.
• Produce comprehensive High-Level Design (HLD) documents, Low-Level Design (LLD) specifications, data dictionaries, and architectural diagrams.

Required Qualifications & Skills

• Bachelor's or Master's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related technical discipline.
• Minimum of 10+ years of progressive professional experience in enterprise data architecture and data warehousing design.
• Minimum of 6+ years of dedicated, hands-on experience architecting and implementing cloud data solutions on Microsoft Azure.
• Proven subject matter expertise with Azure Databricks, Delta Lake, and enterprise metadata governance utilizing Unity Catalog.
• Extensive hands-on experience orchestrating data workflows using Azure Data Factory, Azure Synapse Analytics, Azure SQL, and Azure Data Lake.
• Demonstrated proficiency in advanced relational SQL, Spark-SQL, and distributed data processing using PySpark.
• In-depth background in dimensional modeling, data lakehouse patterns, star/snowflake schemas, and enterprise OLAP principles.
• Solid foundation in enterprise data governance, zero-trust security architecture, access control policies, and compliance standards.

Nice-to-Have Skills

• Overall career trajectory demonstrating 15+ years of total IT and software engineering experience.
• Practical hands-on architectural experience with Microsoft Fabric deployment and unified analytics workloads.
• Industry-standard certifications such as Databricks Certified Data Engineer Professional or Microsoft Certified: Azure Data Engineer Associate.
• Demonstrated experience implementing automated CI/CD pipelines for data engineering using Azure DevOps, GitHub Actions, or Terraform.
• Experience orchestrating complex cloud application workflows using Azure Logic Apps, Azure Functions, or message brokers.

Application Information

• Recruiter / Staffing Firm: Ampcus Inc.
• Work Location: Michigan City, IN (Strictly Onsite)
• Local Candidate Requirement: This opportunity is open only to candidates currently based in Michigan City, IN or immediate commuting vicinity
• Expected Contract Duration: 6+ months
• Experience Parameter: 15+ years of total experience preferred by hiring team
• Employment Type: Contract