Salesforce business analyst serp_jobs.h1.location_city

Technical Business Data Analyst || Fort Worth TX || Mercedes Benz || 12 months contract || onsite interview

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