Senior Technical Business Analyst Job

Role : Sr. Technical Business Analyst (Financial/Investment Banking) Preferred.
Location: NYC, NY & Dallas, TX
Duration: 12 Months

Apply here - https://tinyurl.com/yrbftura

Primary Skills: Azure, SQL, ETL/ELT

Need H1-B, Citizen, GC & GC-EAD with a Minimum of 12 Years of Experience. This is a 100% onsite role. Need Locals or within a 50-mile radius only.

Candidates must have Financial/Investment Banking Experience and MUST HAVE EXPERTISE IN POWER BI.

Primary Skills (Must-Have):

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.
Core Technical Requirements:

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/SQL Server
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).