Business Data Analyst

Business Data Analyst

Description :

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

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

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

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

• Assist with special initiatives/projects specific to related MBFS 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.

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

Required Skills:

Expereinced creating ad Hoc Reports

5+ years of experience

Skilled in creating SQL Reports

Skilled in using BI Tools like SQL and Excel

Knowledgable in Python and Java