Note: The job is a remote job and is open to candidates in USA. Optomi, in partnership with a leading organization in the airline and travel industry, is seeking a Lead Data Engineer for a contract position. The role leads the design of enterprise data models and semantic layers that support AI, analytics, and business intelligence applications across Databricks and AWS, while establishing standards for governance, metadata, lineage, and data quality.
Responsibilities
- Lead the design and implementation of enterprise data models and semantic layers supporting AI, analytics, and business intelligence applications
- Partner with business and technical stakeholders to understand AI/BI use cases and determine the data required to support them
- Identify, ingest, transform, and model data from enterprise source systems into trusted datasets that can be consumed by downstream applications
- Design semantic models that establish consistent business terminology, metrics, dimensions, relationships, and definitions across data sources
- Build and maintain semantic capabilities within Databricks, including solutions leveraging Unity Catalog and related platform capabilities
- Support the data foundation required for AI/BI solutions built across Databricks, AWS, and emerging analytics platforms
- Partner closely with Solution Tech Leads and engineering teams to determine the appropriate data architecture for new AI/BI use cases
- Establish reusable patterns and standards for data modeling, semantic modeling, metadata, governance, lineage, and data quality
- Evaluate data readiness for new AI and analytics use cases and identify gaps that must be addressed before solutions can move into development
- Help ensure AI/BI applications are grounded in accurate, governed, well-understood enterprise data
- Provide technical leadership and mentorship to Data Engineers and other technical team members
- Collaborate across architecture, engineering, analytics, product, and business teams to accelerate delivery of high-value Decision Intelligence solutions
Skills
- Strong experience in Data Engineering, Data Architecture, Data Modeling, or Semantic Modeling within large enterprise environments
- Hands-on experience with Databricks and modern lakehouse/data platform architectures
- Experience designing and implementing semantic layers that make complex enterprise data understandable and consumable by analytics and AI applications
- Strong understanding of dimensional, relational, and analytical data modeling concepts
- Experience working with Databricks Unity Catalog and/or similar metadata, governance, and cataloging technologies
- Strong experience designing, building, and optimizing data pipelines and data transformations
- Experience integrating data from multiple enterprise systems and establishing trusted, reusable datasets
- Understanding of data governance, lineage, metadata management, data quality, access controls, and security
- Experience supporting BI, analytics, machine learning, or Generative AI use cases with enterprise data
- Experience working within AWS-based data environments
- Ability to partner with technical and business stakeholders to translate business concepts into scalable data models
- Strong communication skills with the ability to explain complex data relationships and architecture decisions to both technical and non-technical audiences
- Experience with AI/BI capabilities such as Databricks Genie is highly preferred
- Experience supporting semantic models for natural-language analytics, Generative AI, or conversational BI solutions is a strong plus
Benefits
- 100% remote work
- The opportunity to help establish the data and semantic modeling foundation for a growing enterprise Decision Intelligence and AI/BI organization.
- The opportunity to design data and semantic layers supporting high-visibility solutions built across Databricks, AWS, and modern AI/BI platforms.
- The opportunity to work closely with Technical Leads, Product Owners, Architects, Data Engineers, business stakeholders, and platform teams to take AI/BI use cases from concept through production.
- The opportunity to influence enterprise standards around data modeling, governance, metadata, lineage, quality, and reusable data products.
Company Overview
Company H1B Sponsorship