IT - Business Data Analyst_Local to MICHIGAN NEEDED_Only on W2

Chelsoft Solutions Co

Farmington Hills, MI, USA

Published: 6/14/2022

Full Time

Job Description

Hybrid 4 days in Farmington Hills MI

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.