{{ config(materialized='table') }}
select
employee_id,
employee_name,
employee_email,
hire_date,
department,
annual_salary,
case
when annual_salary >= 90000 then 'Senior'
when annual_salary >= 70000 then 'Mid-Level'
else 'Junior'
end as salary_tier,
current_timestamp as created_at
from {{ ref('stg_employees') }}