Technical Business Analyst (Hybrid) || Dallas, TX - 3 Days a Week (Need Local Candidate)

DMS Vision • Dallas, TX

11h • Hybrid

About The Position

Seeking a senior Technical Business Analyst with extensive Azure data and data warehouse experience, a data modeler or architect orientation, and recent experience in financial services, banking, or capital markets. The role focuses on defining finance data requirements, designing and maintaining data models and enterprise semantic layers, and ensuring reporting and AI use cases rely on accurate, governed, and reusable data. The position is hybrid in Dallas, Texas, with work onsite three days per week; local candidates are required. The stated duration is six or more months.

The analyst will work with business stakeholders, BI teams, and data engineers to translate requirements into technical specifications for data warehouses and semantic layers. Responsibilities include defining financial KPIs and business rules, validating data and reconciliations, supporting governed semantic models, documenting data definitions and mappings, and recommending improvements to data and reporting practices.

Requirements

• 10 or more years of experience as a Technical Business Analyst or senior Business Analyst.
• Recent experience supporting Azure data or data warehouse projects in a financial services, banking, or capital markets enterprise.
• Strong finance domain knowledge, including financial data structures, KPIs, reporting needs, reconciliation concepts, and data accuracy and compliance expectations.
• Strong dimensional and logical data modeling skills, including data profiling, data quality analysis, and translating business logic into data structures.
• Advanced SQL skills for data extraction, transformation and validation, performance tuning, and analytics and reporting use cases.
• Data warehouse expertise, including data architecture, ingestion and integration patterns, governance, lineage, and warehouse best practices.
• Experience defining and managing an enterprise semantic layer for reporting and AI, including business definitions and metric logic, conformed dimensions, hierarchies, star schema alignment, calculated measures, and reusable datasets.
• Ability to maintain consistency across Power BI or Tableau and downstream AI/ML consumers.
• Familiarity with ETL/ELT orchestration tools and exposure to Power BI and/or Tableau semantic models or datasets.
• Excellent communication and stakeholder management skills, including the ability to translate business needs into technical deliverables.
• High attention to detail, strong prioritization, and ability to work independently in a fast-paced environment.
• Must be a local candidate able to work in Dallas, Texas, onsite three days per week.

Nice To Haves

• Azure SQL Database or SQL Server experience.
• Azure Data Factory (ADF) experience.
• Azure Databricks experience.
• Relevant certifications.

Responsibilities

• Gather reporting and AI requirements; define KPIs, business rules, and data contracts; and translate them into technical specifications for the data warehouse and semantic layer.
• Profile data, identify gaps, perform reconciliations and data quality checks, and ensure financial metrics are correct and auditable.
• Design and maintain logical and dimensional data models that support reporting and AI feature readiness.
• Partner with BI and engineering teams to implement governed semantic models, including definitions, measures, hierarchies, and security assumptions as needed.
• Collaborate with data engineers to align pipelines and ETL with modeling and semantic requirements and support schema optimization and efficient query patterns.
• Maintain requirements, mappings, metric definitions, data dictionaries, and semantic layer specifications.
• Recommend best practices and tools to improve scalability, reuse, and consistency across reporting and AI.

What This Job Offers

• Career Level: Senior
• Education Level: No Education Listed