Business Intelligence Analyst

Key Responsibilities

• Participates in the design, development and maintenance of ongoing metrics, reports, analyses, dashboards, etc. used to drive key business decisions.
• Design, develop and maintain business data pipeline in Applied cloud environment (Azure) to ensure streamlined query scripting and performance
• Create and maintain code documentation. Establish and conform to coding BKMs. Optimize query performance by employing industry best practices.
• Perform regular database maintenance including auditing duplicating, removing outdated data and clean up data warehouse owned by the group
• Works within controls to ensure the accuracy, timeliness and confidentiality of all managerial and business intelligence reports, views, dashboards, and user data. Implements new business reports within the established reporting framework, policies and procedures. Trains and supports end users on accessing of reports.
• Works with others in the development of data warehouses and other data sources to support managerial and business intelligence reporting needs.
• Works with business intelligence manager and other staff to assess various reporting needs. Analyzes reporting needs and requirements, assesses current reporting in the context of strategic goals and devise plans for delivering the most appropriate reporting solutions to users.
• Educates & trains user community on the potential uses of the business intelligence system
• Extracts financial, statistical and other data from various information systems and other sources.
• Designs and develops recurring and ad-hoc business intelligence solutions such as reports, cubes, and dashboards, using industry best practices for presentation, efficiency, and user friendliness. Designs reports to aid in the efficient assimilation of the data by users by engaging exception reporting,

• Demonstrates conceptual and practical expertise in own discipline and basic knowledge of related disciplines
• Demonstrate strong knowledge and experience on database management and SQL querying

• Possess solid knowledge of best practices and how own area integrates with others; is aware of the competition and the factors that differentiate them in the market; able to interpret industrial best practices and implemented in work environment of functional group

• Acts as a resource for colleagues with less experience; may lead small projects with manageable risks and resource requirements

• Solves complex problems; takes a new perspective on existing solutions; exercises judgment based on the analysis of multiple sources of information

• Impacts a range of customer, operational, project or service activities within own team and other related teams; works within broad guidelines and policies

• Explains difficult or sensitive information; works to build consensus