Associates Systems LLC
Power BI Archtiect
Associates Systems LLC, Dallas, Texas, United States, 75215
In this role, you will:
Coordinate technical design sessions with the Business Analysts and BI Project ManagerAssess 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 departmentsUtilize your experience designing tabular models by writing complex DAX scripts to support Power BI KPIsReview the visualization use cases and determine whether the use of In-Memory models or Direct Query is neededPerformance tune the tabular model to work with large data sets and/or complicated DAX formulasBuild enterprise reporting capability using Analysis Services on-prem or in AzureDesign the tabular model for consumption by non-technical business users in compliance with existing naming standards and metric calculationsOptimize tabular models so they can be properly rendered in other BI ToolsReplace existing BI solutions (e.g. MDX, Tableau, Cognos, QLIK) with new tabular models using DAXUnderstand and implement complex user authentication and data access security models in Analysis ServicesAnalyze data and identify any data quality issues that can affect the model and reportingSupport and train other team members on tabular model methodology and the use of DAXParticipate in code reviews with Clients
Who you are:3-5+ years of experience in the following areas:
Strong SQL and DAX skillsExpertise designing semantic data models that express the business contextAbility to architect and design a tabular model solutionExperience with Microsoft Power BIExperience with Azure Data Service and products (ex. Data Factory, Data Lake, Data Lake Analytics) is a plusAbility to integrate row-based security into tabular modelsProven capacity of troubleshooting issues across multiple departments and vendorsAbility to adapt in a fast-paced flexible environment
Coordinate technical design sessions with the Business Analysts and BI Project ManagerAssess 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 departmentsUtilize your experience designing tabular models by writing complex DAX scripts to support Power BI KPIsReview the visualization use cases and determine whether the use of In-Memory models or Direct Query is neededPerformance tune the tabular model to work with large data sets and/or complicated DAX formulasBuild enterprise reporting capability using Analysis Services on-prem or in AzureDesign the tabular model for consumption by non-technical business users in compliance with existing naming standards and metric calculationsOptimize tabular models so they can be properly rendered in other BI ToolsReplace existing BI solutions (e.g. MDX, Tableau, Cognos, QLIK) with new tabular models using DAXUnderstand and implement complex user authentication and data access security models in Analysis ServicesAnalyze data and identify any data quality issues that can affect the model and reportingSupport and train other team members on tabular model methodology and the use of DAXParticipate in code reviews with Clients
Who you are:3-5+ years of experience in the following areas:
Strong SQL and DAX skillsExpertise designing semantic data models that express the business contextAbility to architect and design a tabular model solutionExperience with Microsoft Power BIExperience with Azure Data Service and products (ex. Data Factory, Data Lake, Data Lake Analytics) is a plusAbility to integrate row-based security into tabular modelsProven capacity of troubleshooting issues across multiple departments and vendorsAbility to adapt in a fast-paced flexible environment