Analytics Engineer
Core
Builds and maintains analytics-ready layers of a Databricks Lakehouse, transforming curated data into business-ready models and contributing to the semantic layer for institutional metrics.
Role type
Analytics Engineer (Data Modeling & Semantic Layer)
Builds
Data products supporting traditional reporting, AI-powered analytics, and natural language query capabilities
Domain
Higher Education / Data Engineering
Deliverable
production ML models
Required skills
SQL, Python, Databricks (Delta Lake, Workflows), Dimensional data modeling, Amazon Redshift, Tableau, Git
Preferred skills
Semantic/metric layer development, AI-enabled analytics platforms, Higher education domain data, PeopleSoft/Salesforce experience
Technologies
Databricks, Delta Lake, Amazon Redshift, Tableau, Unity Catalog, PySpark, pandas
Responsibilities
Build and maintain Gold/Platinum layer data models; Develop and maintain semantic layer objects; Prepare datasets for AI Genie Agents and dashboards; Validate modeled results and maintain data lineage; Maintain and optimize Amazon Redshift reporting assets; Support ad hoc SQL and Tableau dashboard development
Seniority
Mid-level (3-5 years experience)
