SSAS Tabular / DAX Developer

Overview

Remote
$75 - $100
Contract - Independent
Contract - W2
Contract - 2 Month(s)
No Travel Required

Skills

SSAS
Tabular
DAX
Salesforce
Excel
Power BI
Dynamics
VertiPaq

Job Details

About the Engagement

We are building a new SQL Server Analysis Services (SSAS) Tabular model sourced from Salesforce. Scope includes establishing Salesforce connectivity, trimming measures from a legacy Dynamics-based model, creating a lean Tabular model with DAX measures, validating via dual-model Excel/Power BI comparisons, tuning VertiPaq performance and security, and preparing users for cutover and training.

What You ll Do

Connectivity & Data Shaping

  • Set up and validate Salesforce connectivity (e.g., ADF/SSIS/OData/ODBC) feeding a clean semantic layer for Tabular.
  • Define tables, relationships, and star-schema friendly structures for analytic performance.

Tabular Model Build

  • Create/organize DAX measures, calculation items (if applicable), KPIs, hierarchies, and friendly metadata.
  • Trim/simplify legacy metrics from the Dynamics-based model to a minimal, business-aligned set.

Validation & UAT

  • Run side-by-side validation (Excel Pivot/Power BI) between old and new to confirm numeric parity and edge cases.

Performance & Governance

  • Optimize VertiPaq (cardinality reductions, encoding decisions), define partitions and processing strategy.
  • Implement RLS/roles in Tabular; document security model and data-access assumptions.

Cutover & Enablement

  • Support cutover communications; deliver user training materials and short admin runbooks (process/reprocess, role updates).

Must-Have Qualifications

  • SSAS Tabular expertise with a strong DAX background (measures, calc groups, KPIs, relationship modeling).
  • Demonstrated success refactoring/streamlining existing semantic models (measure trimming, naming standards, foldering).
  • Data integration experience pulling from Salesforce via ADF/SSIS/OData/ODBC; strong SQL for staging/modeling.
  • Proficiency validating models via Excel (Pivot) and/or Power BI; capable of coaching analysts through UAT.
  • Implemented RLS and role-based access patterns in Tabular; understands operational handoff (processing, deployment).

Nice to Have

  • Familiarity with Dynamics 365 data domains (to inform measure trimming/mapping).
  • Hands-on with Tabular Editor (2/3), DAX Studio, Best Practice Analyzer; CI/CD for Tabular deployments.
  • Performance tuning in Tabular (VertiPaq sizing, partitions, processing strategies; experience with DAX Studio/VertiPaq Analyzer).
  • Experience enabling downstream tools (Power BI, Excel, Tableau) against Tabular.
  • Prior delivery of cutover comms, quick-reference runbooks, and short training sessions.

Why This Role Matters

Our client needs a lean, fast, Salesforce-aligned Tabular model with clear, business-ready DAX measures, strong performance and security, and a smooth cutover so teams can slice/dice quickly and trust the numbers.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Improving Corporate Services