Consultant, SharePoint Reporting Analyst/Developer

Voyage Advisory
Chicago, IL
Consultant, SharePoint Reporting Analyst/ Developer

Our client is seeking a highly experienced SharePoint Analyst to support a hybrid mix of business analysis, financial reporting using Power BI , and SharePoint development. This role is responsible for designing, developing, testing, and implementing enhancements to an internally built SharePoint solution used by the Project Management Office (PMO) for productivity reporting, financial reporting and project oversight.

The analyst will take full ownership of the SharePoint tool—becoming the subject ‑ matter expert, ensuring data integrity, maintaining a single source of truth, and driving continuous improvement. This role requires close collaboration with IT, business leaders, project managers, and finance partners to ensure accurate reporting and well ‑ designed processes.

A detail ‑ oriented professional who enjoys Power BI reporting, process improvement, cross ‑ functional collaboration, and tool ownership is encouraged to apply.

PRIMARY RESPONSIBILITIES
  • Produce monthly financial reports in partnership with the project sponsor, ensuring accuracy and consistency.
  • Document enhancement opportunities, gather requirements, obtain stakeholder consensus, and implement approved changes in SharePoint.
  • Validate data accuracy with business sponsors and maintain a trusted single source of truth.
  • Develop SharePoint workflows, lists, libraries, forms, and dashboards to support PMO reporting needs.
  • Troubleshoot system issues, perform root ‑ cause analysis, and implement sustainable fixes.
  • Maintain documentation including data dictionaries, process flows, and change logs.
  • Train end users and provide ongoing support for the SharePoint tool.
  • Collaborate with IT as needed to align with governance, security, and integration standards.
REQUIRED QUALIFICATIONS
  • Advanced knowledge of Power Automate Cloud Flows, including troubleshooting failed runs, monitoring flow health, and optimizing performance.
  • Hands-on experience designing and supporting solutions using SharePoint Lists as a data source.
  • Strong understanding of SharePoint List architecture, including columns, lookups, permissions, indexing, thresholds, and performance limitations.
  • Ability to troubleshoot end-to-end process failures across Power Apps, Power Automate, SharePoint, and related Microsoft 365 services.
  • Experience monitoring system operations and proactively identifying issues affecting business processes.
  • Strong knowledge of relational database concepts, including:
  • Primary and foreign keys
  • One-to-one, one-to-many, and many-to-many relationships.
  • Experience with Power BI reporting and operational dashboards.
  • Experience supporting enterprise-scale Power Platform solutions with multiple integrations.
  • SharePoint Online expertise (lists, libraries, permissions, views, forms, Power Automate workflows).
  • Power BI expertise.
  • Business analysis skills including requirements gathering, process mapping, and stakeholder facilitation to facilitate system enhancements.
  • Financial reporting familiarity—understanding of budgets, forecasts, and project financials.
  • Data validation and quality assurance experience.
  • Strong proficiency with Excel or similar reporting tools.
  • Excellent communication and documentation skills.
  • Willingness to work early or late on occasion to support monthly reporting deadlines.
PREFERRED QUALIFICATIONS
  • Knowledge of project management methodologies (PMO experience a plus).
  • Familiarity with Power Apps or custom SharePoint form development.
  • Smartsheet Integration / Application support.
  • Background in financial systems or enterprise data environments.
  • Industry experience in Consumer-Packaged Goods (CPG).
  • Comfortable presenting reports to C-level meeting attendees.
  • Willingness to travel to NJ or CO on occasion.
COMPENSATION
  • This position has the option of being a full-time employee with benefits eligibility, or a 1099 contract position. Total compensation is negotiable and will be based on a permanent or contract arrangement. Benefits can include health, dental, vision, disability, and life insurance, a 401(k) program with a company match, plus paid vacation and sick time.
Must be available during standard working hours of 8:00 – 5:00 Eastern Time Zone

*The position is 100% remote.
*May be asked to travel onsite on occasion to meet with client team in NJ or CO

Posted 2026-08-05

Recommended Jobs

Site Leader

Bilfinger
North Chicago, IL

Bilfinger is a leading international industrial services provider, driving efficiency and sustainability for the process industry. With 30,000+ employees and over €5 billion in revenue in 2024, we off…

View Details
Posted 2026-06-23

Kitchen Manager

Home Run Inn Pizza - Hillside
Hillside, IL

Step Up to the Plate as Our Kitchen Manager! Location:   Hillside Pizzeria Department:   Restaurant Operations Pay:  $25-$28/hr At Home Run Inn, we believe pizza should do more than fill y…

View Details
Posted 2026-07-31

Full Time Retail Store Team Leader - Water Tower Place, Chicago, IL

America, IL

Job Description Core Responsibilities: • Assists the ASM and SM in maintaining holiday, attendance, and team scheduling • Effectively supervise Sales Associates during the shift, dealing with …

View Details
Posted 2026-08-20

Marketing & Communications Manager - 4 days/week in Chicago office

Golub & Company
Chicago, IL

Chicago-based Golub & Company LLC and its affiliates are active in key markets across the United States in real estate development, acquisitions, asset and property management, leasing and corporate r…

View Details
Posted 2026-08-17

Java Lead Software Engineer - Kafka

JPMorgan Chase & Co.
Chicago, IL

Job Description We have an opportunity to impact your career and provide an adventure where you can push the limits of what's possible. As a Lead Software Engineer at JPMorganChase within the C…

View Details
Posted 2026-08-19

Parts Counterperson

Bull Valley Ford, Inc
Woodstock, IL

The Parts Counter Person is responsible for customer service and retail sales at an auto parts store. In this position, your responsibilities include selling parts and taking inventory of stock in sto…

View Details
Posted 2025-08-28

Office Assistant

R&R Human Resources Solutions
Franklin Park, IL

Paul Heath Associates, one of Chicago's premier providers of home entertainment and automation control systems, located in Franklin Park (near 294) is seeking a bright, energetic, computer literate i…

View Details
Posted 2026-07-17

Registered Nurse Internal Agency Emergency Department's Only Full-time Nights

Northwestern Medicine Corporate
Winfield, IL

The salary range for this position is $39.00 - $62.40 (Hourly Rate) Placement within the salary range is dependent on several factors such as relevant work experience and internal equity. For positi…

View Details
Posted 2026-07-11

Technician II Prosperity - De Land, IL

Vestas
De Land, IL

We are Offering $2,500 USD GWO Sign On Bonus* Join our journey towards wind energy solutions . At Vestas, we believe in a world powered by renewable energy. We are a worldwide authority …

View Details
Posted 2026-06-26

Travel Registered Nurse Med Surg Job

New Lenox, IL

Job Overview TLC Nursing Associates, Inc. is seeking a dedicated RN – Medical-Surgical (Med Surg) for travel assignments . This role involves providing direct patient care to individuals wit…

View Details
Posted 2026-08-11