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 deemedappropriate 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.