- Position- Technical Business Analyst with Strong Financial Exp, Local
- Location- Dallas, TX (Highland Park)
- Type- Hybrid (3 days/week office)
- Visa- USC, GC
- 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).
- Key Responsibilities
- Requirements & Metric Definition: Gather/reporting & AI requirements; define KPIs, business rules, and data contracts; translate into technical specs for warehouse + semantic layer.
- Data Analysis & Validation: Profile data, identify gaps, perform reconciliation and data quality checks; ensure finance metrics are correct and auditable.
- Data Modeling: Design/maintain logical and dimensional models to support reporting and AI feature readiness.
- Semantic Layer Delivery: Partner with BI/engineering to implement governed semantic models (definitions, measures, hierarchies, security assumptions as needed).
- Collaboration with Data Engineers: Ensure pipelines/ETL align with modeling and semantic requirements; support schema optimization and efficient query patterns.
- Documentation: Maintain requirements, mappings, metric definitions, data dictionaries, and semantic layer specifications.
- Continuous Improvement: Recommend best practices/tools to improve scalability, reuse, and consistency across reporting and AI.
- Thanks & Regards
- Shivam Rajpal
- Team Lead- US IT Recruitment
- Desk- 201-578-5388 X 106
- Email- [email protected]
- LinkedIn- https://www.linkedin.com/in/shivam-rajpal-b7a58912a/
- Voto Consulting LLC- M/WBE Certified Company
- www.votoconsulting.com
Mention you found this on Data First Jobs — it helps us bring you more roles like this.
Business Analyst
Voto Consulting LLC
Similar Analytics Jobs
View all Analytics jobs→K&K Global Talent Solutions INC.
Operations Control Test Analyst
New
Toronto, Ontario (Canada)
Fortray Global Service Limited
Junior Business Analyst
New
New York, New York (USA)
Empire Life
Senior Financial Analyst
New
Canada
Seminole Electric Cooperative, Inc.
RESOURCE PLANNING ANALYST
New
Tampa, Florida (USA)
Belcan
Business Analyst Intern
New
Grand Prairie, Texas (USA)$25,000 - $25,000
Blue Cross Blue Shield of Arizona
Financial Technical Analyst III - Hybrid
New
Phoenix, Arizona (USA)
Like this role? Get carefully selected jobs like it, twice a week, straight to your inbox.
Free, no spam. Unsubscribe anytime.