Business Intelligence Analyst I

CLIENT HIGHLIGHT

The client you’ll be supporting is a Fortune 500 global leader in energy technology, focused on helping the world produce cleaner, more reliable power. Their teams design and improve the systems that keep homes, businesses, and communities running, from gas and wind turbines to the electrical grids that connect them. This is a chance to be part of a company that’s driving innovation, supporting sustainability, and shaping the future of energy.

LOCATION

Remote, USA

COMPENSATION

$31.50-37.50

SCHEDULE

Fully Remote

Monday -Friday, EST hours

CONTRACT TERM

1 year with high likelihood of extension or conversion to full time employee.

POSITION OVERVIEW – Business Intelligence Analyst I

We are seeking a highly skilled contractor with strong technical expertise across Excel automation, workflow development, reporting, and SharePoint administration. The ideal candidate will have demonstrated experience building advanced Excel macros, managing enterprise workflow tools, and delivering actionable business insights through Salesforce reporting. This role requires a proactive problem solver with strong attention to detail and the ability to work independently with minimal supervision.

RESPONSIBILITIES

Advanced Excel Automation & VBA Development

- Write, test, and maintain VBA code to automate repetitive tasks in Excel.

- Develop custom functions, macros, and user forms to improve data processing and analysis.

- Create and implement VBA solutions to streamline workflows and reduce manual effort.

- Design and develop complex Excel models and dashboards for data visualization and reporting.

- Troubleshoot and maintain existing Excel automation tools.

- Ensure code quality, data accuracy and integrity, documentation, and robust error-handling techniques.

- Provide training and support to end-users on VBA applications and Excel tools.

- Document VBA code and create user guides to facilitate understanding and usage.

Business Workflow Development & Maintenance

- Develop, modify, and maintain business workflows based on business requirements.

- Improve existing workflow logic and performance.

- Collaborate with stakeholders to gather requirements and test enhancements.

Salesforce Reporting & Data Management

- Produce, manage, and optimize Salesforce.com reports and dashboards.

- Deliver recurring and ad hoc reports for business stakeholders.

- Ensure data integrity, accuracy, and consistency across reporting outputs.

- Collaborate with other stakeholders on reporting & data requirements.

SharePoint Site Management

- Administer, update, and maintain business/function Microsoft SharePoint sites.

- Manage site structure, permissions, document libraries, and user access.

- Implement improvements to enhance usability and organization.

REQUIRED QUALIFICATIONS/SKILLS

- Proven advanced-level experience with Excel macros and VBA (portfolio or demonstrated examples preferred), as well as being versed in the interoperability of the O365 suite in an enterprise environment.

- Certification in O365, Excel or VBA is highly desirable.

- Hands-on experience with business workflow development (or similar enterprise workflow systems).

- Strong understanding of Salesforce.com reporting, dashboards, and data structures.

- Practical experience in SharePoint site administration and content management.

- Strong analytical, organizational, and communication skills.

- Ability to work independently and manage multiple priorities simultaneously.