LiftmyCVLiftmyCV

Analytics Engineer

UmgcOn-siteAdelphi, US$110,000–$125,000 per year
AI job summary

The Analytics Engineer will build and maintain analytics-ready layers of the University's Databricks Lakehouse, transforming curated data into business-ready models while supporting various data products and legacy reporting environments. The individual will utilize strong SQL and Python skills to manage data models in Databricks, collaborate on semantic layer definitions, maintain datasets, and assist in ad hoc SQL development. The role requires a Bachelor's degree and 3-5 years of relevant experience in data modeling and analytics.

Job description

Analytics Engineer

Analytics

Exempt Regular 3.2

Location: Adelphi, MD

The Analytics Engineer builds and maintains the analytics-ready layers of the University's Databricks Lakehouse, transforming curated data into business-ready models and contributing to the semantic layer that defines institutional metrics. Working within established modeling standards, this role delivers data products that support traditional reporting, AI-powered analytics, and natural language query capabilities, and helps maintain legacy reporting environments. Strong SQL and Python proficiency are required.

Duties and 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 escalate 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.

Competencies:

  • Analytical Thinking
  • Quality & Accuracy
  • Data Governance & Stewardship
  • Problem Solving
  • Collaboration & Communication
  • Continuous Learning
  • Customer Focus
  • Accountability & Follow-Through

Skills:

  • Strong SQL, including joins, aggregations, window functions, common table expressions (CTEs), and query troubleshooting.
  • Python programming for data transformation, automation, and testing using PySpark and/or pandas.
  • Working knowledge of Databricks including Delta Lake, Databricks SQL, notebooks, Workflows, and Medallion Architecture.
  • Dimensional data modeling fundamentals, including star schema concepts, fact and dimension tables, and definition of grain and keys.
  • Familiarity with semantic and metric layer concepts and with documenting metric definitions.
  • Amazon Redshift SQL development and troubleshooting.
  • Tableau development and dashboard design.
  • Git-based version control and development practices.
  • Ability to interpret business requirements, ask clarifying questions, and communicate technical concepts to non-technical audiences.

Education & Experience Requirements:

Education:

Bachelor's Degree Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, or a related field.

Experience:

  • Three (3) to five (5) years of experience building and maintaining production data models, datasets, or reporting assets consumed by business intelligence tools and business users.
  • Experience writing production SQL against a cloud data warehouse or Lakehouse platform.
  • Experience working within an established data architecture and following defined modeling, testing, and documentation standards.

Certifications:

  • N/A

Preferred Experience Requirements:

Education:

Bachelor's Degree

Experience:

  • Hands-on experience with Databricks, including Delta Lake, Databricks SQL, and Workflows within a Medallion Architecture.
  • Experience contributing to semantic or metric layer development.
  • Exposure to AI-enabled or natural language analytics platforms such as Databricks AI Genie Agents.
  • Higher education experience supporting enrollment, retention, student lifecycle, academic operations, or related functions.
  • Experience with PeopleSoft, D2L, Salesforce, or FERPA-regulated data.
  • Advanced Tableau dashboard and visualization development.

Certifications:

  • Databricks, Tableau, AWS, or other relevant analytics and cloud platform certifications.

All submissions should include a cover letter and resume. The University of Maryland Global Campus (UMGC) is an equal opportunity employer and complies with all applicable federal and state laws regarding nondiscrimination. UMGC is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, national origin, age, marital status, sex, sexual orientation, gender identity, gender expression, disability, religion, ancestry, political affiliation or veteran status in employment, educational programs and activities, and admissions.

Workplace Accommodations:

The University of Maryland Global Campus Global Campus (UMGC) is committed to creating and maintaining a welcoming and inclusive working environment for people of all abilities. UMGC is dedicated to the principle that no qualified individual with a disability shall, based on disability, be excluded from participation in or be denied the benefits of the services, programs, or activities of the University, or be subjected to discrimination. For information about UMGC’s Reasonable Workplace Accommodation Policy or to request an accommodation, applicants/candidates can contact Employee Accommodations via email.

Benefits Package Highlights:

  • Generous Time Off: Enjoy 22 days of paid vacation, 15 days of sick leave, 3 personal days, and 16 paid holidays (17 during general election years). For part-time employees, time off rates will be prorated based on the number of hours worked.
  • Comprehensive Health Coverage: Access to health care, medical with vision, dental, and prescription plans for both individuals and families, effective from the 1st of the month following your hire date.
  • Insurance Options: Term Life Insurance, Accidental Death and Dismemberment Insurance, and Long-Term Disability (LTD) Insurance. Part-time employees working less than 0.5 FTE are not eligible for LTD.
  • Flexible Spending Accounts: Available for medical and dependent care expenses.
  • Retirement Plans: Choose between the Optional Retirement Program (ORP) or the Maryland State Retirement and Pension System (MSRPS).
  • Supplemental Retirement Plans: include 401(k), 403(b), 457(b), and various Roth options. The university does not provide matching funds.
  • Tuition Remission: Immediate availability for Regular Exempt Staff. Spouses and dependent children are eligible for undergraduate tuition remission after two years of service. NOTE: For part-time employees (at least 50 percent of the time), tuition remission benefits are prorated.

Hiring Range:

$110,000.00 - $125,000.00

Responsibilities

Build and maintain Gold and Platinum layer data models in Databricks; develop and maintain semantic layer objects; prepare datasets and test AI agents; maintain Amazon Redshift reporting assets; support ad hoc SQL and Tableau development.

Job details

Published
October 13, 2026
Job source
myworkdayjobs
Workplace
On-site · Adelphi, US
First seen
October 14, 2026

Requirements

Bachelor's Degree in relevant fields; 3-5 years of experience building data models; experience with cloud data warehouses or Lakehouse platforms.

Benefits

Generous Time Off, Comprehensive Health Coverage, Insurance Options, Flexible Spending Accounts, Retirement Plans, Tuition Remission.

Skills mentioned in this job

SQLPythonDatabricksRedshiftTableau

LiftmyCV exclusive data

Umgc hiring intelligence

Umgc currently has 20 active jobs tracked by LiftmyCV. 20 new jobs in the past 7 days.

Active openings

20

Currently tracked by LiftmyCV

New in 7 days

20

20 new jobs in the past 30 days

Published salaries

5%

Median disclosed salary: $41,500

Average opening age

3 days

Across 20 active openings

Workplace breakdown

Remote5%
Hybrid10%
On-site85%

Hiring countries

Germany
Guam
United States of America
Poland

Top hiring cities

Stuttgart
Andersen Air Force Base
Adelphi
Kaiserslautern
Spangdahlem
Powidz
Zagan

Most in-demand roles

  • • Adjunct Faculty - Polish Language
  • • Academic Affairs Coordinator
  • • Adjunct Faculty
  • • Adjunct Faculty - Science: Biology, Geology, Nutrition, Chemistry
  • • Adjunct Faculty - Writing and Speech
  • • Adjunct Faculty, German Language

Frequently requested skills

ISO 27001
## Education:
and federation technologies
and KPI reporting
and procedures
Authentication
authorization
CIS Controls)

Median disclosed salary: $41,500 · 5% of jobs publish a salary

As of November 17, 2026

Hiring insights calculated from active jobs tracked by LiftmyCV.

AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

More at Umgc

Similar jobs from this company

Across the market

Similar jobs from other companies

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.