Senior Business Intelligence Analyst

Sr. BI Analyst (On-site, 12 months) (Only w2) We’re seeking a Senior Business Intelligence Analyst to strengthen data modeling and architecture capabilities for major capital and analytics programs. This is a fully on-site, 12-month engagement supporting initiatives such as Resilience Analytics, AOA, PIMS, X1FBO, and SmartSuite. What you’ll do • Lead data modeling and architecture efforts for data warehouses, data marts, and data lakes. • Design logical and physical data models and implement best practices (star schemas, snowflake schemas, SCDs, aggregations). • Build, maintain, and optimize ETL/ELT routines, SQL scripts, and metadata repositories. • Create and support BI projects and dashboards using tools such as Tableau, Power BI, MicroStrategy, and Dataiku. • Work with system and database administrators, business analysts, and QA to test, tune, and deploy analytics solutions. • Participate in conceptual phases to identify and solve business and operational data problems. • Produce functional requirements, documentation, and support planning and budget activities for BI initiatives. • Analyze statistical and operational data to identify trends and support decision-making. Required skills & experience • Strong understanding of data warehousing architectures and modeling methodologies (star schema, snowflake, SCDs, aggregation techniques). • Proven experience creating logical and physical data models for data marts, data warehouses, and data lakes. • Hands-on SQL expertise; experience with PL/SQL, stored procedures, triggers, functions, and partitioning. • Experience building and maintaining enterprise BI solutions and dashboards (Tableau, Tableau Desktop/Cloud, Power BI, MicroStrategy, Dataiku). • History of delivering production-ready analytics solutions using Agile/Scrum and cloud technologies. • Experience in enterprise-level architecture services and supporting large, multi-year programs. • Strong analytical skills; ability to interpret statistical data and identify meaningful trends. Nice to have • Experience with medallion architecture or modern multi-layered data platforms. • Prior work supporting capital projects or airport/transportation programs.