I really like this approach. It seems to me that this is not about deployment process, but more about something that can be called configurable jobs/transforms. Let's say an analyst can write several parametrized SQL templates that are used in a job, so the job is deployed once, but has several configurations (DeploymentJobs). Earlier I used OPEN and DOSUBL functions for such purposes, but EMBED macro seems more readable to me, definitely will try it.