Hello,
This is Deep, Senior Technical Recruiter at Zeal Hire. After reviewing your background, I believe your experience aligns exceptionally well with a position we are currently seeking to fill.
Job Description
Title: Sr. Business Analyst
Visas: USC/GC only
Need LinkedIn, VISA DL
Local DL is mandatory
Years of Exp: 15+ years of experience
Required Candidate Location: Dallas, TX, 3 Days a Week – NO RELOCATION
NEW REQUIREMENT: Requirement Notes (Candidate Job description below) : We need a Technical Business Analyst (15+ years) who has extensive Azure Data and Data Warehouse experience who is more of a data modeler/architect with expertise in financial services. ***** CANDIDATES MUST BE SENIOR BUSINESS ANALYSTS WITH EXCELLENT COMMUNICATION SKILLS AND RECENT EXPERIENCE SUPPORTING AZURE DATA/DATA WAREHOUSE PROJECTS IN A FINANCIAL SERVICES, BANKING OR CAPITAL MARKETS ENTERPRISE. **** CANDIDATES MUST HAVE RECENT FINANCIAL EXPERIENCE AND THE CLIENT WOULD LIKE TO SEE CERTIFICATIONS AS WELL. – NO RELOCATION & CANDIDATES MUST BE WITHIN ONE HOUR COMMUTE TO THE DALLAS/FT WORTH METROPLEX.
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.
- Azure (Preferred):
- Azure SQL Database/SQL Server
- Azure Data Factory (ADF)
- Azure Databricks
****CANDIDATES MUST HAVE GOOD TENURE AND/OR LONG PROJECTS. CANDIDATES WITH RECENT LOCAL PROJECTS HIGHLY PREFERRED. – NO RELOCATION
*** Experience required on a resume and for submittal:
1. How many years working with: Business Analyst
2. How many years working with: Azure Data
3. How many years working with: Azure Data Warehouse
4. How many years working with: Banking or Capital Markets
5. How many years working with: ETL Tools
Job Description:
Technical Business Analyst – Looking for more of a data modeler/architect with expertise in financial services.
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.
Soft Skills
- Strong stakeholder management; able to translate business needs into technical deliverables.
- High attention to detail, strong prioritization, and ability to work independently in a fast-paced environment.
*** Please provide all the below information in the required format for Client submittal along with State ID or Driver’s License. All the requested details must be supplied for client submittal.
- Full Name:
- Candidates Rate:
- Candidates current (Now) Location:
- Availability to Interview: One Day’s notice
- Availability to Start:
- Email Address:
- Phone Number:
- Visa Status:
- Education – College/Year of graduation:
- Link to LinkedIn?
- Certifications (Please list)?
Kind Regards,
Deep Patel
Sr. Technical Recruiter
ZealHire Inc.
14 Wall Street 20th Floor | New York, NY 10005
