Lead Consultant - Data Visualization Lead

In this role, as a trusted advisor to the business, establish partnerships, assess business needs, provide critical interpretation of data, form hypotheses and synthesize conclusions into recommendations, turning data analysis into insights

Responsibilities:

Responsible for managing complete project lifecycle- Initiation, Planning, Execution, Monitoring and Closure phases of the projects.
Develop complete project plans with budgetary information.
Design architecture for sizing/scalability and performance.
Crafting Dashboards by using Tableau & Power BI visualization tools.
Balancing large volume of Data by using SQL.
Crafting Interactive Dashboards by using Actions, Quick filters and Parameters.
Involving in admin activities like publishing, adding users, creation of subscriptions and deployment.
Building different Visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles Charts etc.
Extracting the data from multiple data sources using Data Blending.
Tableau performance, data extracts and usage data.
Understand Architecture Requirements and ensure effective Design, Development, Validation and Support activities.
Communicating with customers to analyze historical data and identify critical metrics
Improving data processing speed by building SQL automations
Analyzing the data to identify trends and share insights
Subject matter expert on the Microsoft technology stack - Microsoft Power BI, advanced analytics, and information management technology
Data Transformations and Modelling using Power BI Query Editor.
Create relationships between data and develop tabular and other multidimensional data models.
Advanced calculations (Aggregate, Date, Logical, String, Table etc.) i.e. well-versed in DAX scripts
Deploying best practices in visualization based on industry knowledge
Strong knowledge of technical aspects of visualization, analytics and BI applications including data modelling, data preparation/ profiling, data integration.
Experience in Data Gateway for data refresh.
Experienced in implementing row level security on data and understanding application security layer models in Power BI.
SQL querying for best results, use of filters and graphs for better understanding of data.
Troubleshooting of Power BI reporting solutions including investigation of data issues, data validation and balancing.
Data documentation explaining algorithms, parameters, models, and relations.
Ability to design Mockup/Storyboard using UI/UX concepts
Working knowledge of databases like SnowFlake, SQL Server, SQL Azure, Oracle etc
Recognizing areas for automation
Restricting data for particular users with the help of User filters
Producing support documentation and keep existing documentation up-to-date
Carrying out investigation of root cause analysis
Making sure the team delivers reports as per the requirements
Interacting with customers to analyze previous data and resolve critical metrics.
Supporting documentation and keeping existing documentation up-to- date.

Qualifications we seek in you
Minimum qualifications:

Bachelors / Graduation / Equivalent: BE/B- Tech, MCA, MBA
Excellent Communication skill and effectively interact with business user
Ability to interact with business as well as technical teams
Ability to learn and respond quickly to the fast-changing business environment
Project Management using Agile/waterfall methodologies (O).
Ability to multitask and excellent interpersonal skills
Analytical mindset with a problem-solving approach

Preferred qualifications:
Very good written and presentation / verbal communication skills with experience of customer interfacing role.
In-depth requirement understanding skills with good analytical and problem-solving ability, interpersonal efficiency, and positive attitude.
Good knowledge of writing complex SQL
Ability to work in an agile environment with a focus on continuous improvement
Self-motivated and eager to learn
A team player and able to lead and initiate