Program Analyst in Colorado

CeLeen, an operating firm of Command Holdings, is currently seeking a Program Analyst for an opening on a Department of Defense contract. The individual will serve in a senior role supporting the National Guard Integration Office (NGIO) and NORAD and USNORTHCOM (N&NC). Candidates need an understanding of the organizational structure, authorities and missions of the Army and Air National Guard. Candidates should have experience working in or with the Joint Staff, a Combatant Command, the National Guard Bureau, inter-agencies and be familiar with the roles of the National Guard under both Title 10 and Title 32.

Responsibilities may include, but are not limited to:

• Research, review, write, and provide succinct products on complex issues for use by senior leaders and decision makers. Products may be in the form of information papers, point papers, decision papers, briefings, or comment resolution matrices.
• Prepare products to incorporate information...

Overview: We are looking for a highly experienced Data Specialist with hands-on experience in SQL (ideally MS Sql Server/Google Big Query), Data Warehousing, and designing and writing code for ETL processes in Python.

Primary Responsibilities:

• Refine Data Warehouse Model.
• Improve existing Python ETL (Extract, Transform, Load) code.
• Work with business teams to identify data reporting requirements.

Required Experience:

• Data Modeling
• Proficiency in SQL, ideally with experience in MS SQL Server and Google BigQuery.
• Hands-on experience in Python ETL coding.
• Familiarity with Python libraries such as Pandas, SqlAlchemy, etc.
• Experience with ETL tools such as Airflow, NiFi, dbt, or similar.

Desired Experience:

• Knowledge of Google Cloud Platform (GCP) services.
• Familiarity with Data Warehouse methodologies like Inmon, Kimball, or Data Vault.
...