Business Data Analyst

Business Data Analyst

Onsite role in Farmington Hills MI

12+ months contract

Our client is hiring a Business Data Analyst with 7+ years of exp.

Job Description:

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.