"IT Services and Operations (ITSO) provides an extensive global portfolio of IT services to Shell. The ITSO challenge is to deliver services required by the business and yet remain within affordability ceilings. Business demand for IT services is constant and business activity and strategic growth place a constant pressure on IT spend. Consequently, ITSO needs to provide secure and reliable operations and services while also delivering cost reduction opportunities and containing business requested demand growth.The Business Analyst DBA/Reporting will be part of the Enterprise Reporting team which resides in ITSO Strategy and Planning. The Business Analyst will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server databases, to ensure the availability and consistent performance of our reporting environment. In addition to supporting the reporting environment, the supported databases also feed several corporate systems. Successful performance of this role will require a working knowledge of the Shell data architecture model. This will ensure that the data in the ITSO database is correct, being retrieved from the recognized â€œsingle source of truthâ€, and not duplicating other data sources. This is a â€œhands-onâ€ position requiring solid technical skills, as well as excellent interpersonal and communication skills.The successful candidate will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of the Shell IT Planning community. Must be capable of working independently and collaboratively. Accountabilities Receive data feeds from numerous systems and sources. Perform quality assurance on data feeds and pursue corrections / validation when necessary. Process data into SQL server format and load into databases. Maintain resultant databases to ensure they remain operational. Provide output and maintain links for other systems that rely on periodic feeds of this data. Maintain contact with a network of focal points in each business that provide monthly business hierarchy updates. Generate various reports in Spotfire, Excel and PowerPoint formats. Manage database instances currently hosted in Amazon Web Services Cloud environment. Manage access permissions to data ensuring compliance with IRM (data security) requirements. Assist Reporting Lead or analysts in special projects as and when needed. Review current standards and methodologies, and offer suggestions on ways to improve. Examine and evaluate purpose and content of reports to develop new or optimize existing reports. Proactively work with key stakeholders and/or suppliers to ensure requirements for reporting are identified, implemented and embedded in a standard way. Dimensions and Special Challenges No direct reports. Taking ownership of responsibility without waiting for direction. Working in a global, virtual environment with key stakeholders and culturally diverse team members requires a great deal of flexibility and understanding. Managing multiple delivery priorities and multiple demand requests. Collaboration with multiple stakeholders in various organizations. Delivering through others with no direct authority. Requirements Mandatory Qualifications and Skills 8-12 years of total experience. Experience working with Windows server, including Active Directory. SQL server. SSIS Integration Services. Good data management using Excel. Knowledgeable in basic Formulas, Macros, Charts, Pivot, Vlookup, Data Validation, Conditional Formatting etc. Proficient use of PowerPoint. Willingness and proven ability to master new data and analytics tools quickly and efficiently (e.g., Spotfire). Strong stakeholder and interpersonal relationship skills. A self-starter with good analysis and problem solving skills. Able to work collaboratively and effectively across the organization and across different geographies. Attention to detail a must, with focus on quality and accuracy. Able to handle multiple tasks with appropriate priority and strong time management skills. Fluent in English, written and verbal. Flexible about work content and enthusiastic to learn. Preferred Qualifications and Skills Graduate with at least a Bachelorâ€™s degree in IT. Prior experience in consolidating and presenting performance metrics. Experience with Spotfire a plus."