Lead BI Analyst

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 Schemas

• Data Discovery and Data Profiling
• Data profiling
• Source-to-target mapping
• Data reconciliation

• Business Rules Extraction
• Document inclusion/exclusion criteria
• Define calculations
• Create business-friendly rule documentation