Technical Business Analyst

We are a fast-paced business with ambitious growth plans; so if you are dedicated, enthusiastic and always seeking ways to improve, you'll enjoy a career with us!

Ontic offers a new lease on life for the aerospace and defense industry. We’re dedicated to providing a safe, diverse, and evolving work environment. We work with integrity, responsibility, safety, and accountability through inspiring, engaging and collaborating to achieve a common goal — whether that’s serving our customers, helping each other, or volunteering in our local community.

Our team is looking for a Technical Business Analyst to join them. You will report to the General Manager and will have an onsite work schedule in Creedmoor, NC.

To be considered for the Technical Business Analyst opening, here’s what you’ll need to bring with you:

• Experience in a low-volume, high-mix manufacturing environment, preferably aerospace manufacturing with government/DoD client
• Advanced SQL and Python programming experience
• Advanced Power BI experience (DAX, M Query, TMDL)
• Familiarity with Microsoft Fabric ecosystem
• Knowledge of data warehousing (Snowflake preferred)
• Experience with Kimball Dimensional Modeling techniques
• Ability to document process flows, business rules, and data validation requirements
• Experience managing objects through a dev/test/prod DevOps cycle
• Experience with version control tools like GitHub or Azure Devops
• Strong analytical, problem-solving, and communication skills
• Familiarity with data security and compliance (ITAR, CCPA, PII)
  
  

Experience With Below Toolset a Bonus

• Experience with Epicor or Infor Syteline
• Experience with dbt
• Experience building Streamlit apps
• Experience with Spark
• Manufacturing ERP systems (Epicor, Infor Syteline)
• Snowflake
• Power BI
• GitHub
  
  

As a Technical Business Analyst, You Will

• Develop datasets, reports, and dashboards to support business processes
• Translate business requirements into technical specifications
• Collaborate with stakeholders to define requirements, conduct user acceptance testing, and drive continuous improvement of analytics tools
• Perform exploratory data analysis on complex business challenges
• Contribute to data pipelines that clean, transform, and integrate multiple data sources
• Present data insights through reports, dashboards, and other self-service tools
• Support end-users, promote data literacy, and enforce data governance standards
  
  

Our Benefits

• Comprehensive medical insurance
• Competitive PTO
• Company 401K plan with up to 4% matched contribution
• Annual bonus program (varies by level and discretionary based on company and individual performance)
• Flexible working arrangements
• Paid volunteering opportunities
• Access to mental health champions across our sites
• Commitment to development
• Employee referral program
  
  

Salary Range: $70,000 - $95,000/year, based on experience

EOE/Minority/Female/Sexual Orientation/Gender Identity/Disability/Veteran

Please click here to review Ontic's California Consumer Privacy Act policy.

Ontic Engineering and Manufacturing Inc. is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected Veteran

Status, or any other characteristic protected by applicable federal, state, or local law.

This position must meet export control compliance requirements. To meet export control compliance requirements, a “U.S. Person ” as defined by 22. C.F.R.

• 120.15 is required. “U.S. Person” includes U.S. Citizen, lawful permanent resident, asylee, or refugee.