Technical Business Data Analyst

Technical Business Data Analyst

Fort Worth TX

12 months contract

onsite interview

our client is hiring a Technical Business Analyst-Intermediate (Collections and Remarketing).

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 department's 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