Business Intelligence Architect

Inviting applications for the role of Sr. Principal Consultant – Data Visualization (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 visualization tools. Balancing large volume of Data by using SQL. Having earlier hands-on experience of creating reports for CXOs. 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 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: 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 Note: “Los Angeles, California based candidates are not eligible for this role. Atlanta, GA area candidates are eligible for this role only.”