Lead Business Intelligence Consultant

• Lead cross-functional complex initiatives with broad impact and act as key participant in large-scale planning for the Business Intelligence functional area that enable clear and consistent delivery of insights
• Review and analyze complex, multi-faceted, longer-term business and technical challenges that require in-depth evaluation of data aggregation and visualization methodology to drive user-centric diagnostic analytics and dashboards
• Make decisions in complex situations requiring solid understanding of data structures, domain-specific knowledge and the end user experience that impact the final data visualization product, which includes dashboards, reports, insights, or analyses
• Influence and lead a broader work team to deliver data and visual outputs and new initiatives to inform strategy and decision making by the company
• Strategically collaborate and consult with peers, colleagues, and mid-level to senior managers to resolve issues and achieve goals related to assessing business needs and producing actionable insights and trends, leveraging data visualization and business intelligence
• Lead projects, teams and serve as a peer mentor
• Work to drive adoption of insights and metrics as a resource for the company to enable a data-driven decision-making approach
• You would be required to work individually, or as part of a team or lead projects and work closely with business partners across the organization.
• Responsible for planning and performing reporting, analyses and projects to solve a variety of business issues for a department or functional area.
• Collaborate with business stakeholders to gather and refine requirements for use cases.
• Develop and deliver end to end high-performing reporting solutions and data analysis.
• Perform exploratory analysis to identify the co-relations existing in the data and generate insights.
• Ability to leverage data visualization tools (Power BI, Tableau) and alternative data manipulation and front-end solutions to deliver data analysis results and insights
• Capable of performing ad-hoc analyses and drill down into data inconsistencies and perform root cause analysis for unusual trends
• Work closely with Business and Technology Partners to generate new BI solutions or modify current work products to optimize capabilities and improve efficiency
• Strong experience in evaluating different types of AI/ML outputs and models (recommender systems, similarity scoring, classification and regression).
• Should be able to break down complex business problems into sub-tasks that can be solved with BI and analytics to enable decision making on a scale.
• Should have good grasp on statistical concepts and empirical methods that drive post-modelling decisions like sorting, ranking, selection etc.
• Be exceptional at communicating and translating model algorithms and their outputs to non-technical users and stakeholders, through visualization and BI tools like Power BI, Tableau.
• Ability to integrate AI-enabled features (e.g. Copilot for Power BI) into end-user consumption interfaces to enable natural language led analysis for business users.
• Fluent in agile ways of working and agile project management practices, should be able to create efficient user stories, and other agile project artifacts.
• Thought leadership in the field, capable of mentoring junior team members.
• Proactively seek opportunities to contribute in areas beyond project deliverables like exploratory data analysis, best practices, reusability and automation.
• Proactively seek opportunities to deliver value above and beyond the prescribed book of work.

• 5+ years of business intelligence and data visualization experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
• Experience in one or a combination of the following: reporting, analytics, or modeling (Tableau, Power BI, SQL, Python)
• or a Master’s degree or higher in a quantitative field such as applied math, statistics, engineering, computer sciences
• SQL, ETL, BI and PowerBI/Tableau programming experience
• Exposure & knowledge of Data Science, AI/ML.
• Proficiency in designing and implementing complex and interactive dashboards with BI tools like Power BI (including complex DAX implementations, embedded Power Apps and Power Automate workflows, Copilot for Power BI), Tableau
• Ability to gather end-user requirements, user stories, data requirements and translating them into technical requirements and solution design.
• Strong capability in using heterogeneous sources for deriving complex KPIs using Tableau, Power BI.
• Understand high-level business objectives and continually align the BI/Reporting roadmap to needs of the business and present findings to leadership and exec level audience.
• Experience on other BI tools like MSTR , BO , SSRS, Qlik, Thoughtspot will add value.
• Strong oral and written communication and consultative skills, storytelling and narrative skills.
• Outstanding problem solving and analytical skills with ability to turn findings into strategic imperatives
• Extensive knowledge and understanding of research, analysis, data aggregations, and reconciliation processes
• Ability to perform trend analysis, forecasting and pattern recognition, exploratory Data analysis and insights
• Experience in data cleansing, validation, and transformation logic using Alteryx and SSMS.
• Advanced exploratory data analysis skills using Python,SQL, excel etc., ability to write, read, and optimize queries for data extraction, transformation, and analysis
• Experience with data environments like Oracle , Teradata, Sql server, HDFS, GCP
• Designing and implementing enterprise data and reporting architectures, proficiency in semantic data modeling for BI and AI/ML solutions
• Data integration and clean up/preparation of data
• Experience with structured data and semi-structured text or Excel files
• Familiarity with Agile processes and Atlassian software (Jira).

Knowledge of functional area such as risk, marketing, operations or supply chain in banking industry would be an added advantage.