Overview

Job Title: IT Business Analyst

Job Location: Torrance, CA (Hybrid)

Salary: $100,000-$140,000/yr

Benefits: Comprehensive benefits package from 1st day, Medical/dental/vision, 6% match on 401K, competitive PTO, 9/80 work schedule (every other Friday off)

Stellant Systems, a premier manufacturer of critical power amplification products where our technologies and products are unparalleled in the industry. We specialize in the manufacture of microwave devices for ground-based, airborne and satellite communications, industrial and medical equipment, and radar; we are the only U.S. supplier of space-qualified Traveling Wave Tube and Traveling Wave Tube Amplifiers. We combine cutting-edge technology with world-class engineering teams to deliver innovative solutions. Together, we form an invincible company.

As an employer of choice, our goal is to deliver an exceptional employee experience - we recruit diverse, high-performing talent to help our customers exceed their mission needs, which drives our employees to achieve their full potential.

Fundamental to our culture is our focus on core values, inclusivity in the work environment, and a unified dedication to continuous innovation and improvement. In order to serve our vast customer base ranging from the defense industry leaders, to the U.S. and allied militaries, and medical communities, we need the world’s most dedicated and talented people. If these types of projects excite you, we’d love for you to join our team and help us detect, protect, and connect.

#LI-Hybrid

Responsibilities

The IT Business Analyst will work with various stakeholders to understand how to query and analyze data to address business needs. The ideal candidate will be a self-starter that has worked in-depth in data analysis, including experience extracting and manipulating data using SQL, leveraging advanced Excel features for data analysis, and producing actionable information using visualization tools such as Tableau and Cognos.

• Ability to identify problems quickly and escalate appropriately when anomalies are found within the system.

• Configure and test functionality to satisfy business requirements as they change.

• Work with end users to gather requirements.

• Work to improve the systems and processes currently in place by researching and analyzing the current environment and put forth recommendations and products to improve the overall environment.

• Conduct analysis of functional business processes to identify areas of improvement by developing complex BI solutions.

• Develop powerful BI tools that integrate data from multiple systems for direct consumption or integration with other systems.

• Extract ad hoc data and perform complex, detailed analyses in support of applicable projects and/or on-demand business needs.

• Prepare BI reporting and data analyses based on the needs of internal stakeholders.

• Ability to communicate complex data in a simple, actionable way.

• Provide quality assurance of imported and reporting data.

• Process confidential data and information according to company guidelines.

• Manage and design the reporting environment, including data sources, security, and metadata.

• Support the data warehouse in identifying and revising reporting requirements.

• Support initiatives for data integrity and normalization.

• Troubleshoot the reporting database environment and reports.

• Evaluate changes and updates to source production systems.

Qualifications

• Bachelor’s degree in supply chain or Operations Research or Computer Science or Statistics or Business Data Analytics or MIS or related field required.

• At least 6 years of experience in the field of data warehousing, BI and Reporting or other related work experience.

• 3+ years of relevant Infor LN experience or Costpoint preferred.

• Experience with SSRS, SSIS, SSAS, ETL and data warehousing tools and processes.

• Intermediate / Advanced Microsoft Excel skills including pivot tables, v-look ups, and h-look ups.

• Strong ability to translate business requirements into accurate SQL queries.

• Hands-on experience in developing complex SQL queries.

• Proficiency in creating dashboards in Tableau and/or Power BI.

• Strong interpersonal skills and the ability to lead and work successfully on a team.

• Positive attitude and ability to multi-task in a fast-paced environment with minimal supervision

• Excellent analytical skills. Must be able to solve complex systems problems quickly with little technical guidance and develop corrective measures.

• Exceptional critical-thinking and problem-solving skills, with a keen attention to details.

• Prior experience in Aerospace and Defense industries is a plus.

Stellant Systems is an Equal Opportunity/Affirmative Action Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status or membership in any other group protected by federal, state or local law.

To conform to U.S. Government space technology export regulations, applicant must be a U.S. citizen, lawful permanent resident of the U.S., protected individual as defined by ITAR (22 CFR §120.15).

Job Locations US-CA-Torrance

ID 2024-1655

Category Information Technology

Position Type Regular Full-Time

Union No

Min USD $100,000.00/Yr.

Max USD $140,000.00/Yr.

Work Environment Hybrid

Stellant Systems is an Equal Opportunity/Affirmative Action Employer. We consider applicants without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status or membership in any other group protected by federal, state or local law.