Principal Consultant – Data Architect

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.
Mentor junior resources on building Data Governance frameworks on Cloud and other platforms
Provide progress reports to Competency Council and drive framework/assets/business use case builds for Data Governance
Coordinate with other competencies to eliminate redundancy and streamline framework builds
Identify new business opportunities in Data Governance and partner with Vertical Leads to resource and deliver the projects
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 so as to identify trends and share insights
Added advantage of having knowledge on OAS & MicroStrategy.
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.

Minimum Qualifications

Bachelor's/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