Azure Data modeler - Pittsburgh, PA - Georgia IT Inc.
Pittsburgh, PA
About the Job
Position : Azure Data modeler
Location : Pittsburgh, PA
Type : C2H
Rate : DOE
Start date : Immediately
USC, Green card, GC EAD and TN visa accepted
Job Description
Azure Analysis Service Role and Responsibilities
Location : Pittsburgh, PA
Type : C2H
Rate : DOE
Start date : Immediately
USC, Green card, GC EAD and TN visa accepted
Job Description
Azure Analysis Service Role and Responsibilities
- Develop, optimize, and administer Tabular Models in 'Azure Analysis service'
- Develop cubes and develop complex calculations, Aggregations, implementing a dynamic security model using DAX functions in - Azure Analysis service
- Extensively used performance monitor/SQL profiler/DMVs to solve deadlocks, to monitor long-running queries and trouble-shoot cubes SQL and T-SQL.
- Experience in AAS Data Model Development, AAS Data model Deployment, Querying and Transforming data in AAS to build Reports.
- Design and Create AAS/Tabular cubes and automate processes for analytical needs.
- Writing optimized SQL queries for integration with other applications, maintain data quality and overseeing Tabular model security and Partitions
- Designing database tables and structures, creating views functions and stored procedures.
- Develop Power BI reports and perform data analysis.
- Experience in writing Teradata query and navigating in Teradata database.
Source : Georgia IT Inc.
