Business Analyst with BI (Local Hire)

Job Title: Business Analyst with BI experience

Duration: 06+ Month (Extendable)

Location: Detroit, MI - Hybrid

NOTE: NEED LOCALS ONLY/W2 HIRING

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.

Required Skills:

• 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.