Business Intelligence Analyst

Aleknagik Technology, LLC is seeking to fill the role of Business Intelligence Analyst. This role will support HQ AFRC/A4 by modernizing the Command's decision‑making environment through the design, development, deployment, and sustainment of interactive analytical dashboards and real‑time data pipelines. This role requires strong technical expertise across data engineering, business intelligence visualization, and cloud analytics environments. This position is full-time, and 100% remote.

Key Responsibilities:

• Design, develop, test, and deploy interactive business intelligence dashboards using Power BI, ensuring clear visualization of operational KPIs and analytics.
• Build and maintain real‑time, high‑availability data pipelines that integrate directly with authoritative Air Force data sources (BLADE, Envision, Palantir/Foundry).
• Perform ETL/ELT transformations, advanced DAX modeling, and data structuring to support scalable analytical environments.
• Conduct ongoing data validation, cleansing, profiling, and reconciliation to ensure analytics accuracy and integrity.
• Sustain dashboard and pipeline performance through routine O&M, including index/query tuning, version control, schema updates, and responsiveness adjustments.
• Develop standardized onboarding processes for integrating new analytical workloads into the A4 portfolio, including preparing ingest standards and technical prerequisites.
• Implement UI/UX best practices to ensure intuitive, mission‑focused dashboard navigation and interpretation.
• Engineer modular, air‑gapped data models and dashboard components designed for future SIPRNet deployment.
• Provide collaborative technical support by addressing questions from users and developers regarding data availability, system access, and dashboard functionality.

Required Skills & Experience:

• Proficiency with Power BI, including data modeling, DAX, row‑level security, and visualization optimization.
• Demonstrated experience building real‑time ETL/ELT pipelines and integrating enterprise data sources.
• Strong knowledge of modern database systems, SQL, and query optimization techniques.
• Prior work with SaaS, IaaS, and PaaS cloud environments supporting analytics workloads.
• Experience applying Agile software development practices (sprints, backlog refinement, iterative delivery).
• Ability to design intuitive UI/UX components tailored for business intelligence and operational decision‑making.
• Experience producing technical documentation such as schema maps, data dictionaries, architecture diagrams, and version‑controlled source files.
• Ability to troubleshoot data quality issues and perform root‑cause analysis across pipeline and visualization layers.
• Familiarity with modular code design suitable for air‑gapped or multi‑network deployments.

Preferred Qualifications:

• Experience supporting DoD, Air Force, or federal logistics/operations data environments.
• Hands‑on experience with BLADE, Envision, or Palantir/Foundry data integration.
• Experience developing SIPR‑ready analytical products or cross-domain deployable dashboards.
• Familiarity with Flying Hours Program (FHP) analytics or aviation operations data.
• Experience onboarding complex analytical workloads into enterprise data environments.
• Background in data engineering, computer science, analytics, or related technical fields.