Application Guide

How to Apply for Project Controls / EVM Administrator

at Gem Technologies

🏢 About Gem Technologies

Gem Technologies is a key contractor supporting the Los Alamos National Laboratory (LANL), a premier national security laboratory. Working here offers the chance to contribute to critical missions in a remote-friendly environment with occasional travel to New Mexico.

About This Role

This role combines project controls and database administration, overseeing cost and schedule management using tools like Primavera P6 and Cobra. You'll also serve as a SQL Server DBA and develop automated reporting solutions, directly impacting project efficiency and decision-making at LANL.

💡 A Day in the Life

Your day might start with checking SQL Server health and running scheduled queries for data integration. You could then update Primavera P6 schedules, review cost data in Cobra, and build a Power BI dashboard for a project review. Later, you might troubleshoot a slow query or collaborate with stakeholders to refine reporting requirements.

🚀 Application Tools

Generate Cover Letter

AI-powered, tailored for Gem Technologies

Interview Prep

Practice questions for this role

🎯 Who Gem Technologies Is Looking For

  • Experienced in EVMS and cost/schedule integration with tools like Primavera P6 and Cobra, preferably in a government or DOE context.
  • Proficient in SQL Server administration (DBA tasks) and writing complex PSQL/TSQL queries for data extraction and integration.
  • Skilled in building automated tools with Excel VBA, Power Query, and Power BI dashboards for executive reporting.
  • A proactive problem-solver who anticipates needs, works independently, and communicates effectively with technical and business stakeholders.

📝 Tips for Applying to Gem Technologies

1

Highlight any experience with Los Alamos National Laboratory or other DOE labs in your resume and cover letter.

2

Emphasize hands-on SQL Server DBA experience, including configuration, maintenance, and performance tuning.

3

Showcase specific examples of Power BI dashboards or automated tools you've built, with measurable impact.

4

Mention your ability to work with minimal oversight and define requirements independently, as the role requires proactive initiative.

5

Tailor your resume to include keywords like 'Primavera P6', 'Cobra', 'EVMS', 'SQL Server', 'Power BI' to pass ATS filters.

✉️ What to Emphasize in Your Cover Letter

['Your experience with EVMS and cost/schedule control in a government or large-scale project environment.', 'Your technical skills in SQL Server administration and query optimization, with examples of complex queries.', 'Your ability to develop automated reporting solutions that improved efficiency or decision-making.', 'Your proactive approach to identifying and solving problems without explicit direction.']

Generate Cover Letter →

🔍 Research Before Applying

To stand out, make sure you've researched:

  • → Familiarize yourself with Los Alamos National Laboratory's mission and current projects, especially in nuclear security.
  • → Learn about Gem Technologies' role as a contractor and any recent contracts or news.
  • → Review EVMS standards (e.g., ANSI/EIA-748) and how they apply to DOE projects.
  • → Understand the specific tools mentioned (Cobra, Primavera P6, Power BI) and their typical usage in project controls.

💬 Prepare for These Interview Topics

Based on this role, you may be asked about:

1 Describe your experience with Primavera P6 and Cobra integration for EVMS compliance.
2 How have you optimized a slow SQL query or resolved a database performance issue?
3 Walk us through a Power BI dashboard you built from scratch, including data sources and design choices.
4 Give an example of a time you anticipated a customer's need and developed a solution proactively.
5 How do you ensure data quality and accuracy in project controls and reporting?
Practice Interview Questions →

⚠️ Common Mistakes to Avoid

  • Failing to demonstrate specific experience with both cost and schedule tools (P6 and Cobra) – don't just list them, show depth.
  • Not highlighting SQL Server DBA skills – this is a key differentiator; generic database experience won't suffice.
  • Submitting a generic cover letter that doesn't mention LANL or DOE project controls – tailor it to this role.

📅 Application Timeline

This position is open until filled. However, we recommend applying as soon as possible as roles at mission-driven organizations tend to fill quickly.

Typical hiring timeline:

1

Application Review

1-2 weeks

2

Initial Screening

Phone call or written assessment

3

Interviews

1-2 rounds, usually virtual

✓

Offer

Congratulations!

Ready to Apply?

Good luck with your application to Gem Technologies!

← Back to Job Listing Apply Now →