Analytics Engineer

American Public Education, Inc. (APEI)

Analytics Engineer designing and building governed analytics assets that transform trusted enterprise data into decision-ready information at APEI. Collaborating with various teams to ensure quality and scalability.

Posted 7/25/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in developing and optimizing semantic and analytical models, ensuring compliance with industry standards while collaborating effectively with cross-functional teams. Proficient in SQL and familiar with cloud data platforms, contributing to the creation of scalable, governed analytical assets.

Highest-signal resume keywords

Semantic Model DevelopmentSQL ProficiencyAnalytics EngineeringDimensional ModelingPower BI Familiarity

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Semantic Model DevelopmentAnalytical Data Model DevelopmentSQL ProficiencyData TransformationDimensional ModelingPerformance OptimizationTesting PracticesVersion ControlRelease ManagementBusiness Calculation Logic

Soft Skills

CollaborationCommunicationDocumentation

Tools & Technologies

SnowflakePower BIDbtGitCI/CD

Industry Keywords

Data QualityMetadataLineageAccess ControlsCompliance StandardsSOXFERPA

Tech Stack

Tools & technologies

CloudSQL

About the role

Key responsibilities & impact

Build, test, document, and maintain governed semantic models, certified metrics, dimensions, calculations, and reusable analytical assets.
Translate approved business capabilities and decision requirements into consistent analytical logic used across reports, dashboards, workflows, and AI-enabled capabilities.
Partner with Data Engineering to confirm that source data, transformations, and Gold Information Products support the intended analytical use.
Collaborate with Product Management, analysts, Governance Operations, and business subject-matter experts to clarify requirements and validate analytical meaning.
Define and certify measures, thresholds, targets, comparisons, warning conditions, and dimensional relationships.
Maintain automated quality tests, metadata, lineage, documentation, certification evidence, and release records for assigned assets.
Optimize analytical models and queries for performance, scalability, reuse, and efficient consumption across supported platforms.
Support controlled promotion of assets through development, testing, and production environments in accordance with release, security, and compliance standards.
Monitor production assets, investigate quality or performance issues, assess downstream impacts, and implement approved corrections.
Contribute to peer reviews, shared engineering standards, naming conventions, reusable patterns, and continuous improvement across the Enterprise Intelligence organization.

Requirements

What you’ll need

Experience developing semantic models, analytical data models, reusable metrics, dimensions, and business calculation logic.
Strong SQL skills and experience working with cloud data platforms, preferably Snowflake.
Experience with analytics engineering, data transformation, testing, version control, and deployment practices.
Working knowledge of dimensional modeling, data quality, metadata, lineage, access controls, and release management.
Ability to translate business and decision requirements into scalable, governed analytical assets.
Experience optimizing models and queries for performance, reliability, and reuse.
Familiarity with business intelligence and analytical consumption tools, preferably Power BI.
Ability to troubleshoot data, logic, performance, and downstream dependency issues.
Strong documentation, collaboration, and communication skills.
Experience working in a regulated or controlled environment is preferred, including SOX, FERPA, or similar compliance requirements.
Familiarity with dbt, Git, CI/CD, and AI-ready semantic design is preferred.

Benefits

Comp & perks

Equal opportunity employer
Collaborate with Product Management, analysts, Governance Operations, and business subject-matter experts