Data and Reporting Architect

Location: Telework

Employment Type: Full-Time, W-2

Experience Level: 5–10 Years

Eligibility: U.S. Citizenship Required; successful background check required

Clearance: No security clearance required

About CPMC

CPMC is a veteran-owned government contractor established in 2016. We support more than 25 federal programs and deliver practical, mission-focused solutions for our government customers. Our team values collaboration, accountability, and translating complex challenges into sustainable outcomes.

About the Role

CPMC is seeking a Data & Reporting Architect to join an integrated financial management implementation team responsible for modernizing contract forecasting, financial reporting, and executive dashboard capabilities.

This role bridges business design and technical execution. The Data & Reporting Architect will translate business requirements developed by a Senior Financial SME/PMO Architect into implementable data, reporting, integration, and dashboard requirements. You will work closely with internal IT and Data Lake teams, business stakeholders, and a Technical Analyst responsible for developing reporting outputs.

This is an ideal opportunity for a collaborative professional who is comfortable working across Finance, Program Management, and executive stakeholders while partnering with IT, data engineering, and BI/reporting teams to turn complex or ambiguous needs into clear, actionable solutions.

Key Responsibilities

• Translate approved business designs and requirements into clear technical requirements for data, reporting, integrations, dashboards, and analytics.
• Coordinate with internal IT and Data Lake teams to define data queries, source connections, refresh schedules, data mappings, and integration logic.
• Partner with IT to define and support dashboard security, user access, and reporting governance requirements.
• Define and document the business process for collecting, validating, and publishing contract forecasting data.
• Support testing activities, including RTP testing, after approved updates are incorporated into source systems.
• Guide and support a Technical Analyst in building, refining, validating, and maintaining dashboard and reporting outputs.
• Develop and maintain documentation for business rules, data mappings, report definitions, data lineage, and reporting logic to enable longterm sustainment by internal teams.
• Participate in working sessions, design reviews, stakeholder interviews, requirementsvalidation meetings, and integrated deliveryteam activities.
• Support prototype development, report wireframes, dashboard mockups, and iterative stakeholder reviews.
• Identify opportunities to standardize forecasting and reporting processes while maintaining flexibility for programspecific requirements.
• Build strong working relationships across Finance, Program Management, executive leadership, IT, data, and reporting teams.

Required Qualifications

• Bachelor’s degree or equivalent combination of education, training, and relevant experience.
• 510 years of professional experience in data architecture, reporting, business intelligence, analytics, or related disciplines.
• Demonstrated experience architecting data and reporting solutions, including data modeling, query design, dashboard development, and reporting requirements definition.
• Experience working with enterprise data platforms, including data lakes, data warehouses, or similar environments.
• Experience coordinating with IT and data engineering teams on data access, security, integration, mappings, and refresh processes.
• Strong working knowledge of reporting and dashboarding tools such as Power BI, Tableau, or equivalent platforms.
• Ability to translate business requirements into detailed, implementable technical specifications.
• Experience supporting financial management, program or contract forecasting, PMO reporting, or related operational reporting environments.
• Excellent written and verbal communication skills, with the ability to effectively bridge business and technical stakeholders.
• Strong documentation skills, including requirements documentation, business rules, report specifications, and datamapping artifacts.
• Ability to work effectively in a collaborative, fastpaced tigerteam or integrated delivery environment.
• U.S. citizenship is required for this federal program.
• Ability to successfully complete a background check.

Preferred Qualifications

• Experience supporting financial forecasting systems, program management reporting tools, RTP, or comparable contract forecasting platforms.
• Familiarity with enterprise reporting security, rolebased access controls, and dataaccess governance.
• Prior experience in consulting, PMO, financial transformation, or integrated implementation engagements.
• Experience mentoring, directing, or providing technical guidance to BI analysts, reporting analysts, or technical team members.
• Government contracting or professional services industry experience.

What Success Looks Like

• Business requirements are accurately translated into clear, complete, and implementable technical specifications.
• Data connections, queries, refresh processes, mappings, and reporting logic are thoroughly documented and sustainable for internal IT and data teams.
• Dashboards and reports provide meaningful, trusted information for executives, program managers, and Finance stakeholders.
• Forecasting and reporting processes are more consistent, efficient, and scalable while preserving necessary programlevel flexibility.
• Strong partnerships across business and technical teams enable efficient, lowfriction delivery and continuous improvement.