Senior Business Analyst

Job Description

Johnson & Johnson Johnson & Johnson Janssen is recruiting for Senior Business Analyst to be located in Egypt or Lebanon or Turkey. Caring for the world, one person at a time has inspired and united the people of Johnson & Johnson for over 125 years. We embrace research and science -- bringing innovative ideas, products and services to advance the health and well-being of people. Employees of the Johnson & Johnson Family of Companies work with partners in health care to touch the lives of over a billion people every day, throughout the world. Thriving on a diverse company culture, celebrating the uniqueness of our employees and committed to inclusion. Proud to be an equal opportunity employer. And our culture is interconnected by the shared values of Our Credo. Its a culture that celebrates diversity and diverse perspectives. It helps employees achieve an effective mix between work and home life and supports their efforts to have a positive impact on their communities. Summary of the job: The Senior Business Analyst will be responsible for developing a Management Information System (MIS) as a computerized database of financial information organized and programmed in such a way that it produces regular reports on operations for every level of management in a company. Coordinating and managing the analysis and development of recommendations used in strategic account management, Finance and Business to objectively assess performance and benchmark against core business performance. At this level, direct contribution, and responsibility for managing and analyzing complex multidisciplinary data. Collaborating with internal functions to drive execution of the Commercial Vision and establish tools to facilitate data collection and analysis which is a critical priority for Janssen-GCC of ensuring effective best-in-class partnerships that, accelerate growth and strengthen the compliance environment in the region: Focus on implementation of automated regional solution for collection of KPI and sales / order related data from our partners and internal stakeholders on a monthly basis- including but not limited to the development of tools and facilitation of collaboration between partners and internal/external stakeholders. Focus on carrying out analysis and developing recommendations based on the collected data. Gather data to create statistical models that help organizations to improve and enhancement of business processes. Study and analyze various business data and Information, including market trends, sales figures, and inventory control processes. Collaborate cross functional to implement financial planning and marketing plans. Create financial forecasts and sales projections based on currently available business data Duties & Responsibilities: Business performance Management: Monthly distributors data consolidation, to generate a monthly dashboard reflect company performance (On national level and by Rep) capture all Advance Deliveries. capture all Expiries Return. SBI calculation Monthly consolidation of Rolling Forecast, shared with commercial operation and SC Qrtly tracking of FCast accuracy Qrtly incentive calculation for commercial team Update SOP. Consolidate all cases that needs further approvals to take actions. Working closely with pricing team to align on price assumptions in different planning cycles vs Actuals Provide a consolidated volume/price assumptions in different planning cycles (BP, LRFP etc..), with full alignment between CVTLs/Commercial Work with Finance team to align on any top/down adjustment in plans, making sure NTS connected with IMS IMS dashboard management Field Force Target setting and phasing. Monthly performance updates Forecasting and Sales and Operation (S&OP) Management: Maintain and understand the sales data at different aggregation levels (Brands, Sub-brands, SKUs, variants, sizes, Distribution channels). Gather information and document assumptions based on historical data, business intelligence gathered from sales, marketing, finance, and other sources. Produce unconstrained base demand plan utilizing statistical modelling in collaboration with (Supply Chain) SC team. Measure and track the forecast accuracy at different levels and initiate action plans to continuously improve forecast accuracy. Ensure data integrity and accuracy. Use needed format for SC with right coding. Create new report to show the variance between all RF submission. Create Analysis for RF Accuracy vs Act Sales & Financial plan. Financial Submission: LRFP, JU and NU/BP submit all data input required. Working with pricing Dep. to capture all price for all SKUs to get Fixed and variable Price Submit the data to SC to calculate ex-source planning. Working with SC / Finance for closing the gab ex-source planning. Initiating TGT setting exercise with all relevant data in correlation between patients and numbers by following up with LMs/TALs and CVTLs. Incentive management and commercial advancement projects Calculate Incentive for all GCC commercial (Reps, Supervisors, Sales Manager & Country Mangers) Review the yearly incentive criteria with all partners while getting required approvals for the yearly SOP. Forecasting Management: Maintain and understand the sales data at different aggregation levels (Brands, Sub-brands, SKUs, variants, sizes, Distribution channels) and Sales by Indication (SBI) Gather information and document assumptions based on historical data, business intelligence gathered from sales, marketing, finance, and other sources. Produce unconstrained base demand plan utilizing statistical modelling in collaboration with (Supply Chain) SC team. Measure and track the forecast accuracy at different levels and initiate action plans to continuously improve forecast accuracy. Qualifications Experience Required Experience: Minimum 3 years of experience. Education: (minimum required for competent performance in this position) University/Bachelors Degree or Equivalent Language: English is a must Location: Egypt or Lebanon or Turkey Relocation availability: NA Leadership Behaviors Required LIVE OUR CREDO: Puts the needs of Our Credo stakeholders first, pursues the highest standards of quality, safety, compliance & ethics and Ensures everyday actions contribute to Our Purpose CONNECT: Builds internal and external relationships based on respect, Collaborates openly across boundaries and acts as a team player. SHAPE: Inspires and contributes ideas that challenge thinking, demonstrates resilience and agility to drive and adapt to change. Grow: Develops self and others to reach their goals, engages in open & honest conversations and Drives performance by managing energy and taking ownership for outcomes. For more than 130 years, diversity, equity & inclusion (DEI) have been part of our cultural fabric at Johnson & Johnson and woven into how we do business every day. Our commitment to respect the dignity and diversity of all is embedded in our Credo. We know that the success of our business depends on having the best talent in a workforce that reflects the diverse markets we serve around the world and an inclusive culture that values different perspectives and life experiences That is why we in Johnson & Johnson are working to create an inclusive environment where diverse backgrounds, perspectives and experiences are valued and each and every one of our people feels that they belong and can reach their potential. No matter who they are. Diversity, Equity & Inclusion at Johnson & Johnson means You Belong! Primary Location Egypt--- Other Locations Europe/Middle East/Africa-Turkey, Europe/Middle East/Africa-Lebanon Organization Johnson & Johnson Middle East FZ-LLC (8608) Job Function Marketing Requisition ID 2206054778W

Keyskills :