Analytics Engineer

Merit AmericaNonprofit Education

Candidates must reside within the 50 states or District of ColumbiaFull-TimeMiddle

Salary152,000 USD per year

Apply NowOpens the employer's application page

Job Details

4+ years working with SQL and a modern cloud data warehouse.
Strong hands-on experience with dbt.
Experience building and maintaining canonical data models and governed metrics.
Experience working with a semantic layer or governed BI environment (e.g., Lightdash, LookML, dbt Semantic Layer).
Strong grasp of data modeling concepts and judgment in evolving business domains.
Comfort experimenting with AI tools with strong judgment around validation and data quality.
History of proactively improving data models, reporting systems, or governance processes.
Strong communication skills with technical and non-technical stakeholders.
Proficiency in development disciplines like version control, code review, testing, and documentation.
Committed to Merit America's mission of creating pathways to family-sustaining careers.

Own and evolve the dbt models that transform raw source-system data into durable, reporting-ready tables.
Improve models over time by reducing duplication, clarifying grain, and documenting business logic.
Turn recurring reporting needs into reusable models rather than one-off queries.
Own the Lightdash semantic layer so core metrics are defined consistently and documented where they're used.
Maintain source-of-truth definitions, promoting and deprecating metrics as the business changes.
Build and maintain observability, testing, and monitoring across the analytics stack to identify and resolve data quality issues.
Maintain strong development practices, including version control, PR review, and documentation.
Review analytics work for modeling quality and maintainability, and help analysts use the stack effectively.

View Full Description & ApplyYou'll be redirected to the employer's site