Business Analyst

Summary:

Join an innovative and highly collaborative team as a Resource Business Analyst for a Global Automotive Company in Raymond, OH to support R&D data development and enhancement, analysis, reporting, and information management. As a Resource Business Analyst, you will engage with a multi-talented team to reach future-focused goals and will contribute to data management support.

Responsibilities:
• Develop and enhance data visualization and analysis tools to meet end user requirements.
• Oversee data ingestion, transformation, and loading (ETL) processes.
• Ensure data integrity and governance by creating or maintaining a data library.
• Support transition of Excel-based data and business process to SQL environments
• Provide basic user training and support for dashboards, ex: quick start guides for deployed dashboards.
• Develop prototype applications/processes where there may be ambiguity in requirements or end product needs.

Required Skillset:
• Proficiency in PowerBI for dashboard creation.
• SQL Query/ETL (intermediate skill is OK, ex: data load, joins, CTE, indexing)
• Experience in general database design, including tables, relationships, structures, and security.
• Ability to create and maintain schedule of own work (project management).
• Ability to make summary PowerPoint presentations explaining deliverable activity and progress.
• Ability to multi-task, prioritize, work independently and effectively communicate progress to management.
• Ability to learn quickly, collaborate with others, and be flexible in approaches.

Bonus Skillset:
• Experience managing budget data, including understanding types of expenses, accounts, and regular budget submission process.
• Intermediate to Advanced MS Excel including XLOOKUP/FILTER/LAMBDA.
• Experience with DAX coding
• Teams/SharePoint: Maintaining workspaces, files/folders, permissions

Location: Raymond, Ohio

Type: Contract

Duration: 12+ months
• No 3rd party agencies or C2C
•