Data Solutions Architect II

Cape Henry Associates, Acquired by JANUS Research Group; Ozark (AL); On-site; USD 105,000 - 110,000; Full time

Job summary

JANUS Research Group seeks a Data Solutions Architect II to design and implement scalable data solutions for Army Aviation modernization. You will work with stakeholders to build connected data environments using SharePoint, Power Platform, and Power BI, improving quality, accessibility, and interoperability.

The role emphasizes hands-on data architecture, governance, and enterprise integration readiness, with security clearances required and collaboration across government teams.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or related technical discipline.
• 3–5 years of experience in data integration, BI, systems integration, or app development.
• Experience with SharePoint, Power BI, Power Query, or Power Platform.
• Knowledge of relational databases, SQL, data transformation, and integration techniques.
• Ability to translate user requirements into functional technical solutions.

Responsibilities

• Design and maintain data structures, relationships, and information flows to support modernization and requirements-management.
• Consolidate information from spreadsheets, SharePoint, databases, and other sources.
• Develop data models and integration approaches to improve interoperability and sharing.
• Support data mapping and integration planning for Army Vantage or similar environments.

Skills

Data modeling

Data integration

SQL

Power BI

SharePoint

Education

Bachelor's degree in CS/IS/Data Analytics

Tools

SharePoint

Power BI

Power Platform

SQL

Power Query

Job description

Candidates must have an active Secret clearance and verify, before applying, that you meet the minimum requirements of the position.

Target salary range: $105k - $110k. The estimate displayed represents the typical salary range for this position based on experience and other factors.

JANUS Research Group is seeking a Data Solutions Architect II to support the Army Aviation Future Capability Directorate (A-FCD) at Fort Rucker, Alabama. The position will focus on designing and implementing practical, scalable data solutions that improve the Directorate’s ability to collect, manage, integrate, analyze, and visualize aviation modernization and capability-development information.

The successful candidate will work closely with Government stakeholders, aviation analysts, and a SharePoint Data Integration Specialist to establish connected data environments using Microsoft SharePoint, Power Platform, Power BI, and other Government-approved systems.

A key objective is to improve data quality, accessibility, and interoperability while supporting future integration with Army enterprise data environments, particularly Army Vantage. This is a hands-on, intermediate-level technical position.

Key Responsibilities

Data Architecture and Integration

• Design and maintain data structures, relationships, and information flows supporting A-FCD modernization and requirements-management activities.
• Identify opportunities to consolidate information from spreadsheets, SharePoint repositories, databases, and other authorized sources.
• Develop data models and integration approaches to improve interoperability, reduce duplication, and support enterprise data sharing.
• Support data mapping and integration planning for Army Vantage or other Army-approved environments as access and interfaces become available.

Application Development and Analytics

• Design and implement practical solutions using Microsoft Power Platform, Power BI, SharePoint, and related technologies.
• Develop automated workflows, reporting capabilities, and leadership dashboards.
• Support data-collection tools and applications for tracking capability requirements, modernization initiatives, and program activities.
• Coordinate with data integration personnel to ensure consistent structures and reliable reporting.

Enterprise Integration and Vantage Readiness

• Assess existing repositories and recommend improvements to organization, standardization, and accessibility.
• Develop integration strategies that support A-FCD’s transition toward enterprise data architectures and Army Vantage.
• Apply foundational data modeling, ontology, and metadata concepts where relevant to approved enterprise integration requirements.
• Coordinate with authorized Army enterprise platform administrators and technical stakeholders on data exchange, access and integration requirements.

Data Governance and Quality

• Establish practical standards for data quality, traceability, metadata, and documentation.
• Support identification and management of authoritative data sources.
• Develop data validation and quality-control procedures to improve confidence in analytical products.
• Incorporate appropriate information safeguards and access controls into proposed solutions.

Stakeholder Engagement

• Collaborate with Army Aviation analysts and Government personnel to understand operational processes and information requirements.
• Translate functional requirements into practical technical solutions.
• Present proposed architectures, integration approaches, and completed products to technical and nontechnical stakeholders.
• Document technical designs, data relationships, workflows, and maintenance procedures.

Required Qualifications

Education

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related technical discipline.
• Equivalent relevant professional experience may be considered consistent with applicable contract labor-category requirements.

Experience

• 3-5 years of progressively responsible experience in data integration, business intelligence, systems integration, or application development.
• Hands-on experience designing and implementing data models, reporting solutions, or automated workflows.
• Experience with Microsoft SharePoint, Power BI, Power Query, or Power Platform.
• Working knowledge of relational databases, SQL, data transformation, and integration techniques.
• Ability to translate user requirements into functional technical solutions and clearly document the resulting architecture.
• Demonstrated analytical, communication, and problem-solving skills.

Security

• Ability to meet security clearance and access requirements established by the task order and applicable DD254.

Preferred Qualifications

• Experience with Army Vantage, Palantir Foundry, or comparable enterprise data platforms.
• Familiarity with ontology concepts, metadata management, and enterprise data architecture.
• Experience with Python, Azure data services, or API-based integrations.
• Familiarity with Army capability development, modernization, requirements management, or defense acquisition processes.
• Experience developing dashboards and applications for Government or defense customers.
• Familiarity with DoD information security, data governance, and controlled information requirements.

Desired Professional Attributes A technically capable, collaborative problem solver who works independently without extensive supervision; is comfortable learning Army operational processes; and can translate fragmented information requirements into practical, sustainable technical solutions. Emphasis is on useful, maintainable capabilities rather than unnecessarily complex architectures.

JANUS strives to provide opportunities for career growth through training and development. We also offer an attractive comprehensive benefit package to include health and welfare plans and financial products. As part of a total rewards program, employees can benefit from our referral bonus program, and other various employee awards.

JANUS Research Group provides reasonable accommodation so that qualified applicants with a disability may participate in the selection process. Please advise us of any accommodations you request to express interest in a position by e-mailing: Judy Pagac, Chief Human Resources Officer at [e-mail] or calling [phone]. Please state your request for assistance in your message. Only reasonable accommodation requests related to applying for a specific position within JANUS Research Group will be reviewed at the e‑mail address and phone number supplied. Thank you for considering a career with JANUS Research Group.

E-Verify

JANUS Research Group participates in the Electronic Employment Verification Program.

JANUS Research Group is an equal opportunity/ affirmative action employer. It is company policy to provide equal opportunity in all areas of employment practice without regard to race, color, religion, sex, sexual orientation, national origin, age, marital status, veteran status, citizenship, or disability.

This contractor and subcontractor shall abide by the requirements of 41 CFR 60-1.4(a), 60-300.5(a) and 60-741.5(a). These regulations prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on race, color, religion, sex, or national origin. Moreover, these regulations require that covered prime contractors and subcontractors take affirmative action to employ and advance in employment qualified individuals without regard to race, color, religion, sex, national origin, protected veteran status or disability.

Great Place to Work