1124-CH-243 - Data Analyst III

Data Analyst III 

About Our Team 

As part of our team, you will manage the operational process for your own portfolio of academic journals while collaborating with a large team of Journal Managers. You will be a member of a collaborative and inclusive team that encourages autonomy and personal development while working together to achieve our department's objectives and key results. You will contribute to a supportive team culture by sharing knowledge, ideas, and best practices. 

We operate a hybrid working policy, with office attendance requested in our centrally located Exeter office one day per week. The office is open and available most days for staff who prefer to come in. 

About the Role 

Within Elsevier, our Data Management team is responsible for providing hands-on data management activities, mainly focusing on the Operations data warehouses. We work closely with IT in making Operations data available for Business Intelligence and Data Analytics within Elsevier. 

You will support the product managers in making sure all data management-related aspects are delivered in a timely manner. You will enable collaboration between our business stakeholders and IT team and be that bridge between the business and technical developers. 

This role ensures data governance aspects are adhered to, assuring the availability, usability, integrity, and security of the data within the operations data warehouses. 

Responsibilities 

Snowflake Data Warehouse Development: 

• Collect business/functional requirements from the business 

• Design solutions in collaboration with the product manager, stakeholders, and IT 

• Responsible for the development lifecycle of agreed development stories through all stages of development through to production delivery 

• Responsible for investigating and qualifying change requests/requirements, pushing back on those which do not fit with the systems' functional strategy 

Tableau Data Source Management: 

• Provide standardized data source(s), fully supported by IT, that all users can access 

• Update Tableau data sources if any changes are applied in the underlying data sources 

• Ensure Tableau server standards have been met before the data source is published to the Tableau server and eventually promoted to production (TRUSTED – Timely, Reliable, Unvarying, Safe and Secure, Traceable (back to source), Easy to use, Defined Limitations) 

Stakeholder Management: 

• Participate in stakeholder meetings 

• Operate in an agile development environment collaborating with key stakeholders 

• Monitor data warehouse performance/outages and notify stakeholders accordingly 

Support: 

• First line support for the business, responsible for investigating/fixing issues/queries 

• Create and modify ad-hoc queries (SQL) related to Snowflake warehouses 

• Ensure the data sources are always functional and available to all stakeholders 

• Support business and/or IT with data subject matter expertise 

Documentation: 

• Develop and maintain support materials including support hub, process documentation, FAQs, guided answers, and data dictionaries in Business Data Catalog (BDC) 

• Define and enforce standard naming conventions 

Data Visualization: 

• Provide ad-hoc dashboard services as deemed appropriate to support data warehouse-related activity/performance 

Requirements 

• Strong proficiency with SQL 

• Proficiency with databases (Snowflake preferred) 

• Good understanding of ETL processes 

• Proficiency with data analysis tools and processing 

• Demonstrated ability and desire to learn new processes, tools, and technologies 

• Agile development knowledge – including the use of Jira, continuous integration 

• Strong problem-solving experience 

• Attention to detail 

• Strong oral and written communication skills 

• Skills in stakeholder management 

• Experience working with cross-functional teams 

• Experience with tools such as dbt and Tableau Online 

• Proficiency in data visualization (Tableau preferred) 

• Experience in Python is a plus 

• Knowledge of data management frameworks such as DMBOK 

• Bachelor’s degree in a relevant field or equivalent experience required 

• 3+ years of experience in data management with demonstrated analytical competencies 

Work in a way that works for you 

We promote a healthy work/life balance across the organization. We offer an appealing working prospect for our people. With numerous wellbeing initiatives, shared parental leave, study assistance, and sabbaticals, we will help you meet your immediate responsibilities and your long-term goals.

Working for You 

We understand that your well-being and happiness are essential to a successful career. Here are some benefits we offer: 

• Comprehensive Health Insurance covering you and your immediate family 

• Enhanced Health Insurance Options with competitive rates 

• Group Life Insurance ensuring financial security for your loved ones 

• Group Accident Insurance offering extra protection 

• Flexible Working Arrangements to achieve a balanced work-life schedule 

• Employee Assistance Program providing support for personal and work-related challenges 

• Medical Screening prioritizing your well-being 

• Modern Family Benefits including maternity, paternity, and adoption support 

• Long-Service Awards recognizing dedication and commitment 

• Celebratory New Baby Gift 

• Various Paid Time Off options including Casual Leave, Sick Leave, Privilege Leave, Compassionate Leave, Special Sick Leave, and Gazetted Public Holidays 

About the Business 

We are a global leader in information and analytics, helping researchers and healthcare professionals advance science and improve health outcomes for the benefit of society. Building on our publishing heritage, we combine quality information and vast data sets with analytics to support visionary science and research, health education, and interactive learning, as well as exceptional healthcare and clinical practice. At Elsevier, your work contributes to the world's grand challenges and a more sustainable future. We harness innovative technologies to support science and healthcare to partner for a better world.