Data Architect - Tableau/Power BI (6-12 yrs)

Job Description :

Inviting applications for the role of Principal Consultant - Reporting + Data Architect (Tableau, Power BI)

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.

- 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 :

- 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