Jobs at Consertus, Inc.

Support PG&E electric transmission and distribution substation projects by developing and maintaining resource-loaded schedules, cash flow and forecast plans, and monthly budgets. Prepare cost and performance reports, analyze variances, maintain project documentation (EDMS), and communicate schedule, cost, and risk status to stakeholders. Use Primavera P6 and SAP systems to monitor progress and forecast accuracy, support change control, and assist Project Managers with financial and closeout tasks.

Design, develop, and maintain Power BI semantic models, dashboards, paginated and SSRS reports. Build DAX, Power Query transformations, ETL processes (SSIS/Azure Data Factory), and semantic/tabular models. Engage stakeholders, perform testing/UAT, document solutions, tune performance, and support multiple client engagements in a consulting environment.

Develop and implement project-specific EHS plans, conduct site inspections and audits, coordinate corrective actions, provide EHS training, maintain documentation, and liaise with regulators, contractors, and project teams to ensure compliance and continuous improvement.

Design, build, and maintain scalable ETL pipelines, data warehouses, and data models. Develop SQL and Python backend processing, ensure data quality, integrate multiple sources (APIs, files), optimize performance, document solutions, and collaborate with stakeholders in a client-facing consulting environment.

Lead global entity management and corporate governance for U.S. and international entities, ensure compliance and good standing, maintain organizational data, prepare board/shareholder documents, support M&A and restructuring diligence, coordinate with tax/finance/outside counsel, improve entity-management processes and technology, and serve as primary contact for registered agents and regulators.

Support development and maintenance of integrations, ETL pipelines, and reporting that connect Salesforce, Workday, and Deltek to a Google Cloud data environment. Work with Airflow, dbt, BigQuery, Cloud Run, and Power BI; assist with APIs, ODBC ingestion, logging, monitoring, and code reviews while learning under senior engineers.

Support consulting engagements by gathering and analyzing business requirements, translating them into functional specifications, building dashboards, recommending process and technology optimizations, training users, and providing post-implementation support while collaborating with clients and internal teams to deliver improvement initiatives.

Provide frontline IT help desk support for LAX staff: troubleshoot hardware/software and network issues, manage tickets in Freshdesk/ServiceNow, perform onboarding/offboarding, deploy hardware, support relocations and events, and deliver end-user training.

Design, develop, and maintain Power BI semantic models, dashboards, and paginated/SSRS reports. Build DAX measures and Power Query transforms, develop ETL (SSIS/Azure Data Factory), tune SQL/T-SQL, implement row-level security, support UAT, and engage with clients to translate requirements into scalable BI solutions and documentation.

Lead full lifecycle construction projects for life sciences, pharmaceutical, and research facilities, managing budgets, schedules, procurement, compliance, client/vendor relationships, and mentoring project teams to deliver on schedule, budget, and quality.

Lead cost management and program controls for healthcare capital projects. Own budgets, forecasts (EAC), cash flow, change control, and cost reporting. Reconcile contractor reports, develop risk/contingency registers, validate pay applications, and produce executive-ready cost narratives. Integrate cost, schedule, and risk with stakeholders, drive governance and audit-ready processes, and support project closeout and continuous process improvement across a multi-project portfolio.

Support restoration inspection group by managing and retrieving archived project documentation, assembling completed records, performing data entry for project tracking (Excel and Primavera V6), preparing correspondence and progress reports, and coordinating files for construction management and operations teams.

Manage planning, design, and construction activities for small-to-medium capital projects, overseeing cost, schedule, quality, contract administration, client relations, and project close-out. Perform on-site inspections, prepare cost estimates and reports, coordinate permits and contractor billing, and support business development as needed.

Lead development and oversight of detailed project schedules, manage cost estimating for large complex projects, perform risk and escalation analyses, prepare and analyze construction claims, and mentor estimators while collaborating with project teams and Norfolk Airport Authority.

Lead program controls and execution oversight for large-scale infrastructure developments. Manage schedule, cost, forecasting, risk, change control, and critical deliverables. Advise and present to C‑suite, coordinate cross-functional teams and external partners, and improve governance and execution discipline for a major development program.

Support construction management teams by maintaining contract/document control systems, tracking RFIs/submittals/NCRs, coordinating meetings and stakeholders, assisting with cost/change/pay applications, maintaining construction logs and as-built records, and supporting project close-out and administrative tasks.

Prepare conceptual through construction-phase electrical cost estimates, perform detailed quantity take-offs, develop unit pricing using databases and subcontractor input, coordinate across disciplines, support value engineering, evaluate bids and change orders, and maintain BOE and QA/QC documentation for electrical systems.

Lead planning, execution, and delivery of construction and facility capital projects within GMP-regulated pharmaceutical environments. Manage scopes, budgets, schedules, risk registers, change controls, and documentation; coordinate engineering, validation, quality, EHS, procurement, and contractors; ensure FDA/GMP/OSHA compliance; oversee site walks, commissioning, qualification, and turnover; and drive continuous improvement in project workflows and contractor management.

Lead planning, execution, and delivery of construction, facility, utilities, and infrastructure projects in GMP-regulated pharmaceutical sites. Manage scopes, budgets, schedules, risk, change control, documentation, commissioning/qualification, contractor oversight, safety audits, and cross-functional stakeholder coordination to ensure compliance with FDA, GMP, OSHA, and site quality standards.

Develop detailed mechanical cost estimates (HVAC, plumbing, fire protection, site utilities) across design phases. Perform quantity take-offs, unit pricing using databases and subcontractor input, prepare BOE and backup, coordinate with design teams, support value engineering, QA/QC, bid evaluation, and maintain estimate documentation. Periodic travel for site visits and client meetings.