Ontic, a leading licensor and manufacturer of complex engineering parts for the global aerospace and defence industries, are now recruiting for a Process & Data Analyst to join our team. This role will be based at our Staverton site. 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. Job Purpose: Data is Ontic’s biggest asset. We’re looking for a passionate professional who can transform data into visual stories that drive engagement, insight and action. As part of the on-site team, you will play a key role in defining, creating and maintaining data models, reports and visualizations across all departments. You will work with cross functional teams to help define metrics, create a common terminology, align key attribute sets and serve as a data owner and steward. Reporting into the Head of Continuous Improvement, the role is critical to the success of Ontic’s growth strategy. You'll be taking the lead in the production of automated reporting tools to support operational & strategic planning. Working cross-functionally at all levels you'll liaise with and support other departments to achieve our collective goals and objectives. 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 business functions 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 business processes. Translate business processes into technical requirements Engage stakeholders in requirement identification, user acceptance testing and continual improvement of analytics 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 accuracy of our global data dictionary What you'll need to know You'll already have experience of working with Power BI, SQL & Python. Use of Snowflake, MS Dynamics/365, & Syteline 10 would be an advantage. You'll need to be comfortable working within brand guidelines and have well developed interpersonal skills and be confident communicating effectively across all levels of the business. The ability to see the big picture as well as the detail is key Knowledge, Skills and Experience Knowledge of 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 documenting process flows, business rules and data validation requirements, Strong SQL and python 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. 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. 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 paid leave 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 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