Senior Analytics Engineer

University of Maryland Global Campus • Adelphi, MD

1d • $142,000 - $152,000

About The Position

The Senior Analytics Engineer owns the analytics-ready layers of the University’s Databricks Lakehouse, transforming curated data into business-ready models and establishing the semantic layer that defines authoritative institutional metrics. The role sets modeling standards for the analytics team, partners with business stakeholders to define and govern metrics, and leads data work supporting traditional reporting, AI-powered analytics, and natural language query capabilities. Advanced SQL and Python proficiency are required.

The position provides technical leadership through modeling standards, code reviews, and mentoring, while supporting analytical and reporting needs with ad hoc SQL development, data validation, and Tableau development as needed. Other duties may be assigned.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, or a related field.
• Seven to ten years of experience in data, business intelligence, or analytics disciplines.
• Five or more years building and maintaining production data models and datasets consumed by business intelligence tools and business users in a cloud data warehouse or Lakehouse environment.
• Experience developing, governing, and maintaining semantic or metric layers supporting enterprise reporting and analytics.
• Experience with Databricks, SQL, Python, dimensional data modeling, and data governance practices.
• Experience establishing modeling standards, conducting code reviews, and mentoring data professionals.
• Advanced SQL, including complex joins, window functions, common table expressions (CTEs), incremental processing, and performance tuning.
• Python programming for data transformation, automation, and testing using PySpark and/or pandas.
• Databricks expertise including Delta Lake, Databricks SQL, notebooks, Workflows, declarative pipelines, Unity Catalog, and Medallion Architecture.
• Knowledge of semantic and metric layer design, governance, and change management.
• Knowledge of dimensional data modeling, star schema design, slowly changing dimensions, and metric development.
• Amazon Redshift administration and optimization skills.
• Tableau development and dashboard design skills.
• Git-based version control and development practices.
• Ability to establish modeling standards, naming conventions, and code review practices for a team.
• Ability to translate business requirements into scalable data solutions and communicate technical concepts to non-technical and executive audiences.

Nice To Haves

• Master's degree.
• Experience with Databricks metric views and supporting Databricks AI Genie Agents or similar natural language analytics platforms.
• Experience migrating legacy data warehouse environments, including Amazon Redshift, to modern Lakehouse architectures.
• Higher education experience supporting enrollment, retention, student lifecycle, academic operations, or related functions.
• Experience with PeopleSoft, D2L, Salesforce, and FERPA-regulated data.
• Experience with dbt or comparable transformation frameworks.
• Advanced Tableau dashboard and visualization development.
• Databricks, Tableau, AWS, or other relevant analytics and cloud platform certifications.

Responsibilities

• Architect, build, and maintain Gold and Platinum layer data models in Databricks, establishing design patterns, grain, and business logic, and optimizing transformations for performance and cost.
• Own and govern the semantic layer using Databricks metric views; establish authoritative institutional metric definitions with business stakeholders and manage version control and downstream impacts when definitions change.
• Lead curation of datasets, metric views, metadata, instructions, and certified SQL examples supporting Databricks AI Genie Agents and AI/BI dashboards; evaluate agent accuracy and improve results through model and semantic changes.
• Establish and administer data quality, validation, and reconciliation practices against systems of record; resolve discrepancies to root cause; and define governance, lineage, and access standards through Unity Catalog.
• Maintain and optimize Amazon Redshift reporting assets, determine the appropriate platform for new development, and lead migration of legacy assets to Databricks.
• Provide technical leadership through code review, modeling standards, and mentoring of analytics staff.
• Support analytical and reporting requirements through ad hoc SQL development, data validation, and Tableau development as needed.
• Perform other duties as assigned.

Benefits

• 22 days of paid vacation, 15 days of sick leave, 3 personal days, and 16 paid holidays (17 during general election years); part-time rates are prorated.
• Health care, medical with vision, dental, and prescription plans for individuals and families, effective from the first day of the month following the hire date.
• Term Life Insurance, Accidental Death and Dismemberment Insurance, and Long-Term Disability Insurance.
• Flexible Spending Accounts for medical and dependent care expenses.
• Retirement plan choice between the Optional Retirement Program (ORP) and Maryland State Retirement and Pension System (MSRPS).
• Supplemental retirement plans include 401(k), 403(b), 457(b), and Roth options; the university does not provide matching funds.
• Tuition remission is immediately available for Regular Exempt Staff; spouses and dependent children are eligible for undergraduate tuition remission after two years of service. Part-time tuition remission is prorated.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior