Business Data Analyst

Position Type:

• Contract
• Hybrid (Required to work 4 days in office)

Required:

• Experience developing reports using advanced reporting tools
• Ability to translate business reporting needs into insightful reporting solutions
• Experience communicating/collaborating with management to ensure the departments book of reporting is satisfying business needs
• Technical skills:
• Development Tools Cognos
• Development Tools MS Access
• Programming Languages SAS
• SQL intermediate ability to write complex queries to extract data from data repositories and translate into insightful metrics
• Excel advanced ability to utilize tool in day-to-day operation
• Cognos functional ability to utilize program to automate reporting
• Analytical skills Ability to Collect data and establish facts and identify trends and variances
• Ability to Integrate information from a variety of sources with varied levels of complexity
• Ability to Review and interpret and evaluate statistical information
• Ability to Formulate and test hypotheses for the purpose of forecasting outcomes
• Facilitation skills
• IT skills
• Language skills
• PC skills Microsoft Office SQL workbench Cognos (prefered)
• Presentation skills
• Problem Solving skills
• Project Management skills
• Sales skills
• Experience with query creation (i.e. SQL Cognos Report Studio SAS Python Access etc.) Organization; Time Management; Written Communication; Comfort communicating with different levels of management

Responsibilities:

• The Business Analyst supports Collections and Remarketing teams including Active Collections Recovery Exceptions Strategy and Soft Collections.
• Responsibilities include but are not limited to the following:
  • Collaborating with Leadership as well as Business and Data Stakeholders
  • Creating reccuring production and ad hoc reports
  • Analysis of business results to identify and communicate trends and possible correlated issues
  • Performing root cause analysis to eliminate defects in reports
  • Continuous improvement in efficiency and reporting quality
• Datamart testing and validation
  • Task Description / Performance Expectations
• Quality Control:
  • Review internally produced reports for accuracy and resolve issues as needed
  • Publish reports to stakeholders according to any SLAs or requirements
  • Identify and troubleshoot issues with report accuracy and data integrity as needed
  • Collaborate with stakeholders to determine report requirements including purpose scope and related details.
  • Translate requirements into technical specifications including dimensions/categories filters fields calculations metrics and layout) and final deliverable product
  • Maintain internal processes including but not limited to housing key information such as department roster history vendor KPIs Dialer metrics etc.
• Customer Support
  • Assess customer requests provide ad hoc reports and develop recurring reports in a timely manner
  • Coordinate with stakeholders and BA supervisor to determine priorities
  • Attend project meetings to provide analysis insight technical advice or other information as required
• Business Analysis and Consulting
  • Act as a consultant to business partners by providing trend and exception analysis as well as identifying possible correlated causes and solutions as necessary
  • Identify key areas of opportunity through process mapping or data analysis to reduce or eliminate redundant report processes/products
  • Reduce the number of manually generated reports through automation via corporate tools such as SAS Cognos Power BI or Tableau
  • Seek continuous improvement by increasing finding efficiency (run time) of in standard reports including visualizations where appropriate recreating reports in more appropriate tools and regular review of reports for use format accuracy applicability