Job Description
6 to 8 years of work experience (3-5 years will also work if technically very strong)
Must have experience in MSBI Architecture
Must have experience in data analysis and business requirements gathering (experience in writing business-driven user stories will be an advantage)
Experience in SSAS, SQL and PowerBI (1-2 years in each of the skills) Preferably more experience in SQL, Stored Procs, Performance tuning, Query optimization, PowerBI reporting
· Worked on complex SSIS and DTS packages for ETL
· Used T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, query writing and SQL joins
· Performance Tuning, Handling Indexes, and Query Optimization
· Knowledge in SSAS tabular model with partitions; created measures using DAX functions, MDX.
· Developed Power BI dashboards using Power BI desktop and publishing it in the Power BI Analytics server
· Knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
Qualifications
SQL, SSAS, SSIS, PowerBI
Additional Information
All your information will be kept confidential according to EEO guidelines.