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.