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.
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
*The position is 100% remote.
*May be asked to travel onsite on occasion to meet with client team in NJ or CO
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.
- 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.
- 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.
- 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.
*The position is 100% remote.
*May be asked to travel onsite on occasion to meet with client team in NJ or CO
Voyage Advisory Chicago, Illinois, USA Office
320 W Ohio St, Chicago, IL , United States, 60654
Similar Jobs
Fintech • Mobile • Real Estate • Financial Services • PropTech
Own end-to-end enterprise sales into large multifamily owners: prospect, demo, negotiate, close, launch and expand accounts. Spend significant face-to-face time in market, sell to C-suite, manage complex multi-threaded deals, partner with Customer Success and Product, and help build sales playbooks and processes.
Fintech • Mobile • Real Estate • Financial Services • PropTech
Serve as the technical counterpart to Account Executives for enterprise property management partners: lead pre-sales discovery, demos, and solution design; gather API credentials, configure SFTP/API integrations, and own post-sale implementation to launch partners; build the Solutions Engineering function and documentation; complete RFPs and security reviews; travel extensively to partner sites.
Top Skills:
APIsEntrataErpETLJavaMriPythonRealpageSftpSQLYardi
Artificial Intelligence • Machine Learning • Natural Language Processing • Professional Services • Software • Consulting • Automation
Lead strategy and execution for a tiered partner program: identify, qualify, and onboard partners; manage Tier 1/2 executive relationships; structure alliance deals; drive co-marketing and enablement; build partner performance dashboards; partner with sales, product, marketing, and legal; mentor junior team members and scale partner operations to drive joint revenue.
Top Skills:
AWSCRMGCPHubspotMicrosoftPrmSalesforce
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
