Business Intelligence Analyst, Finance

Job Description

SpaceX was founded under the belief that a future where humanity is out exploring the stars is fundamentally more exciting than one where we are not. Today SpaceX is actively developing the technologies to make this possible, with the ultimate goal of enabling human life on Mars.

BUSINESS INTELLIGENCE ANALYST, FINANCE

The Business Intelligence Analyst is a key member of the finance organization and will be involved in many aspects of accounting and finance. You will be a key contributor in automating processes, providing visibility into analytics, collaborating across various groups, managing projects, and tracking the performance of our manufacturing and supply chain teams

RESPONSIBILITIES:

• Partner with application software teams on integration of manufacturing execution system data into GL and migrations of Starlink applications (customer, fulfillment, returns) into AX D365
• Produce complex queries to draw from and combine different data sources in existing pipelines
• Integrate with all levels of the business to understand current workflows and identify systematic gaps; help rapidly answer tactical business questions through analytical frameworks
• Implement costing models and processes across a variety of products (which could include Falcon, Dragon, Starship, and Starlink), from low volume actual costs to high volume average or batch costing metrics
• Develop new business processes and transaction flows with supply chain and production to ensure accurate tracking of materials and labor across multiple production sites and vendors
• Design PowerBI dashboards and create reports of product costs, inventory data, and other manufacturing and supply chain KPIs
• Build data analysis tools and queries to support inventory reconciliations, including raw material, WIP, and finished goods reporting
• Support and help automate the monthly-close process setup of cost accounting and inventory tracking for Starship, along with the proper inventory controls and reporting
• Provide ad-hoc support in adding visualizations or filters on top of existing dashboards
• Act as a champion to promote best practices in reporting in analysis: data integrity, test design, analysis, validation, and documentation

BASIC QUALIFICATIONS:

• Bachelor's degree in computer science, finance, management information systems, statistics, operations management, mathematics, or other technical discipline
• 2+ years of professional experience in accounting, finance operations, business, or economics
• Experience with SQL and Python

PREFERRED SKILLS AND EXPERIENCE:

• Expert level understanding of dimensional and tabular models that enable efficient analysis in Power BI, including DAX
• Proven experience in performance tuning of Power BI dashboards and reports, as well as monitoring health and performance of entire Power BI platform
• Microsoft SQL server development experience, or equivalent training or certification
• Understanding and knowledge of production and supply chain functions
• Experience supporting engineering or manufacturing process improvements
• Experience extracting and analyzing information out of massive, complex and, in some cases, disparate datasets
• Strong communication skills with the ability to regularly interface with executive management
• Ability to uncover and develop data-oriented stories that resonate with business partners/executive audiences
• Advanced Excel modeling and/or reporting skills
• Knowledge of SOX compliance
• Experience with building data infrastructure (e.g., designing architecture, building data pipelines, implementing scalable monitoring) and implementing reporting solutions
• Experience in a manufacturing or distribution environment
• Familiarity with Microsoft D365
• Adept at data prep, data modeling, and data visualization

ITAR REQUIREMENTS:

• To conform to U.S. Government space technology export regulations, including the International Traffic in Arms Regulations (ITAR) you must be a U.S. citizen, lawful permanent resident of the U.S., protected individual as defined by 8 U.S.C. 1324b(a)(3), or eligible to obtain the required authorizations from the U.S. Department of State. Learn more about the ITAR here.

SpaceX is an Equal Opportunity Employer; employment with SpaceX is governed on the basis of merit, competence and qualifications and will not be influenced in any manner by race, color, religion, gender, national origin/ethnicity, veteran status, disability status, age, sexual orientation, gender identity, marital status, mental or physical disability or any other legally protected status.

Applicants wishing to view a copy of SpaceX’s Affirmative Action Plan for veterans and individuals with disabilities, or applicants requiring reasonable accommodation to the application/interview process should notify the Human Resources Department at (310) 363-6000.