Lead BI Analyst
Summary
Lead BI Analyst reverse-engineering legacy data solutions, reading/writing complex SQL and ETL logic, tracing data lineage, and applying Kimball dimensional modeling (fact/dimension design, SCD, STAR schema).
High-Priority Skills Reverse Engineering Legacy Data Solutions Read, write, and interpret complex SQL procedures, views, and ETL logic Trace lineage across multiple source systems Identify embedded business rules Document derived calculations and transformations Reconstruct requirements from existing reports and code Kimball Dimensional Modeling Expertise (modelling and mart concepts) Fact table design Dimension design Conformed dimensions Slowly Changing Dimensions Grain definition STAR Schema…