Job Description

Ontic, a leading licensor and manufacturer of complex engineering parts for the global aerospace and defence industries, are now recruiting for a Data Analyst to join our Operations team where you'll support us with transforming and visualizing data into stories that drive engagement, insight and action. This role will be based at our Staverton location, but being able to travel to other Ontic sites is required.

Ontic is a more than just a business, we're a community of innovators who pride ourselves on fostering a culture where talent thrives, ideas flourish, and careers are built. We're committed to excellence, driving us to continuously improve and adapt, ensuring that we remain at the forefront of our industry.

The Role:
One of Ontic's key strategic pillars is to drive Operational Excellence. As part of the global Operations community, you will play a key role, enabling Ontic to effectively deploy our assets (inventory, capital and people) and capabilities to deliver Customer and stakeholder expectations. As part of the global Operational Excellence team, you will play a key role in defining, creating and maintaining data models, reports and visualizations across all sites. You will work with cross functional teams to help define metric definitions, create a common terminology, align key attribute sets and serve as a data owner and steward.

In addition to technical proficiency, this role requires strong stakeholder engagement skills to collaborate effectively with teams across the company as the conduit between the supply chain and global data team. This is a very exciting and varied role and therefore will best suit a self-starter willing to deeply understand the broader company objectives and how proposed data projects support them.

Main responsibilities:Build datasets and reports for key operations processes, including but not limited to: Sales Inventory and Operation Planning process (Capacity and constraints, inventory management policies, operations planning and scheduling) Core Operations metrics (as reported in the Group monthly metrics review) and how these are represented within the business Tracking the benefits delivered by improvement projects, including the OPEX Value creation Plan (VCP) Translate business processes into technical requirements Engage stakeholders in requirement identification, user acceptance testing and continual improvement of data tools Perform exploratory data analysis on a range of complex business problems. Contribute to data pipelines that clean, transform and aggregate data from disparate data sources into reporting data stores Contributing to the translation of data into valuable insights that inform data driven decisions. Develop dashboards and reports to present data insights to stakeholders around the business. Support end-user technical questions and assist in data education Support and enforce data quality governance Participate in and audit data governance activities Maintain the currency and accuracy of our supply chain data dictionary

About you:
At Ontic, our culture is integral to making sure we enjoy our work and deliver for our customers. While we look for the right skillset, we're also looking for someone who will thrive within our recognition and empowerment culture.

To be successful in this role you'll need to have:Experience working with a low volume, high-mix global supply chain Knowledge of Operations and supply chain centric KPI calculation methods Experience building data models and flows from various sources using Kimball Dimensional Modelling techniques. Good knowledge of data warehousing and data modelling principles Analytics experience in a cloud data warehouse (Snowflake preferred) Experience of administering, creating, and maintaining data pipelines in an Extract/Load/Transform (ELT) application that cleans, transforms, and aggregates data from disparate data sources into reporting data stores. Experience documenting ELT specifications such as source to target mappings, business rules and data validation requirements, ELT functional and non-functional requirements. Experience of DBT as a data transformation tool Strong SQL programming experience in a commercial setting. Experience of using BI reporting tools (i.e. Power BI) with an ability to develop reports and dashboards. Skill in developing Power BI reports, metrics and dashboards to tell a data story. Ability to manage objects through a dev/test/prod DevOps cycle. Strong understanding and implementation of DAX and M-Query languages. Proven experience in training audiences of varying role and expertise. Strong analytical and problem-solving skills with a keen attention to detail. Excellent oral and written communication skills for translating data insights into concise executive summaries and presentations. Ability to present findings in a structured, clear manner with actionable insights. Possess ability to both multi-task and manage priorities effectively with the ability to work proactively and independently in meeting stakeholder needs whilst adhering to tight deadlines Appreciation of data security, CCPA, GDPR and PII data handling principles.

Benefits
At Ontic we care about your financial, physical, and mental wellness so we offer a range of benefits to support this, we care about what matters to you and have a valued culture of recognition and empowerment, accompanied by benefits that support work/life balance.

Our benefits package highlights include:Up to 29 days annual leave plus Bank Holidays 10 hours paid volunteering time Annual goal share bonus scheme for all employees 24/7 Employee Assistance Program (EAP) Discounts and offers from a range of retailers

Best place to work
We are more than the sum of our parts. And we've been recognised internally and externally for being so:We were ranked #9 in Best Companies' Q3 leaderboard for Best Manufacturing Company based on our employee feedback 72.5% of employees who took part in our 2023 employee satisfaction survey said they are proud to work at Ontic

No day is the same at Ontic; we have doubled in size over the last couple of years and are still in rapid growth. We attribute our success to empowering colleagues to create the opportunity, fostering an environment of autonomy where we ask for forgiveness, not permission.

Our values
Our values are intrinsic to everything we do:We share a common sense - we're a global family of specialists with a shared passion for precision. We have the freedom to choose - we're challengers and innovators with the freedom to think differently and challenge the status quo. We create the opportunity - we're change-makers with a clear direction and can-do spirit.
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!