• Ort: Cleveland, Ohio
  • Gehalt: $100000 - $140000 per annum + 401K, PTO, Medical, Dental, Vision etc
  • Technologie: Microsoft BI Jobs
  • Vertragsart: Permanent
  • Veröffentlicht am: 19th Sep, 2019
  • Reference: 09192019BT

Tabular Model Developer/Architect


Location: REMOTE, Ideally located in Cleveland, OH or Mid-West


Travel: 25% in the area to meet a new client, fully remote after meeting


Technology: Azure Data, Microsoft BI, Tabular Modeling/SSAS


Our Data & Analytics practice believes that data can drive business value and performance. For us, Data and Analytics is more than just a set of technologies. It's about skilled individuals who can align technical capabilities to bring value to a business. What we value the most: people who are dedicated to delivering high quality solutions. We're looking for a Tabular Model (Analysis Services) Developer to join our growing team!


In this role, you will:



  • Coordinate technical design sessions with the Business Analysts and BI Developer

  • Assess the data needs of an organization and create a flexible enterprise model that produces quick results for large groups of reports and dashboards for various departments

  • Utilize your experience designing tabular models by writing complex DAX scripts to support Power BI KPIs

  • Review the visualization use cases and determine whether the use of In-Memory models or Direct Query is needed

  • Performance tune the tabular model to work with large data sets and/or complicated DAX formulas

  • Build enterprise reporting capability using Analysis Services on-prem or in Azure

  • Design the tabular model for consumption by non-technical business users in compliance with existing naming standards and metric calculations

  • Optimize tabular models so they can be properly rendered in other BI Tools

  • Replace existing BI solutions (e.g. MDX, Tableau, Cognos, QLIK) with new tabular models using DAX

  • Create tabular models based on Data Warehouses and Data Lakes

  • Understand and implement complex user authentication and data access security models in Analysis Services

  • Analyze data and identify any data quality issues that can affect the model and reporting

  • Support and train other team members on tabular model methodology and the use of DAX

  • Participate in code reviews with Clients


A successful candidate will have the following characteristics:



  • Strong SQL skills

  • Strong DAX skills

  • Expertise designing semantic data models that express the business context

  • Ability to architect and design a tabular model solution

  • Experience with Microsoft Power BI is a plus

  • Experience with Azure Data Service and products (ex. Data Factory, Data Lake, Data Lake Analytics) is a plus

  • Ability to integrate row-based security into tabular models

  • Proven capacity of troubleshooting issues across multiple departments and vendors

  • Ability to adapt in a fast-paced flexible environment

  • 3-5+ years of experience around the skills mentioned above