Job description

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 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 • Bachelors degree in IT or data discipline (MIS, Computer Sci, etc.) required. • Masters 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.

Requirements

Must-haves

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.

Nice-to-haves

Masters degree in IT or data discipline (MIS, Computer Sci, etc.) preferred.
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.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqljirapython

Platform: manatal
Effort: medium