Unified Technologies

• Develop, update, and maintain cybersecurity policies, SOPs, and related documentation for IT systems. • Ensure all documentation aligns with NIST SP 800-53 security controls and RMF requirements. • Collaborate with system owners, ISSOs, stakeholders and IT system support teams to gather technical and procedural information required for test results and documentation. • Input and manage control test results and system security documentation within the Enterprise Mission Assurance Support Service (eMASS) system. • Support the preparation of Assessment and Authorization (A&A) packages within eMASS. • Track and report on documentation status, updates, and compliance metrics. • Assist in internal audits and inspections to ensure documentation meets regulatory and operational standards. • Provide training and guidance on policy and SOP development to technical teams

• Assist with an ongoing effort to converge legacy systems onto existing system’s Azure PaaS cloud environment. • Help architect a common data model and establish data pipelines. • Implement ETL solutions and create SQL views, stored procedures, and functions as needed. • Work with a team that follows the Scrum Agile framework. • Perform data engineering work including implementing ETL solutions and creating data architecture documentation. • Document architecture and SOPs, processes, data flows, and technical decisions for internal and client use. • Assist in designing and implementing ETL pipelines using Azure cloud tools including Data Factory and Logic Apps. • Support data ingestion from structured and unstructured sources.

• Provide support for the Army's Headquarters Installation Information System (HQIIS) by extracting, modeling, and validating data with SQL, Python, and Power BI to deliver decision-ready reporting. • Identify process gaps and plan, build, and deploy low-code solutions on Microsoft Power Platform, including Power Apps, Power Automate, and Dataverse, to reduce manual work and improve data quality. • Responsibilities include designing secure datasets and DAX models, developing ETL routines, integrating on-prem and cloud sources through the data gateway, and implementing row-level security and incremental refresh. • Document business rules, produce clear user guides, brief findings and recommendations to installations, and train users to adopt BI and Power Platform solutions. • Build Power BI datasets, models, and dashboards using DAX and Power Query to drive decisions. • Write advanced SQL and Python for ETL, data validation, API ingestion, and automation. • Design, plan, and deliver low-code apps on Microsoft Power Platform: Power Apps (canvas and model-driven), Power Automate flows, and Dataverse schemas and roles. • Configure row-level security (RLS), incremental refresh, and performance tuning in Power BI. • Integrate on-prem and cloud sources via the on-premises data gateway and standard or custom connectors. • Collect, organize, and maintain governed datasets and documentation following best practices. • Assemble large, complex data sets aligned to business rules with built-in QA/QC checks. • Identify and prioritize process improvement opportunities; automate recurring tasks to reduce manual work. • Create ad hoc reports and self-service analytics from SQL Server, SharePoint, Excel, and other sources. • Establish environment and DLP guardrails; monitor usage, access, and data movement. • Create concise user guides and job aids; train users on Power BI and Power Platform solutions. • Organize and brief findings and recommendations to government and installation stakeholders. • Support data quality remediation by codifying business rules in SQL, DAX, and Python.

• API Design & Development: Architect, build, and document RESTful and/or GraphQL APIs. Focus on best practices for versioning, authentication, security, and performance within enterprise environments. • Full Stack Development: Develop frontend and backend solutions, leveraging preferred technologies such as .NET, Angular, and MSSQL for web applications. Ensure smooth integration of user interfaces, business logic, and data layers. • Agile Iteration: Embrace agile methodologies, rapidly incorporating feedback and evolving requirements. Support flexible, easily modifiable code for fast pivots and enhancements. • DevOps & Collaboration: Prefer experience with Azure DevOps for pipeline automation and project management, Visual Studio and VS Code for development, GitLab for version control and CI/CD, and JIRA for agile workflow and issue tracking. Confluence for documentation and collaboration is also valued. • Database & Management: Prefer experience with MS SQL as a primary database technology, along with proficiency in Management Studio (SSMS) for database administration and development. • Documentation: Produce concise technical documentation and foster knowledge sharing within agile teams.