Business Analyst

Job Title: Business Analyst

Job Location: Detroit, MI (Hybrid)

Duration: Long Term Contract

Job Description

The Senior Business Intelligence Business Analyst – Auto Systems and Reporting will be responsible for acting as a member of a team that develops and maintains a set of reports used in systems support functions and auto finance field operations.

The Work Itself

• Consult with internal stakeholders to capture and document reporting requirements, including wireframe mockups of reports and the location of source data in system UI.
• Research and document the location of required source data in the appropriate database. Write SQL code to verify that the report requirements can be developed into a finished report.
• Create and maintain requirements documentation (mapping, rulebooks, etc.), testing documentation and approvals from stakeholders.
• Act as a primary contact for support, troubleshooting, defect documentation and tracking related to reports developed by the team.
• Schedule and host daily Development Team meetings; ensure an adequate backlog is maintained and help prioritise daily work.
• Schedule and host weekly Stakeholder meetings to share progress, resolve any blocking dependencies, groom and prioritise the request backlog.
• Create and provide periodic progress updates to Management; create Jira Dashboards to track team activities and report on volume and trends.
• Develop and analyse SQL queries to research data sources and validate report accuracy.
• Partner with internal IT teams to optimise data architecture and data utilisation.
• Participate in data quality rule creation and testing activities.
• Support and administer an IBM Cognos Reporting site for operational reports.
• Support and administer multiple Power BI workspaces, dashboards and apps for operational reports.
• Proactively engage in projects to provide data thought leadership.
• Perform special projects/assignments as needed.

The Skills You Bring

• Bachelor’s degree in IT or data discipline (MIS, Computer Sci, etc.) required.
• Master’s degree in IT or data discipline (MIS, Computer Sci, etc.) preferred.
• Strong written and oral communication skills required.
• Strong organisation and documentation skills required.
• Thorough approach and attention to detail required.
• Ability to achieve a balance between the right technical and business solution required.
• Experience collaborating with partners to capture requirements and document data sources required.
• Experience performing complex data extraction from multiple, large data sources required.
• Experience with development and administration of reporting packages required; experience with Power BI and IBM Cognos strongly preferred.
• Advanced knowledge of MS Excel and Power Query, including pivot tables and VLOOKUP functions, is strongly preferred.
• Experience creating data quality rules and executing test cases strongly preferred.
• Experience creating and administering SharePoint sites strongly preferred.
• Knowledge of Atlassian Jira and Confluence preferred.
• Experience creating data quality rules and testing activities preferred.
• Experience writing and executing SQL queries required; cloud-based data extraction preferred.
• Intermediate knowledge of automation through VBA preferred.
• Knowledge of Python is preferred.
• Experience in the Consumer Finance or Auto Finance industry (consumer lending and servicing, commercial lending, etc.) strongly preferred.