Job Description :
Bachelor’s degree or equivalent working experience with minimum of 7+ years of IT experience.
Required Skills:
Responsible for database logical and physical design and performance tuning on queries, optimize execution efficiency in MS SQL Server Environment.
Develop Power BI reports, dashboards, implement complex hierarchical row level security, publish reports to power bi service and establish gate way refresh schedules.
Implement Calculations, Perspectives, hierarchy structures, score cards and Key Performance Indicators KPI with outstanding visualizations using DAX, T-SQL. Work on Microsoft BI analytics stack (SSIS, SSAS) and work on investigating new tools, tool capabilities and engage with Business to propose, manage, implement solutions.
Develop SSAS tabular models utilizing complex DAX functions and SQL queries, stored procedures using T-SQL, CTE, XMLA, PowerShell scripts.
Architecting/Developing BI reporting from multiple database platforms SQL Server, Cloudera, SAP HANA, perform data mapping, data integration and understand business rule complexities.
Demonstrate excellent communication skills including the ability to effectively communicate with internal and external customer
Ability to use strong industry knowledge to relate to customer needs and dissolve customer concerns and high level of focus and attention to detail.
Strong work ethic with good time management with ability to work with diverse teams and lead meetings