At Shire, we are proud and grateful to employ military veterans and thank them for their contributions to our company and our country. See where your military experience can play a role at Shire by using our military skills translator job search tool below:
The Business Analytics will support analytical for the business and segment reports assigned by the BU. They will be responsible for auditing, updating, troubleshooting, and general maintenance of price data in Customer Relationship Management (CRM) tool, price lists, price guides, pricing documentation for tactical deal pricing teams, and training documents. He/ She will also be the 1st point of contact for role/function concerns and escalations. He/ She responds to and fulfills requests for data analysis, data visualization, and reporting in a timely manner and with a high degree of accuracy. He/ She will also work on the pricing tools using VBA/macros to enhance and maintain models. Lastly, he/she will supervise a team member operationally.
Accountabilities:
Performs data analysis and reporting utilizing a detailed knowledge of computer systems, data analysis and database management to support the needs of sales regions.
Collects and manipulates data as well as create, design and develop queries to analyze, track and report internal data. (AVT Report, MSA Reports, Renewal Letter Data Report)
Prepares reports and recommendations and participates in the analysis and interpretation of data as appropriate.
Identifies and shares best practices amongst all sales support.
Proactively seeks to improve knowledge and opportunities to learn about new and existing products and services available. Utilizes this knowledge in handling customer requests to add value to customer interactions.
Design and develop reports and dashboards that are user-friendly, scalable across multiple teams, provide drill down capabilities, and supported by the agreed methods and tools.
Perform advanced data hygiene checks and implement precautionary measures to ensure data quality.
Verifies the collected data is within required quality standards.
Play an active role in maintenance of reports, dashboards, and databases.
Adheres to current standards (e.g. GDPR requirements).
Create (wherever applicable) and maintain documentation related to data infrastructure, dashboards, reports, and analytical solutions and store in appropriate repositories.
Enhance and maintain models for Pricing Tools using VBA.
Evaluates effectiveness of pricing strategies and modifies pricing structures as needed.
Provide recommendations in solving data related concerns.
Provide actionable insights to BU using complex data analysis.
Supports Business Units in various adhoc projects as needed.
Train the New Hire
Root Cause Analysis, CI mindset
Supervise his/her team member (Operational)
Performs data analysis and reporting utilizing a detailed knowledge of computer systems, data analysis and database management to support the needs of sales regions.
Collects and manipulates data as well as create, design and develop queries to analyze, track and report internal data. (AVT Report, MSA Reports, Renewal Letter Data Report)
Prepares reports and recommendations and participates in the analysis and interpretation of data as appropriate.
Identifies and shares best practices amongst all sales support.
Proactively seeks to improve knowledge and opportunities to learn about new and existing products and services available. Utilizes this knowledge in handling customer requests to add value to customer interactions.
Design and develop reports and dashboards that are user-friendly, scalable across multiple teams, provide drill down capabilities, and supported by the agreed methods and tools.
Perform advanced data hygiene checks and implement precautionary measures to ensure data quality.
Verifies the collected data is within required quality standards.
Play an active role in maintenance of reports, dashboards, and databases.
Adheres to current standards (e.g. GDPR requirements).
Create (wherever applicable) and maintain documentation related to data infrastructure, dashboards, reports, and analytical solutions and store in appropriate repositories.
Enhance and maintain models for Pricing Tools using VBA.
Evaluates effectiveness of pricing strategies and modifies pricing structures as needed.
Provide recommendations in solving data related concerns.
Provide actionable insights to BU using complex data analysis.
Supports Business Units in various adhoc projects as needed.
Train the New Hire
Root Cause Analysis, CI mindset
Supervise his/her team member (Operational)
Qualifications:
Must possess at least a Bachelor's/College Degree in any field
At least 2 years of solid working knowledge of SQL as well as strong computer skills in general
Experience in a business or sales environment analyzing data, writing SQL queries and developing reporting solutions
Knowledge in VBA/Macros (Basic-Intermediate)
Proficient in Microsoft software applications (MS Outlook, MS Word, MS Excel, MS PowerPoint and MS Access).
Intermediate to Advanced knowledge in MS Excel (e.g. V-Lookup, Pivot Tables, etc.)
Background in Tableau and CRM tools are a plus
Salesforce Reports and Dashboards
LexisNexis, a division of RELX Group, 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 (https://www.relx.com/careers/join-us/privacy) .
RELX is a global provider of information and analytics for professional and business customers across industries.
We help scientists make new discoveries, lawyers win cases, doctors save lives and insurance companies offer customers lower prices. We save taxpayers and consumers money by preventing fraud and help executives forge commercial relationships with their clients.
In short, we enable our customers to make better decisions, get better results and be more productive.