Business Intelligence Analyst Job Description ABOUT US Smith & Nephew supports healthcare professionals in more than 100 countries in their daily efforts to improve the lives of their patients. We do this by taking a pioneering approach to the design of our advanced medical products and services, by securing wider access to our diverse technologies for more customers globally, and by enabling better outcomes for patients and healthcare systems. We have leadership positions in: * Orthopaedics Reconstruction - joint replacement systems for knees, hips and shoulders * Advanced Wound Management - wound care treatment and prevention products used to treat hard-to-heal wounds * Sports Medicine - minimally invasive surgery of the joint * Trauma & Extremities - products that help repair broken bones We have around 16,000 employees around the world. Annual sales in 2016 were more than $4.6 billion. We are a constituent of the UK's FTSE100 and our shares are traded on the London Stock Exchange and through American Depository Receipts on the New York Stock Exchange (LSE: SN, NYSE: SNN) SUMMARY: Reporting to the Director of Strategic Development, the Business Intelligence Analyst will play a key role by applying extensive knowledge of statistical models and statistics to design, implement and maintain analytic tools used to drive data-driven decision making. This role will also be responsible for developing and maintaining dashboards and reports using Tableau, SQL and other Business Intelligence tools. Internal customer engagement is a requirement and this individual will be expected to develop a solid understanding of the business and where data can be used to provide strategic insights. This role will primarily support the Sports Medicine and ENT (Ear, Nose and Throat) franchises, and will require frequent interaction and communication with people at all levels of the business. Principal Accountabilities (Major end results the job is expected to achieve) * Perform data profiling to identify and understand anomalies and patterns in market research data; Use RFM analysis to create customer segmentation, profiling and prediction; use techniques like multivariate analysis, t-test, ANOVA, correlation and regression to analyze market research data. * Develop process and tools to collect, analyze, visualize data, and present insights to executive management; create user friendly dashboards and analysis to present insights to the executives. Use advanced visualization techniques such as chord diagram, sankey charts and waterfall chart as necessary to convey the insights. * Develop and publish reports on market size, growth and competitor share estimates to internal customers; automate reports and their delivery; use advanced reporting tools like Cognos to create robust reports with dynamic prompts and filters. * Drive standardization of key metrics across various business stakeholders to improve data governance; Develop dashboards to monitor the key performance indicators (KPI); responsible for improving data governance and standardizing data definitions. * Support the global marketing team with segment, channel, market & brand performance analysis and advice on the acquisition and implementation of new sources of market intelligence to drive strategic insights; this involves formulating mathematical models or simulation models for Global marketing team problems. Develop cluster analysis models and various other association and segmentation models such as apriori, logistic regression or decision trees. Use mixed integer programming models to optimize the market spend. * Conduct competitive research, market analysis, and clinical literature analysis, involving performing market analysis by building regression models & pareto charts. * Work with business stakeholders to gather, analyze, and translate requirements in the BI reporting area, either by recommending an existing solution, developing a solution, or synthesizing requirements in support of a new project initiative; use analytical skills to understand business problems and translate them to requirements. Utilize deep understanding of databases and SQL to write queries and develop solutions. * Develop detailed financial models for business development opportunities; Involves in building financial models, stochastic models and pricing models; Use ARIMA, time series or exponential smoothing models and other forecasting models. Build financial models using Linear regression, Logistics regression, Non-Linear Auto Regressive Neural Network (NARNET), Decision Tree & Support Vector machine. * Develop and deliver training on data and analytics tools in order to provide autonomy to key data users; understand health care data and analytical tools such as Tableau, to train the internal users in the use of analytical tools in healthcare. * Collaborate with enterprise IT, sales, operations, training, finance and various other teams for cross-functional data initiatives and analytics. * Provide expert advice in the usage and interpretation of data to various business stakeholders; understand data, analyze trends, interpret results of financial models and present key insights to the stakeholders. * Participate in the selection and management of 3rd party data sources and market research services; work with different data sources such as oracle, excel, text files, etc., and combine them into one source and create database tables. * Participate in and lead knowledge management initiatives for the internal analytics community across multiple franchises and geographies * At all times, operate professionally at all level, and in line with the Company values. * Perform all activities in compliance with relevant Quality Systems Standards. * Perform other related duties, as assigned by manager. Travel Approximately 0-5% Education Bachelors degree in Business, Economics, Information Systems, Computer Science, Engineering, Mathematics or other quantitative field. Masters degree a plus. License/Certifications Certificate in Business Analytics/Business Intelligence a plus. Experience 3-5 years Business Intelligence experience. Financial modeling experience preferred. Medical or healthcare industry experience preferred. Competencies Strong data visualization, reporting, dash-boarding, and presentation skills. Strong analytical and project management skills required, including how to interpret a business need and translate it into creative technical solutions. Capacity to manage multiple projects with shifting priorities. Strong sense of customer service for internal customers. Strong SQL, Excel, Tableau and SAP skills. Familiar with data warehousing concepts. Expert proficiency in Microsoft Office Suite. Must be a self-motivated, energetic, detail oriented team player passionate about producing high-quality BI & analytics deliverables. Excellent communication skills written and verbal. Excellent interpersonal skills. PHYSICAL DEMANDS: The position requires the ability to: * Work in an office with a high degree of PC work and meeting attendance. * Travel as described above. Smith and Nephew is an Equal Opportunity/Affirmative Action Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by applicable law.