Business Data Analyst

Required:

• BI Tools – Excel, SAP
• Java, Python
• Strong analytical and reporting skills.

Responsibilities:

• Quality Control:
• Review daily, weekly, and monthly manual reports/data extracts produced and Business Analyst Team for accuracy and resolve issues as needed.
• Publish the reports/data extracts to customers based on the distribution lists.
• Scope:
• Work with Business Analyst to review customers' requests and determine how to translate the requested report into a physical form, which includes defining the measures, dimensions, and layout of the report/data extract.
• Customer Support:
• Provide ad hoc reports and report development in a timely manner. Work with Business Analyst to assess the correct priority for requested items.
• Attend project meetings at a customer's request providing any analysis or other information required by the customer.
• Generate SQL reports/ file data extracts for Client Services Department accurately and timely.
• Create Design document for reports and data extracts. Reports must be accurate and within scheduled due dates.
• Provide formal and informal reporting training for the business users in Client Services department.
• Ad hoc Reports and Analytical:
• Assess customers' requests and provide ad hoc reporting (using BI tools, which includes SQL, and Excel) and analysis based on those requests. Work with Business Analyst to determine priority.
• Trouble shoot issues with report and data integrity as needed.
• Utilize SQL and business requirements to develop new reports/data extracts and provide ad hoc support.
• Resolve production issues for existing reports/data extracts.
• Support Business Team:
• Assist with special initiatives/projects specific to related initiatives.
• Represent project team during participation on key project initiatives.
• Work with Business Analyst to identify data gaps and utilize the Data Analyst team to incorporate needed information during quarterly IT updates.
• Business Analysis and Consulting:
• Work with Business Analyst to provide analytical and consulting engagements with in the functional areas of reporting responsibility.
• Work with Business Analyst to identify key areas of opportunity through process mapping or data analysis that would reduce or eliminate redundant reporting processes.
• Reduce the number of manually generated reports/data extracts through automation.