Senior Business Intelligence Engineer
Core
Build governed data models and reporting across loan, CRM, and marketing data to drive lending and marketing decisions.
Role type
Senior IC analytics engineer (BI)
Builds
Production data models, executive dashboards, and governed KPIs
Domain
Mortgage lending / Consumer finance
Required skills
Advanced SQL, dbt, cloud data warehouse (Databricks/Snowflake), Power BI/Sigma, ETL/ELT design, Python, data modeling (Kimball), CI/CD
Preferred skills
Mortgage/lending domain knowledge, multi-channel marketing attribution, Unity Catalog, Microsoft BI stack, RPA
Technologies
dbt, Databricks, Snowflake, Power BI, Sigma, Salesforce, Git, Azure DevOps
Responsibilities
Design and maintain dimensional data models across Bronze, Silver, and Gold layers; Integrate and reconcile data from loan origination systems, CRM, and third-party vendors; Build executive and operational dashboards; Define and document governed KPIs; Own data quality through profiling and automated testing; Lead migration from legacy data warehouse to cloud; Mentor analysts on SQL and data modeling.
Seniority
Senior, hands-on IC