Looking for Business Data Analyst

Job role: Business Data Analyst

Location: Farmington Hills, MI

Need w2 consultants only and must have banking/Finance experience

exp:10+ years
Job Description

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

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.

Additional Skills:

• Python
• Java