Consertus

• Plan, direct, coordinate, and budget all internal & external activities concerned with the management of assigned A&E projects with a proactive approach • Define scope of services for the project and identify anything that is out of scope • Manage assigned clients and expectations • Interact directly with Production Managers to ensure all client expectations are met within required timelines • Manage project activities ensuring scope, schedule, and budget are in line with both client and Consertus objectives • Coordinate sites with all third-party vendors and disciplines as required • Provide timelines and forecasts for A&E deliverables • Design Visits with clients and professionals

• Conducts regular job site visits to monitor progress, identify schedule risks, and ensure conformance with the project schedule, plans, specifications, and applicable codes and standards. • Develops, maintains, and updates the project schedule using scheduling software, including activity sequencing, milestone tracking, and critical path analysis to drive on-time project completion. • Proactively coordinates with the design and construction team to identify and resolve schedule, quality, and design conflicts, including review and approval of shop drawings. • Oversees project costs, monitors budget performance, and prepares detailed cost estimates, forecasts, and cost-to-complete analyses, implementing corrective actions to maintain financial targets. • Manages the contractor billing and change order process, including review, negotiation, and approval in accordance with contract terms. • Serves as the primary point of contact for project communications, proactively engaging stakeholders, reporting project status, and facilitating issue resolution across the team. • Owns all project documentation, ensuring accuracy, completeness, and compliance throughout the project lifecycle, and provides data analysis and reporting to senior leadership and stakeholders.

• Design and develop Power BI semantic models, dashboards, and paginated reports aligned to client requirements • Build and optimize DAX measures, Power Query (M) transformations, and row-level security • Engage with stakeholders to gather requirements and translate functional needs into technical specifications and scalable data models • Build SSRS reports and contribute to SSAS tabular model development as part of broader BI architectures • Develop and maintain ETL processes using SSIS, Power Query, Azure Data Factory, or similar tools, including data profiling and quality validation • Develop KPIs and performance metrics to support operational and strategic decision-making • Perform testing, validation, performance tuning, and support user acceptance testing (UAT) • Manage assigned tasks and workstreams across concurrent client engagements, proactively communicating progress, risks, and blockers • Demonstrate ownership of assigned deliverables, ensuring quality, timeliness, and alignment with client expectations • Participate in client-facing meetings, demos, and walkthroughs, presenting solutions clearly and professionally • Produce clear, well-structured documentation including data dictionaries, technical designs, and user guides • Contribute to internal best practices, reusable assets, and continuous improvement initiatives