BI Data Analyst

About The Business

LexisNexis Risk Solutions is the essential partner in the assessment of risk. Within our Business Services vertical, we offer a multitude of solutions focused on helping businesses of all sizes drive higher revenue growth, maximize operational efficiencies, and improve customer experience. Our solutions help our customers solve difficult problems in the areas of Anti-Money Laundering/Counter Terrorist Financing, Identity Authentication & Verification, Fraud and Credit Risk mitigation and Customer Data Management. You can learn more about LexisNexis Risk at the link below, https://risk.lexisnexis.com

About The Role

The BI Data Analyst position works closely with Operations Program Management in supporting multiple initiatives to deliver business and technical analysis and metrics driving actionable insights and underlining strategic targets. Heavy focus on independent data analysis, proactive problem solving, and dashboard development with a business partner and solutions-oriented mindset.

Ideal candidate can be remote or hybrid from our Dayton, OH, Boca Raton, FL or Alpharetta, GA offices for onsite meetings as needed.

Responsibilities

Data Infrastructure:

• 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 & Reports

• 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
  
  

Ensure Compliance

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

Data Visualization

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

U.S. National Base Pay Range: $102,800 - $171,300. Geographic differentials may apply in some locations to better reflect local market rates. If performed in Ohio, the pay range is $97,700 - $162,700. This job is eligible for an annual incentive bonus. We know that your wellbeing and happiness are key to a long and successful career. These are some of the benefits we are delighted to offer to our US full- and part-time employees working at least 20 hours or more per week:

• 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