Business Data Analyst (Detroit)

The Opportunity

The Business Data 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 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 prioritize daily work.
• Schedule and host weekly Stakeholder meetings to share progress, resolve any blocking dependencies, groom and prioritize 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 analyze SQL queries to research data sources and validate report accuracy.
• Partner with internal IT teams to optimize data architecture and data utilization.
• 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

About Impetus