Project Manager - Greenfield Data Warehouse

PLEASE NOTE: WE ARE NOT ACCEPTING ANY 3RD PARTY SOLICITATIONS. ANY SUCH INQUIRIES WILL NOT BE CONSIDERED OR RECEIVE A RESPONSE. WE CAN ONLY WORK WITH DIRECT APPLICANTS WHO ARE AUTHORIZED TO WORK IN THE US WITHOUT SPONSORSHIP. THIS IS AN ON-SITE ROLE FOR LOCAL CANDIDATES ONLY.

SOFT's client located in remote is looking for a Project Manager - Greenfield Data Warehouse for a long term contract assignment.

Project Manager - Data Warehouse

Position summary

Our client, a non-profit, is looking for a Project Manager to lead a grant-funded, greenfield data warehouse effort. Data is currently siloed across 20–25 systems and includes sensitive records under FERPA, HIPAA and other compliance rules. This initiative is estimated to take about 3 years to complete, with the first MVP of 3 systems ingested by June 2027.

This role sits between non-technical program staff, who know the business processes, and IT, who knows the infrastructure but not the program data systems. The right person can explain complicated technical decisions and downstream technical and business implications of build decisions in plain language to business executives, and turn complicated business processes into a clear delivery plan.

The project

• Greenfield build: From scratch build opportunity! The PM will help shape the architecture, roadmap and delivery approach from the start.

• Platform: Microsoft data platform, Microsoft Fabric. Data sources are third-party vendor and government systems with varying integration pattern capability.

• Scope: 20–25 source systems in total, with a complicated data structure and siloed ownership to be brought together in a data warehouse with user defined roles for access to appropriate data, and proper governance to ensure that sensitive health information (PHI), student education records (EDR) are classified, secured, accessed only by authorized personnel, retained and disposed of according to law, and monitored for compliance throughout their lifecycle. Of interest are a Master Person Index, creating repeatable integration patterns, and knowledge transfer to staff for sustainability post-grant.

• Compliance and security: student and health data under FERPA and HIPAA, plus other regulations. Access controls and security are central to the design.

• Data governance: still in its early stages. The PM will help the Delivery Lead build data governance out alongside the creation of the warehouse.

Responsibilities

• In conjunction with the Delivery Lead, lead the data warehouse project end to end, from planning through MVP delivery and the rollout of the remaining 17-22 systems.

• Explain technical choices, trade-offs and risks clearly to non-technical leaders and staff.

• Revise the existing proof-of-concept document into a project charter, roadmap and delivery plan with achievable milestones.

• Work with the Product Owner to inventory and prioritize the 20–25 source systems, and plan the order in which they are ingested.

• Support the Delivery Lead in building the data governance program: data ownership, access policies, data quality and definitions.

• Work with program staff, the Delivery Lead, and Business Analyst to document complicated business processes, data flows and reporting needs, and translate them into requirements for IT and technical teams.

• Coordinate IT, business leaders, data engineers, vendors and program staff; run status meetings and track risks, issues, dependencies and decisions.

• Make sure the design meets FERPA, HIPAA and other compliance and security requirements, working with security and compliance staff.

• Report progress against grant milestones and budget.

Required qualifications

· 6-8+ years of IT project management experience, including leading at least one data warehouse or enterprise data platform built from scratch.

· Hands-on Microsoft Azure or Microsoft Fabric experience (lakehouse, OneLake, pipelines).

• Working knowledge of the Microsoft data stack (Microsoft Fabric, Azure Synapse, Azure Data Factory, SQL Server or Power BI).

• Experience setting up data governance: data ownership and stewardship, access policies, data catalogs or Microsoft Purview.

• Experience bringing many source systems into a single warehouse: planning integration, data mapping and phased rollout.

• Experience on projects with regulated, sensitive data, such as FERPA, HIPAA or similar privacy and security requirements.

• A strong track record of working with non-technical stakeholders: gathering requirements, learning complicated business processes and explaining technical topics in plain language.

• Experience coordinating IT, vendors and business teams in a matrixed setting.

• Excellent written communication, including project plans, status reports and stakeholder updates.

Preferred qualifications

• Non-Profit, grant-funded project experience, including reporting against grant milestones.

• Background in education, health and human services, nonprofit or public sector organizations.

• PMP or similar certification; familiarity with Agile delivery.

Reporting and working relationships

• Reports to: the Delivery Lead, a non-technical program manager who knows the programs and how the work gets done. The Delivery Lead also owns data governance.

• Works closely with: IT, which owns the technical infrastructure but is less familiar with the programs and their systems. The PM bridges the two groups, owns the project plan, coordination, milestones, risks, accountability, andactively supports the data governance decisions.

• Also works with: program and business staff, security and compliance staff, and any vendors or data engineers brought in for the build.