• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 25th Nov 2020

Duties and Responsibilities
 Collect, analyze and develop data mart schema requirements and source‐to‐target mapping, aligned with
approved architectural direction.
 Produce and understand both relational and dimensional data models
 Develop and troubleshoot stored procedures using Microsoft SQL Server and TSQL.
 Develop tabular data models from scratch using Visual Studio
 Develop compelling data visualizations using Power BI
 Work in partnership with business analysts to ensure proper integration of new solutions into existing
environments.
 Work closely with IT to understand infrastructure capacity and environment requirements for new
development.
 Work with database administrators to design logical and physical data models and ensure efficient flow
and storage of information.
 Provide task‐level estimated effort and development schedules to project leads.
 

Minimum/Preferred Qualifications:
 Experienced/Expert at data visualization and advance calculations (Aggregate, Date, Logical, String, Table)
using Azure‐based Power BI all devices)
 Expert knowledge connecting Microsoft Azure‐based Power BI to various data sources
 Expert creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat
Maps, Tree maps, etc.
 In‐depth experience with Microsoft Business Intelligence Suite ﴾Microsoft SSAS, SSIS,SSRS﴿ and Power BI
 Experienced/Expert at developing optimized and well‐formed SQL queries.
 Able to optimize performance where required.
 Knowledge of SQL Server 2012 or advanced versions; SQL Server 2016 is most preferable.
 Knowledge of Azure
 Experience developing in Agile SCRUM teams
 Thrives in an environment of frequently changing requirements.
 

Preferred Qualifications:
 Investment Accounting or Financial Experience
 Advanced skill and experience in DAX.