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.

Elsevier is an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law. We are committed to providing a fair and accessible hiring process. If you have a disability or other need that requires accommodation or adjustment, please let us know by completing our Applicant Request Support Form: https://forms.office.com/r/eVgFxjLmAK , or please contact 1-855-833-5120.

Please read our Candidate Privacy Policy.