Project Controls / EVM Administrator

GEM Technologies, Inc.

2d•Remote

About The Position

We are seeking a Project Controls / EVM Administrator to join our team supporting the Los Alamos National Laboratory! This position is full-time and will be primarily remote with occasional travel to Los Alamos, New Mexico (less than 25% of the time). Responsibilities Support project scheduling using Primavera P6, including data quality checks, integration tasks, and schedule analysis. Support project cost management using Cobra and EVMS processes. Write and optimize PSQL and TSQL queries to extract and integrate data from multiple enterprise systems. Serve as a SQL Server DBA resource, providing database configuration, maintenance, and performance tuning. Develop automated tools using Excel, VBA, Power Query, and Power Pivot. Build and maintain Power BI dashboards and data models for project and executive audiences. Anticipate customer needs by observing workflows, identifying pain points, and proactively developing solutions. Deliver high-quality tools and reports with minimal oversight, often defining requirements through your own analysis and initiative. Collaborate with stakeholders across technical and business domains to align solutions with project objectives. Requirements Education & Years of Experience – Bachelor’s Degree and 8+ years of relevant experience; additional, relevant experience may be considered in lieu of a degree. Citizenship – To be considered, you must be a United States (U.S.) citizen due to the federal nature of the work. Clearance – To be considered, you must be able to obtain and maintain a government issued clearance, if needed. Hands-on experience with Primavera P6, Cobra, and EVMS processes. Strong SQL skills, including proficiency in PSQL/TSQL and working with system databases. Experience with SQL Server administration (DBA tasks, maintenance, optimization). Advanced proficiency in Excel, including VBA, Power Query, and Power Pivot. Experience building data models and dashboards in Power BI. Exceptional ability to translate ambiguous or unspoken needs into actionable, effective solutions. Demonstrated initiative and independence—able to take a concept from idea to delivered product without heavy direction. Strong communication skills across both technical and business contexts. Experience in project controls within DOE/NNSA. Familiarity with data integration and ETL workflows across enterprise systems. Strong analytical and problem-solving skills with a continuous-improvement mindset. About the Site The NNSA's Los Alamos National Laboratory (LANL), located in Los Alamos, New Mexico, is a design laboratory responsible for the safety and reliability of the nuclear explosives package in nuclear weapons. This lab possesses unique capabilities in neutron scattering, enhanced surveillance, radiography, and plutonium science and engineering (energy.gov). ABOUT GEM GEM Technologies, Inc. (GEM) is an award-winning federal contractor with more than 30 years of experience providing environmental, construction, facility management, and technical services to federal agencies, state and local governments, and commercial organizations. Founded in 1994 as a nuclear engineering firm to support federal operations in East Tennessee, GEM has since expanded into a nationwide, multi-disciplinary provider with over 270 employees and a diverse portfolio of contracts in the environmental, nuclear, and defense sectors. Some reasons to join GEM are: Our philosophy – We believe in the power of effective collaboration and recognize that good partnerships are the building blocks to success. Our relationships – Partnering with federal clients, we solve complex problems, exceed expectations, and advance critical missions. Our team – We are committed to managing a cohesive workforce and cultivating a supportive workplace for our employees on contracts and in-office. Our community involvement – Supporting our communities, we invest time and money in local schools and non-profit organizations. COMPENSATION AND BENEFITS GEM’s offered compensation is dependent on candidates’ education, qualifications, and relevant years of experience. To recruit and retain our exceptional staff, we offer the opportunity to elect benefit packages that best suit our employee’s needs; this includes, but is not limited to, a competitive Salary, Medical, Dental and Vision Insurance (including HSA & PPO options), Paid Time Off (PTO), Paid Holidays, Life Insurance, and a matching 401(k) Retirement Plan. Please Note: With the exception of mandated state requirements, GEM does not publish salary information on external job boards; as such, most ranges listed are estimates made by vendors and not actual salary ranges. EQUAL OPPORTUNITY EMPLOYER GEM Technologies, Inc. is an Equal Opportunity/Affirmative Action Employer and does not discriminate on the basis of race, gender, sexual orientation, gender identity/expression, national origin, disability, age, genetic information, veteran status, marital status, pregnancy or related condition, or any other basis protected by law.

Requirements

Education & Years of Experience – Bachelor’s Degree and 8+ years of relevant experience; additional, relevant experience may be considered in lieu of a degree.
Citizenship – To be considered, you must be a United States (U.S.) citizen due to the federal nature of the work.
Clearance – To be considered, you must be able to obtain and maintain a government issued clearance, if needed.
Hands-on experience with Primavera P6, Cobra, and EVMS processes.
Strong SQL skills, including proficiency in PSQL/TSQL and working with system databases.
Experience with SQL Server administration (DBA tasks, maintenance, optimization).
Advanced proficiency in Excel, including VBA, Power Query, and Power Pivot.
Experience building data models and dashboards in Power BI.
Exceptional ability to translate ambiguous or unspoken needs into actionable, effective solutions.
Demonstrated initiative and independence—able to take a concept from idea to delivered product without heavy direction.
Strong communication skills across both technical and business contexts.
Experience in project controls within DOE/NNSA.
Familiarity with data integration and ETL workflows across enterprise systems.
Strong analytical and problem-solving skills with a continuous-improvement mindset.

Responsibilities

Support project scheduling using Primavera P6, including data quality checks, integration tasks, and schedule analysis.
Support project cost management using Cobra and EVMS processes.
Write and optimize PSQL and TSQL queries to extract and integrate data from multiple enterprise systems.
Serve as a SQL Server DBA resource, providing database configuration, maintenance, and performance tuning.
Develop automated tools using Excel, VBA, Power Query, and Power Pivot.
Build and maintain Power BI dashboards and data models for project and executive audiences.
Anticipate customer needs by observing workflows, identifying pain points, and proactively developing solutions.
Deliver high-quality tools and reports with minimal oversight, often defining requirements through your own analysis and initiative.
Collaborate with stakeholders across technical and business domains to align solutions with project objectives.