Business Intelligence Specialist

Business Intelligence Specialist Safran - 3.7 Costa Mesa, CA Job Details Full-time $94,230 - $148,070 a year 19 hours ago Benefits Health insurance Dental insurance Paid time off Vision insurance 401(k) matching Employee discount Life insurance Qualifications Data model design Performance tuning Data visualization software proficiency English Scalable systems SQL Database design Data Architecture Design (Architecture design skills) Improving database performance Scalability Data analytics tools Cross-functional collaboration Cross-functional communication Dimensional modeling Stakeholder management Full Job Description Published 05.05.2026

Company :

Safran Cabin Job field :

IT Location :

Costa Mesa , California , United States Contract type : Permanent Contract duration : Full-time Required degree : Bachelor's Degree Required experience : More than 5 years Professional status : Employees / Staff Spoken language(s) : English Fluent Salary range : $94,230 - $148,070 # 2026-179040 Published 05.05.2026 Job Description Here, we craft excellence together. Your mission? Making the journey the most enjoyable part of the trip. Join our first-class team to reinvent in-flight experience. The Business Intelligence Specialist creates and shall be responsible for designing, developing, and maintaining scalable enterprise BI and data solutions that support reporting, analytics, and strategic decision-making. This role requires expertise in

SQL, ETL

development, data engineering, data architecting, scripting, ERP Data and ERP Data Architecture, and modern BI visualization tools. The candidate will collaborate closely with global teams, including U.S. and offshore teams, and will serve as a key liaison to ensure effective communication, requirement gathering, and delivery alignment across regions. This role manages and implement the data governance requirements effectively without hampering data access.

Summary of Duties:

1. Design, Develop, Optimize and maintain data marts using advanced SQL queries, stored procedures, and database objects. 2. Design, implement, and maintain ETL pipelines using tools such as SSIS, Alteryx, Informatica, or similar platforms. (DataIku is a plus !) 3. Develop and support automation scripts using Shell scripting, PowerShell, Python, or equivalent. 4. Ensure data accuracy, reliability, and integrity across data ingestion, transformation, and delivery processes. 5. Build and manage datasets, semantic models, and analytical data structures for reporting and analytics. 6. including fact tables, dimension tables, staging layers, and metadata. 7. Develop reports and interactive dashboards using AWS Quicksight, Power BI, Tableau, or similar BI tools. 8. Translate business requirements into data models and visualizations that support clear, meaningful insights. 9. Experience working with AWS data services (e.g., S3, Redshift, Glue, Athena, Lambda) to build and support cloud-based data workflows. 10. Assist with integration between cloud, on premises systems, and third-party data sources. 11. Coordinate development tasks with offshore teams, ensuring clarity of requirements and on-time delivery. 12. Act as the liaison between Global business stakeholders and development teams 13. Understand business needs, gather detailed requirements, and translate them into clear technical specifications. 14. Communicate expectations, timelines, and deliverables to offshore teams in a structured manner. 15. Maintain strong professional relationships across time zones and functional areas to support smooth project execution. 16. Lead BI Projects on functional and technical level/aspect. 17. Mentor and Assist BI team members on Business Data, BI Process, BI functional and technical topics.

Job Requirements Computer Skills:

Bachelor's degree in Computer science, Information Systems, Data Analytics, or a related field; or equivalent professional experience. Minimum 6-8 years of experience in Business Intelligence, Data Engineering, or related technical fields. Expert-level SQL skills, including performance tuning and complex query development. Hands-on experience with one or more ETL tools (SSIS, Alteryx, Informatica, etc.). Strong understanding of data warehousing principles, dimensional modeling, and schema design. Experience building datasets, semantic layers, and scalable BI data solutions. Proficiency with BI tools such as Power BI or Tableau. Experience with AWS cloud technologies used in data storage, transformation, and analytics. Programming/scripting experience, including Shell scripting, PowerShell, Python, or equivalent. Excellent written and verbal communication skills, with the ability to interact with technical and non technical stakeholders. Ability to work with cross-functional and global teams in a collaborative environment.

Other Skills:

Strong problem-solving and analytical skills Ability to manage multiple tasks and deadlines High attention to detail Strong communication, documentation, and presentation abilities Ability to work independently and in global team environments Knowledge of agentic AI etc. is a plus ! Expertise on ERP Data and ERP Data Structure But what else? (advantages, specific features, etc.) Safran Cabin is #1 worldwide for business and regional aircraft interiors. Here, you will build your skills and grow with a community of experts to enrich yourself every day. Here, collaboration is embodied within the diversity of our teams all around the world. Here, we're cutting our emissions, not your ambitions. Together, let's shape the sustainable future of aeronautics. Learn more about Safran Cabin! Why join us? At Safran Cabin, we provide equal employment opportunity to all individuals regardless of race, color, religion, sex/gender, sexual orientation, gender identity/gender expression, marital status, pregnancy, age, national origin, ancestry, disability/medical condition, military or veteran status, citizenship status, genetic characteristics or information, or any other characteristic protected by applicable federal, state, and local laws.

Your Benefits:

Our suite of comprehensive benefits include health care (medical, dental and vision), life insurance, 401(k) savings plans with company match, paid time off, and employee discounts & rewards for consumer products/services and more! Company Information Safran is an international high-technology group, operating in the aviation (propulsion, equipment and interiors), defense and space markets. Its core purpose is to contribute to a safer, more sustainable world, where air transport is more environmentally friendly, comfortable and accessible. Safran has a global presence, with 100,000 employees and sales of 27.3 billion euros in 2024, and holds, alone or in partnership, world or regional leadership positions in its core markets. Safran is in the 2nd place in the aerospace and defense industry in TIME magazine's "World's best companies 2024" ranking. Safran Cabin designs, certifies, manufactures and supports innovative aircraft cabin interiors, equipment and systems, providing airlines and OEM Customers with distinctive aircraft branding, and their passengers with a safe, comfortable and enjoyable flying experience. Locate your future workplace 1620 Sunflower Avenue

CA 92626

Costa Mesa California United States