Databricks Analytics Engineer: AI‑Ready Data Models

Stateside; Adelphi (MD); On-site; USD 110,000 - 125,000; Full time

Benefits offered by this job

Tuition Remission

Generous Time Off

Health Coverage

Retirement Plans

Job summary

The University of Maryland Global Campus (UMGC) is seeking an Analytics Engineer to build and maintain analytics-ready layers in Databricks Lakehouse, transforming curated data into business-ready models and contributing to the semantic layer that defines institutional metrics. Strong SQL and Python proficiency are required to deliver data products for reporting, AI analytics, and dashboards.

The role emphasizes collaboration, data governance, and the ability to interpret business requirements

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, or related field.
• 3–5 years of experience building production data models, datasets, or reporting assets consumed by BI tools.
• Experience writing production SQL against a cloud data warehouse or Lakehouse.
• Experience working within an established data architecture and following defined modeling, testing, and documentation standards.

Responsibilities

• Build and maintain Gold and Platinum layer data models in Databricks following established design patterns, transforming curated data into business-ready and consumption-ready objects using SQL and Python, orchestrated through Databricks Workflows and declarative pipelines.
• Develop and maintain semantic layer objects using Databricks metric views, implementing approved institutional metric definitions and documenting them clearly for business consumers.
• Prepare and maintain the datasets, metadata, descriptions, and example queries that support Databricks AI Genie Agents and AI/BI dashboards; test agent responses against expected results and elevate issues requiring model changes.
• Test, validate, and reconcile modeled results against systems of record; investigate discrepancies, document findings, and maintain data lineage and catalog documentation in Unity Catalog.
• Maintain, troubleshoot, and optimize Amazon Redshift reporting assets, supporting ongoing business needs and migration initiatives to Databricks.
• Support analytical and reporting requirements through ad hoc SQL development, data validation activities, and Tableau dashboard development and maintenance.
• Other duties as assigned.

Job description

The University of Maryland Global Campus (UMGC) is seeking an Analytics Engineer to build and maintain analytics-ready layers in Databricks Lakehouse, transforming curated data into business-ready models and contributing to the semantic layer that defines institutional metrics. Strong SQL and Python proficiency are required to deliver data products for reporting, AI analytics, and dashboards.

The role emphasizes collaboration, data governance, and the ability to interpret business requirements