Data Engineer - Database Analyst/Programmer - Senior
Role Overview:
We are seeking skilled professionals to join our Arch OPEN Consultant program in the roles of Database Analyst / Programmer – Senior, Data Engineer, and Application Programmer. These roles are integral to designing secure data architectures, building integration pipelines, and developing enterprise applications aligned with USMA mission needs. Candidates will work closely with cross-functional teams to ensure data integrity, security compliance, and application performance.
Detailed Responsibilities:
Database Analyst / Programmer – Senior
Design and manage Dataverse schemas and perform data migrations.
Ensure database performance, integrity, and security.
Validate migration reports and align data models with USMA mission requirements.
Deliver migration validation, optimization, and compliance audit reports.
Data Engineer
Develop and maintain real-time, bi-directional data pipelines between AMS, Azimuth Dataverse, Canvas LTI, and Slate Admissions.
Consolidate multiple data sources into the new platform.
Create dashboards to monitor data flow and system performance.
Deliver integration workflows, ETL documentation, and operational dashboards.
Application Programmer
Build and deploy Power Apps (Canvas & Model-driven), custom connectors, and APIs.
Implement role-based access control (RBAC) and ensure compliance with NIST Secure Software Development Framework.
Deploy academic, cadet, and tactical officer information systems.
Deliver source code repositories, deployment artifacts, and system documentation.
Required Certifications:
Mandatory (for all roles): DoD 8140 IAT Level II (Security+ CE or equivalent)
Database Analyst / Programmer – Senior: Microsoft Certified: Customer Data Platform Specialty (MB-260)
Data Engineer: (Optional) Microsoft Certified: Azure Data Engineer Associate (DP-203)
Application Programmer:
Microsoft Certified: Power Platform Developer Associate (PL-400)
Microsoft Certified: Azure Developer Associate (AZ-204)
DoD 8140 IAT Level II or III
Job Type: Contract
Pay: Up to $50.00 per hour
Security clearance:
Confidential (Required)
Work Location: Remote