AI Productivity & Power BI Lead

Role Description

Astrion has an exciting opportunity for a highly experienced builder to run AI productivity and executive Power BI for Astrion. You will deploy AI against our highest-cycle, highest-volume processes, design the executive dashboards leadership uses to run the business, and stand up the data integration and governance that make both possible.

This is a hands-on builder role. You will ship working software, not slideware. You will sit with department leaders, scope a tool, ship working drafts, and iterate from there. You will own data models, agent architectures, refresh schedules, security labels, and the documentation a teammate could pick up cold and run with.

Qualifications

• Bachelor’s in Computer Science, Engineering, or equivalent technical field. An advanced degree is welcomed but not required if your track record is exceptional.
• 10+ years of total experience, with at least 5 years as a hands-on builder of enterprise-grade software, automation, or AI systems. Current coding proficiency is non-negotiable.
• Expert-level Power BI mastery: Power BI Desktop, Power BI Service, DAX, Power Query (M), dataflows, paginated reports, row-level security, and embedded executive scorecards.
• Deep applied AI fluency. Production experience with LLMs, agentic frameworks, retrieval-augmented generation, prompt engineering, evals, MCP, vector databases, and at least one major AI platform (Azure OpenAI, AWS Bedrock, Anthropic, OpenAI).
• Strong full-stack programming skills. Python, TypeScript and React, SQL, REST and GraphQL APIs, and modern cloud infrastructure. Microsoft and Azure ecosystem fluency strongly preferred.
• Demonstrated ability to integrate enterprise back-end systems via APIs, iPaaS, Microsoft Fabric, Power Automate, Dataverse, ETL and ELT, or equivalent.
• Cross-functional business fluency. You have built and shipped tools used by Finance, HR, Sales and BD, Legal, IT, or Operations leaders.
• A track record applying human-interface and UX-design rigor to internal tools, with measurable adoption outcomes.
• U.S. citizenship and eligibility to obtain a U.S. Government security clearance. Secret minimum, with TS and SCI eligibility preferred.

Requirements

• Experience inside a defense, aerospace, or other regulated industry, with awareness of CMMC, ITAR, FedRAMP, or equivalent regimes.
• Experience scaling AI productivity inside a private-equity-backed company with an active value-creation plan.
• Deep experience with Microsoft Copilot Studio, Copilot for M365, Copilot agents, Microsoft Fabric, and the broader Microsoft AI and data stack.
• Microsoft Power Platform certifications (PL-300, PL-400, PL-500, PL-600).
• Prior experience embedded with executive teams and comfort presenting at the board level.
• Familiarity with enterprise ERP, CRM, and HCM systems used in defense back-office environments, capture and BD tools, and Shipley-aligned proposal automation.
• Prior leadership of a small, high-leverage team of engineers, BI developers, or automation specialists.

Responsibilities

• Architect and deploy AI-powered automation across corporate and operational functions, prioritizing high-cycle, high-volume, high-error processes including financial close, capture and proposal, contracts review, recruiting, onboarding, IT ticketing, and M&A pipeline operations.
• Design, build, and continuously evolve Astrion’s executive Power BI dashboards fed by live feeds across Astrion Business Systems, contracts and BD pipelines, M&A target trackers, and operational KPIs.
• Stand up the live data integration backbone that connects Astrion Business Systems via APIs, Power BI dataflows, Microsoft Fabric, Power Automate, Dataverse, and custom pipelines where required.
• Identify, evaluate, pilot, and roll out the right AI tool for the right business function.
• Build internal LLM-based agents and retrieval-augmented generation systems on Astrion’s HR, contract, proposal, and operational program performance data.
• Apply human-interface and UX-design discipline to every internal tool. Adoption, latency, friction, and trust are first-class success metrics, not afterthoughts.
• Establish and enforce AI governance. Data classification, model risk, IP and CUI protection, audit logging, and alignment with CMMC, ITAR, and FedRAMP-adjacent posture.
• Run a quarterly AI productivity portfolio review with the executive team, sequencing initiatives by labor leverage and EBITDA impact.
• Partner directly with the executive team to translate functional pain into shipped, measured tools.
• Contribute to customer-facing platform offerings as Astrion’s MOSA-compliant software and integration platform matures.

Benefits

• Mission that matters. Your work informs decisions that shape national security programs.
• Builder culture. We ship working software, not slideware. Prototypes are how we communicate.
• Direct executive access. Your work is read weekly by the people running the company.
• Modern stack. Microsoft Fabric, Power Platform, and an AI-forward roadmap that keeps your skills current.
• Competitive total compensation, full medical and dental, 401(k) with company match, paid time off, and tuition assistance.