Data Analyst - Power BI

astspacemobile; Midland (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

AST SpaceMobile is building the first global cellular broadband network in space to enable standard mobile devices to connect directly to space-based data assets. This role focuses on designing and delivering enterprise BI solutions that drive manufacturing and operations reporting across Midland facilities.

You will own Power BI reports, collaborate with business owners, model data, and enforce security and governance while integrating ERP/MES sources to provide timely KPIs and insights for

Qualifications

• Minimum 5 years as Data Analyst/BI role in enterprise environment.
• Strong SQL skills with complex queries and optimization.
• Experience building ETL/ELT pipelines and data models.
• Ability to define and track KPIs and metrics.

Responsibilities

• Design, build, publish, and maintain Power BI reports, dashboards, and semantic models for multiple workspaces.
• Gather requirements with business owners, define KPIs and metric definitions, ensure data accuracy before publishing.
• Build dimensional models, DAX measures, Power Query transformations; write efficient SQL queries.
• Integrate data from Tulip MES, NetSuite ERP, Rippling, SharePoint/Excel, and data lake.
• Define reporting data points with MES and architecture teams for manufacturing KPIs.
• Implement RLS/OLS using ISA-95 scope blocks and Entra IDs for access control.
• Configure connections with service accounts, manage gateways, and scheduled refresh.
• Govern Power BI workspaces with admin groups, Apps, and contributor enablement.
• Document reports with ARCH, DS, SOP, ACCESS, ISSUE logs for support continuity.
• Diagnose refresh failures, credential issues, and data-quality problems; root-cause analysis.
• Optimize performance with incremental refresh and query folding; propose improvements.
• Train and support users on Power BI usage and self-service reporting.

Skills

Power BI development

SQL proficiency

Data modeling

KPI tracking

Education

Bachelor's degree

Tools

Power BI Desktop

Power BI Service

SQL

Job description

Position Overview

AST SpaceMobile is building the first and only global cellular broadband network in space to operate directly with standard, unmodified mobile devices based on our extensive IP and patent portfolio and designed for both commercial and government applications. Our engineers and space scientists are on a mission to eliminate the connectivity gaps faced by today's five billion mobile subscribers and finally bring broadband to the billions who remain unconnected.

Key Responsibilities

• Design, build, publish, and maintain Power BI reports, dashboards, and semantic models for the AST & Science Global, AST Leadership, Midland HR, and Midland Manufacturing workspaces.
• Partner with the named Business Owner of each report to gather requirements, define KPIs and metric definitions, and validate data accuracy before anything is published to production.
• Build dimensional (star-schema) data models, DAX measures, and Power Query transformations; write targeted SQL queries that extract only the data required - never full-table loads.
• Source and integrate data from Tulip MES, NetSuite ERP, Rippling, SharePoint/Excel, and the enterprise data lake, consuming curated silver and gold layers and working with data engineering on the bronze/silver/gold (medallion) design.
• Work with the MES and architecture teams to define reporting data points so Tulip tables capture the fields needed for manufacturing KPIs such as work-order progress, step durations, cycle time, and efficiency.
• Implement Row-Level and Object-Level Security (RLS/OLS) based on the ISA-95 scope block (legal entity, site, area, work center) and functional domains, using Microsoft Entra ID security groups only - no individual user access.
• Configure data connections with approved service accounts or service principals, with credentials managed in 1Password; manage gateways and scheduled refresh to remove dependencies on individual user accounts.
• Apply Power BI workspace governance: admin group at creation, role-based workspace access, App-based distribution, and Contributor enablement so trusted business users can build self-service reports from published datasets.
• Produce and maintain the required documentation for every report - Architecture Overview (ARCH), Data Source Details (DS), Standard Operating Procedure (SOP), Access & Security (ACCESS), and Issue Log (ISSUE) - so any team member can support it without help.
• Diagnose and resolve refresh failures, credential issues, and data-quality problems; perform root-cause analysis and work requests through the Enterprise Applications Jira queue.
• Optimize report and model performance (e.g., incremental refresh, query folding, model size reduction) and recommend improvements to the reporting platform.
• Train and support business users and Contributors on Power BI usage, standards, and self-service best practices.
• Support ad-hoc analysis and executive reporting requests for operations, manufacturing, HR, and leadership stakeholders.

Qualifications

Education

• Bachelor's degree in computer science, Information Systems, Data Analytics, Statistics, Industrial Engineering, or a related field, or equivalent practical experience.

Experience

• A minimum of 5 years of experience as a Data Analyst, BI Developer, or similar role, including at least 3 years of hands-on Power BI development in an enterprise environment.
• Strong SQL skills (joins, CTEs, window functions, query optimization) against relational databases or data warehouses.
• Proven experience with Power BI Desktop and Service: data modeling, DAX, Power Query, workspaces, Apps, gateways, scheduled refresh, and RLS.
• Experience building ETL/ELT pipelines and integrating data from multiple enterprise systems (ERP, MES, HRIS, SaaS, files).
• Experience defining and tracking operational KPIs and translating business questions into measurable, documented metrics.

Preferred Qualifications

• Microsoft Certified: Power BI Data Analyst Associate (PL-300); Fabric Data Engineer Associate (DP-700) a plus.
• Experience in manufacturing, aerospace, or another regulated production environment; familiarity with OEE, yield, throughput, and cycle-time reporting.
• Experience with MES and ERP data, especially Tulip and NetSuite.
• Exp