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