Data Analyst

Job Description

CLS is seeking a detail-oriented Data Analyst to support project setup, data governance, reporting, and project system administration. This position is responsible for reviewing approved project setup requests, creating and maintaining project records within CLS’s ERP system, validating project data, supporting reporting, and ensuring project information is accurately reflected across company systems. The Data Analyst will work closely with Business Development, Operations, Accounting, Information Technology, and Project Controls to support project initiation, reporting accuracy, and data integrity throughout the project lifecycle.

The Data Analyst will support invoicing readiness by ensuring approved billing requirements and client-specific invoicing instructions are accurately configured within Deltek and related project systems. This includes validating invoice frequency, billing contacts, payment terms, contract types, and other invoicing requirements documented during the Project Setup process. This position requires strong analytical skills, advanced Excel capabilities, experience with Deltek and Power BI, attention to detail, and the ability to work effectively with reporting systems.

• Review approved Project Setup requests for completeness and accuracy.
• Create and maintain project records within Deltek.
• Establish project structures, phases, and work breakdown structures (WBS) based on approved project documentation.
• Configure project master data, billing structures, and project attributes.
• Verify approved invoicing requirements are accurately configured within Deltek and related project systems.
• Support implementation of non-standard billing requirements and client-specific invoice instructions documented during the Project Setup process.
• Coordinate with Accounting, Operations, and Project Controls to resolve project setup and billing configuration discrepancies.
• Maintain billing-related project master data and ensure alignment between approved Project Setup records and Deltek configuration.
• Validate project setup information prior to activation.
• Maintain project setup logs and status reporting.
• Support project revisions resulting from approved scope, budget, schedule, or staffing changes.
• Ensure project data remains accurate and aligned across systems.

• Develop and maintain project and portfolio reporting.
• Support Power BI dashboard development and data validation.
• Assist with KPI tracking and reporting activities.
• Perform data quality reviews and reconciliations.
• Identify reporting trends, inconsistencies, and opportunities for process improvement.
• Validate reporting accuracy between Deltek, Power Apps, and Power BI.
• Assist with analysis and resolution of project setup or billing data discrepancies that may impact invoicing accuracy.

• Ensure project data complies with established governance standards.
• Perform periodic audits of project setup records.
• Support documentation and records management requirements.
• Assist with maintenance of data dictionaries, standards, and reporting guidance.

• Coordinate with Operations, Accounting, and Project Controls to resolve data issues.
• Support process improvement initiatives.
• Assist with training users on project setup and reporting processes.
• Provide administrative and analytical support as assigned.

• Advanced Microsoft Excel skills, including Pivot Tables, XLOOKUP or VLOOKUP, data validation, and dashboard creation.
• Experience working with enterprise systems and databases.
• Strong analytical and problem-solving skills.
• Exceptional attention to…