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*