Negotiable
Outside
Remote
USA
Summary: The role encompasses positions for Database Analyst/Programmer Senior, Data Engineer, and Application Programmer within the Arch OPEN Consultant program. These professionals will be responsible for designing secure data architectures, building integration pipelines, and developing applications that meet USMA mission needs. Collaboration with cross-functional teams is essential to ensure data integrity and compliance. Candidates must possess relevant certifications and skills to fulfill these responsibilities effectively.
Key Responsibilities:
- 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.
- 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.
- 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.
Key Skills:
- DoD 8140 IAT Level II (Security+ CE or equivalent)
- Microsoft Certified: Customer Data Platform Specialty (MB-260)
- Microsoft Certified: Azure Data Engineer Associate (DP-203) (Optional)
- Microsoft Certified: Power Platform Developer Associate (PL-400)
- Microsoft Certified: Azure Developer Associate (AZ-204)
- DoD 8140 IAT Level II or III
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Job description:
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