Hybrid BI Data Analyst

at RELX

• Job title: BI Data Analyst
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: $102,800 - $171,300 per year
• Degree requirement: Bachelor's Degree
• Tech skills: ETL, Python, SQL, Tableau
• Location requirements: Hybrid, Boca Raton, United States

About the role

• BI Data Analyst working at LexisNexis Risk Solutions, supporting business and technical analysis with data-driven insights. Collaborating with teams to develop actionable metrics and improve decision-making processes.

Responsibilities

• Understand complex and underlying data relationships.
• Proactively pull ideas, issues, and observations into clear and concise PowerBI dashboards with clear storylines that drive actionable insights and takeaways
• Understand how to build relationships for multiple data sets and build and design data models and views within SQL
• Develop understanding of internal tool opportunities to improve sourcing, manipulation and delivery of data
• Build dashboards that are user-friendly, scalable across multiple teams and provide drill down capabilities
• Develop and manage automated routines for data and report deliveries as per agreed mode of communication and timing
• Provide consultative services with building quick, stand-alone solutions and prototypes
• Translate, where applicable, stand-alone solutions into scalable dashboards / models in line with the BI strategy
• Build data models or repositories to manipulate data into a usable structured format
• Work with current tools and reporting teams to improve raw data usability
• Undertake analysis using range of statistical modelling techniques
• Provide business stakeholders with relevant analysis and support them throughout the decision-making process
• Once anomalies are identified, use root cause analysis tools and techniques to identify cause and then assign owners for improvement investigation/action
• Communicate and collaborate with stakeholders to ensure correct action taken to address anomalies ensuring issue resolution completed and effect confirmation tracked
• Independently analyze data and dashboards, question inconsistencies, identify positive and negative trends, gaps, and areas of opportunity, and recommend cost-effective solutions and/or follow-ups.
• Appropriately challenge the status quo.
• Ensure data collected and reported are accurate and correct in all aspects and meet data compliance standards.
• Ensure all technical solutions that are made available are tested and works to expected functionality.
• Participate and support data compliance exercises
• Create (wherever applicable) and maintain documentation related to data infrastructure, dashboards, and reports
• Maintain change log of all changes and revisions that are made
• Interact and develop relationships with teams within and outside Operations with the purpose of understanding the data needs
• Cross pollinate best practices across the organization
• Ad-hoc projects, analytics, and reporting as needed.

Requirements

• Data collection: data cleansing, setting up measurement systems and relational databases, sql queries joining and transforming complex data into an analysis-ready dataset.
• Working knowledge on ETL tools such as Knime or Alteryx will be an added advantage
• Data Exploration: Hands on experience in exploratory data analysis to identify patterns/trends and identify data anomalies/outliers
• Data Visualization: Presents actionable insights in a simple story. Effective visualization representation of story (emotion/connection).
• Advanced knowledge of visualization tools especially Microsoft Power BI and Tableau
• Programming Experience in programming languages such as R, Python and Excel Macros, with good understanding on the landscape of the most commonly used data science libraries and packages.
• Strong communicator: able to communicate complex, detailed technical/analytical data via enhanced verbal and written communication skills including to non-technical/analytical audience/Senior Management team/Stakeholder level as required
• Demonstrated advanced analytical and problem-solving skills in dealing with large complex data sets and projects.
• Excels in conceptual thinking and proactively making recommendations for solution options.
• Advanced computer skills in PowerBI, SQL, and Excel and significant experience with applications within MS Office.
• Results-oriented, strong organizational skills consistently demonstrating the ability to independently prioritize concurrent initiatives.
• Strong problem-solving and collaboration capabilities, with a business partner/customer service mindset and consistent professionalism.
• Independently and effectively navigates a highly matrixed organization, interacting and effectively influencing peers and various management levels.

Benefits

• Health Benefits: Comprehensive, multi-carrier program for medical, dental and vision benefits
• Retirement Benefits: 401(k) with match and an Employee Share Purchase Plan
• Wellbeing: Wellness platform with incentives, Headspace app subscription, Employee Assistance and Time-off Programs
• Short-and-Long Term Disability, Life and Accidental Death Insurance, Critical Illness, and Hospital Indemnity
• Family Benefits, including bonding and family care leaves, adoption and surrogacy benefits
• Health Savings, Health Care, Dependent Care and Commuter Spending Accounts
• In addition to annual Paid Time Off, we offer up to two days of paid leave each to participate in Employee Resource Groups and to volunteer with your charity of choice