Senior Technical Business Analyst

Position Sr. Technical Business Analyst (Financial/Investment Banking) Preferred. Location NYC, NY & Dallas, TX (100% onsite) Duration 12 Months Apply Apply here - Eligibility H1-B, Citizen, GC & GC‑EAD with a minimum of 12 years of experience. Locals or within a 50‑mile radius only. Required Experience Financial/Investment Banking Experience Expertise in Power BI Primary Skills (Must-Have) Azure, SQL, ETL/ELT (preferred) Finance Domain Knowledge: financial data structures, KPIs, reporting needs, reconciliation concepts, and data accuracy/compliance expectations. Data Modeling & Analysis: strong capability in dimensional/logical modeling, data profiling, data quality analysis, and translating business logic into data structures. Expert SQL: advanced SQL for extraction, transformation/validation, performance tuning, and supporting analytics/reporting use cases. Data Warehouse Expertise: data architecture, ingestion/integration patterns, governance, lineage, and warehouse best practices. Semantic Layer Design (Critical): experience defining and managing a semantic layer for enterprise reporting and AI, including: Business definitions/metric logic, conformed dimensions, hierarchies Star schema alignment, calculated measures, reusable datasets Consistency across Power BI/Tableau and downstream AI/ML consumers Azure (Preferred): Azure SQL Database, Azure Data Factory (ADF), Azure Databricks ETL/ELT & BI Tools: familiarity with orchestration tools and exposure to Power BI and/or Tableau (semantic models/datasets). #J-18808-Ljbffr Sandeep Kanchi