AI Productivity & Power BI Lead

Astrion$120K — $150K *
US-AnywhereRemote in Washington, DC
Enterprise Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor’s in Computer Science, Engineering, or a related technical field; advanced degree preferred for exceptional candidates.
  • Over 10 years of experience; at least 5 years as a hands-on builder of enterprise-grade software, automation, or AI systems.
  • Expert-level proficiency in Power BI, including DAX, Power Query, and designing executive-grade environments.
  • Deep applied AI expertise with production experience in LLMs and major AI platforms such as Azure OpenAI or AWS Bedrock.
  • Strong full-stack programming skills in Python, TypeScript, SQL, and modern cloud infrastructure; Microsoft Azure fluency preferred.
  • Experience integrating enterprise back-end systems via APIs and Microsoft solutions like Power Automate and Dataverse.
  • Cross-functional business fluency with tools used across Finance, HR, IT, and other departments.

Responsibilities

  • Architect and deploy AI automation for high-volume, error-prone processes like financial close and IT ticketing.
  • Design and build executive Power BI dashboards with live data feeds from various business systems.
  • Establish a live data integration system using APIs and Microsoft technologies to connect internal systems.
  • Evaluate and implement effective AI tools tailored for specific business functions.
  • Develop internal LLM-based agents and secure self-service systems for HR and operational data access.
  • Apply UX-design best practices to ensure high adoption rates and low-friction internal tools.
  • Enforce AI governance, ensuring data protection and compliance with industry standards.

Benefits

  • Remote work flexibility with full-time employment status.
  • Opportunity to lead innovative AI and BI initiatives in a hands-on role.
  • Engagement with executive leadership and direct impact on positive business outcomes.
  • Access to cutting-edge technologies and the chance to shape AI applications within the company.
Full Job Description
Overview

AI Productivity & Power BI Lead

LOCATION: Remote U.S.

JOB STATUS:Full-time

CLEARANCE: Active Secret (TS w/SCI eligibility preferred)

TRAVEL:As Needed

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.

REQUIRED QUALIFICATIONS / SKILLS

  • Bachelors 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. You have shipped large, executive-grade Power BI environments at scale.

  • 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. You connect source systems into live data feeds, not static reports.

  • Cross-functional business fluency. You have built and shipped tools used by Finance, HR, Sales and BD, Legal, IT, or Operations leaders, and can speak fluently to functional executives in their own language.

  • 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.

PREFERRED QUALIFICATIONS / SKILLS

  • 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 Astrions 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. Maintain a living map of best-in-class point solutions and embedded copilots across Finance, HR, BD and capture, Legal, IT and security, Engineering, and Marketing and communications.

  • Build internal LLM-based agents and retrieval-augmented generation systems on Astrions HR, contract, proposal, and operational program performance data. Deliver secure, auditable, role-aware self-service for employees.

  • 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 Astrions MOSA-compliant software and integration platform matures.

About Astrion

Astrion Careers

Joining Astrion presents an unparalleled opportunity to become part of a leading team of professionals dedicated to pioneering innovation and digital transformation. Astrion, a beacon in the tech industry, offers a variety of job opportunities that cater to ambitious individuals eager to drive change and lead industries forward.

Work That Matters

At Astrion, every position is a chance to collaborate with some of the brightest minds in technology and business. The company helps the world’s most renowned companies navigate their digital transformation journeys, leveraging a unique blend of industry expertise and technological innovation.

Explore Job Opportunities and Internships

Astrion is constantly seeking passionate, curious, and creative individuals to join its team. Whether looking for full-time employment or an internship, Astrion provides a platform to develop professional skills, engage in meaningful networking, and contribute to impactful projects. Explore the myriad of positions available and find where your skills can help shape the future of technology.

Innovative Work Environment

Astrion fosters a culture of innovation where team members from diverse backgrounds come together to solve complex challenges. The company is committed to diversity training and leadership development, ensuring that all team members have the opportunity for personal and professional growth.

Benefits and Growth

Astrion is dedicated to the growth of its team members, offering substantial benefits and resources to support career advancement. This includes comprehensive health benefits, leadership training programs, and opportunities for professional development. Astrion’s commitment to career growth ensures that every team member has the resources to reach their full potential.

Join the Astrion Team

Astrion is hiring! Search open positions that match your skills and interests. The company looks for driven, solution-oriented team players. Prepare your resume, refine your interview skills, and get ready to join a team that values leadership and professional growth.

Stay Connected with Astrion Careers

Keep up to date with career tips, insider perspectives, and industry-leading insights—all from the professionals who are part of Astrion. Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities that await at Astrion.

Networking and Professional Development

Astrion values the power of networking and encourages its team to engage in events and activities that foster professional connections. This commitment to networking is integral to maintaining a vibrant, innovative, and inclusive workplace.

Empower Your Career with Astrion

Embark on a journey of professional discovery and innovation at Astrion. Whether you are starting your career or looking to enhance it, Astrion offers a dynamic environment where your ambitions can take flight.
Learn more about Astrion

Similar Jobs

More Jobs at Astrion

More Enterprise Technology Jobs

Find similar AI Productivity & Power BI Lead jobs: