Overview
Hybrid
Depends on Experience
Contract - Independent
Contract - W2
Contract - 9 Month(s)
No Travel Required
Unable to Provide Sponsorship
Skills
Attention To Detail
Business Requirements Gathering
Cloud Computing
Communication
Confluence
Dashboard
Data Architecture
Data Extraction
Data Quality
Database
Documentation
Field Operations
Finance
IBM
IBM Cognos Analytics
JIRA
Management
Management Information Systems
Mapping
Microsoft Excel
Microsoft Power BI
Mockups
Pivot Table
Python
Reporting
Research
SQL
Technical Support
Test Cases
Testing
Thought Leadership
UI
VBA
VLOOKUP
Wireframe
Writing
Job Details
Sr BI Business Analyst
Work Locations: Detroit, MI (hybrid schedule 3 days in office, 2 days' work from home per week)
The Opportunity
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 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
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 organization and documentation skills required.
Thorough approach and attention to detail required.
Ability to achieve balance between the right technical and business solution required.
Experience collaborating with partners to capture requirement 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 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 preferred.
Experience in Consumer Finance or Auto Finance industry (consumer lending and servicing, commercial lending, etc.) strongly preferred.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.