Title: Business Analyst/Financial Data/Azure
Location: Hybrid/Dallas, TX
Required Candidate Location: Hybrid/Dallas, TX 3 Days a Week - (local)
Type of Interview Required: Video
- Azure (Preferred):
- Azure SQL Database/SQL Server
- Azure Data Factory (ADF)
- Azure Databricks
1. How many years working with: Business Analyst
2. How many years working with: Financial Data
3. How many years working with: Data Warehouse
4. How many years working with: Financial Services/Large Banks/Capital Markets
5. How many years working with: Azure
Job Description:
Technical Business Analyst
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).
Regards,
Payal Shrivastava
IT Recruiter
TEK Inspirations LLC : 13573 Tabasco Cat Trail, Frisco, TX 75035
Email: