Your Role:As Technical Business Analyst, you shall be responsible for accurate and timely data support information for Controllers in MBS and to our Controlling Organization. In your role, you will be working on financial information thus a high quality and deep analysis is required, you are also expected to collaborate with finance and technical professional globally to understand, gather and document business requirements. On a regular basis, you will be involved on monthly reporting activities such as data upload and refresh in TM1, quality data reconciliation review and Management Dashboard release to tableau users including Monthly Sales and P&L Report. Per business requirement, you will also be responsible to manage data hierarchy changes, user authorization management and development of new reporting package including UAT activities. Main stakeholder is based in Germany, but you may be required to shift schedule as required.Who You Are:• At least a bachelor’s degree in IT, Finance/Accountancy, Business Administration/Management, Mathematics, Statistics, Engineering or other related fields.6+ years’ experience in Business Intelligence role handling financial and business KPI reporting and analytics support in a Shared Services Center setting, preferably in a pharmaceutical industryProven analytical and problem-solving skills, self-driven and highly independent.Fluent English language skills required.Travel availability.
Technical Expertise:• Experience in various Business Intelligence Reporting and Analytics tools such as IBM Cognos, OLAP, Tableau, QlikSense/QlikView, FusionOps, Power BI, SAP BW/BI, etc. for Financial Reporting/Forecasting and Analysis4+ years IBM Cognos TM1 and/or Planning Analytics experience, working with TM1 cubes, dimensions, rules, MDX expressions/turbo integrator processes4+ years experience in building, customizing and publishing complex Tableau interactive reports, visualizations, dashboards and stories. Tableau certifications are a plusStrong SQL programming skillsAdvanced skills in Microsoft Office suite of tools, with expertise in ExcelKnowledge and experience in SAP Applications such as BW/BI, HANA, Fiori, LumiraExperience in end to end implementation of Business Intelligence projectsAbility to assess business user needs, creatively approach solutions, identify applications/tools to be used and influence appropriate courses of actionProven ability to translate non-technical business requirements into technical specifications both in written and verbal form
Quantitative Skills:• The ability to analyze, model and interpret data to form meaningful and understandable summariesGood at using numbers and mathematical operations to understand issues, suggest solutions and make decisionsJob Requisition ID: 197509
Location: National Capital - all
Career Level: D - Professional (4-9 years)
Working time model: full-time
US DisclosureThe Company is an Equal Employment Opportunity employer. No employee or applicant for employment will be discriminated against on the basis of race, color, religion, age, sex, sexual orientation, national origin, ancestry, disability, military or veteran status, genetic information, gender identity, transgender status, marital status, or any other classification protected by applicable federal, state, or local law. This policy of Equal Employment Opportunity applies to all policies and programs relating to recruitment and hiring, promotion, compensation, benefits, discipline, termination, and all other terms and conditions of employment. Any applicant or employee who believes they have been discriminated against by the Company or anyone acting on behalf of the Company must report any concerns to their Human Resources Business Partner, Legal, or Compliance immediately. The Company will not retaliate against any individual because they made a good faith report of discrimination.North America DisclosureThe Company is committed to accessibility in its workplaces, including during the job application process. Applicants who may require accommodation during the application process should speak with our HR Services team at 855 444 5678 from 8:00am to 5:30pm ET Monday through Friday.