Job Seekers, Please send resumes to resumes@hireitpeople.com

Must Have Skills (Top 3 technical skills only)*:

5years of progressive experience in data warehouse architecture design, logical and physical data modeling, prototyping, data security & ETL process modeling in Microsoft BI stack Solid understanding of relational database theory, principles and best practices. Experience in Microsoft SSAS tabular model with proficiency in writing complex DAX scripts to support PowerBI KPIs.

Nice to have skills (Top 2 only):

Understand and Implement complex user authentication and data access authorization security models in Analysis services tabular model. Experience in ETL design, implementation using MS SSIS.

Detailed Job Description:

Job Description for SSAS tabular model position. For quick reference 5+ years of progressive experience in data warehouse architecture design, logical and physical data modeling, prototyping, data security & ETL process modeling in Microsoft BI stack. (MS SQL server, SSAS, Power BI) Solid understanding of relational database theory, principles and best practices. Experience in Microsoft SSAS tabular model with proficiency in writing complex DAX scripts to support PowerBI KPIs. Understand and Implement complex user authentication and data access authorization security models in Analysis services tabular model. Experience in ETL design, implementation using MS SSIS. Highly proficient in T - SQL script development using stored procedures, views, user defined functions etc. Strong ability to analyze data and identify data quality issues. Intermediate to advanced understanding of the DAX (Data Analysis expressions) language Experience with Azure Data Service and Products (ex. Data Factory, Data Lake, Data Lake Analytics) a plus. Experience with Microsoft Power BI or other Visualization tools a plus. · Experience creating cloud-based solution using Azure is PLUS

Minimum years of experience*: 5+

Certifications Needed: Yes

Responsibilities you would expect the Subcon to shoulder and execute*:

Work with client independently during design phases Work with offshore on daily basis

Interview Process (Is face to face required?) Yes

Does this position require Visa independent candidates only? Yes