Consultant, SharePoint Reporting Analyst/Developer

Posted 2 Days Ago
Be an Early Applicant
Chicago, IL, USA
In-Office
Senior level
Business Intelligence • Consulting
We help our clients care for their customers.
The Role
Owner of an internally built SharePoint PMO tool, the role designs, develops, tests, and implements SharePoint and Power Platform enhancements. Responsible for Power BI financial reporting, data validation, workflows, dashboards, troubleshooting, documentation, user training, and cross-functional collaboration with IT, finance, and project teams to maintain a single source of truth and drive continuous improvement.
Summary Generated by Built In
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 subjectmatter 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 welldesigned processes.
A detailoriented professional who enjoys Power BI reporting, process improvement, crossfunctional 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 rootcause 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
 

Skills Required

  • 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 (columns, lookups, permissions, indexing, thresholds, performance).
  • Ability to troubleshoot end-to-end process failures across Power Apps, Power Automate, SharePoint, and Microsoft 365 services.
  • Experience monitoring system operations and proactively identifying issues affecting business processes.
  • Strong knowledge of relational database concepts (primary/foreign keys; one-to-one, one-to-many, 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.
  • Familiarity with financial reporting concepts (budgets, forecasts, 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 and be available during 8:00-5:00 Eastern Time.
  • Knowledge of project management methodologies / PMO experience.
  • Familiarity with Power Apps or custom SharePoint form development.
  • Smartsheet integration / application support experience.
  • 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.
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chicago, IL
30 Employees
Year Founded: 2018

What We Do

Voyage’s team of management consultants work side-by-side with leaders to achieve their top objectives and solve their toughest problems. We work tirelessly until strategy becomes reality. We have the skill, discipline and insight to lead critical projects, to design and implement process improvements, to drive change efforts toward maximum ROI, and to elevate customer experience — saving companies time, money and aggravation.

Similar Jobs

Tempus AI Logo Tempus AI

Scientist

Artificial Intelligence • Big Data • Healthtech • Machine Learning • Analytics • Biotech • Generative AI
Hybrid
4 Locations
3775 Employees
90K-150K Annually

Samsara Logo Samsara

Enterprise Account Executive

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
222K-278K Annually

Zoro Logo Zoro

Senior Software Engineer

eCommerce • Information Technology • Retail • Industrial
Hybrid
Chicago, IL, USA
620 Employees
105K-175K Annually

Invenergy Logo Invenergy

Quality Assurance Coordinator

Greentech • Real Estate • Social Impact • Energy • Industrial • Solar • Renewable Energy
In-Office
Bolingbrook, IL, USA
2500 Employees
80K-90K Annually

Similar Companies Hiring

Northslope Thumbnail
Artificial Intelligence • Information Technology • Software • Analytics • Consulting • Generative AI
London, GB
100 Employees
Compa Thumbnail
Artificial Intelligence • HR Tech • Software • Business Intelligence
Irvine, California
75 Employees
Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account