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! Job Purpose: As part of the IT team, you will be accountable for administering and maintaining the Snowflake Data Warehouse and the data pipelines in the Fivetran ELT application. You will also be responsible for analysing data across multiple systems, producing data models, identifying gaps in the data models, and making recommendation for improvements. As part of this role, you will be expected to develop dashboards and reports to present data insights to stakeholders around the business. 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: Perform exploratory data analysis on a range of complex business problems. Administer and maintain the Snowflake Data Warehouse. Contribute to data pipelines that clean, transform and aggregate data from disparate data sources into reporting data stores Provide input on the company data strategy by suggesting and proving new technologies and innovations. 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 Host on-site data quality clinics Participate in and audit data governance activities Knowledge, Skills and Experience Proven experience of administering and working in a Data Warehouse (experience of Snowflake desirable) and building data models and flows from various sources. Good knowledge of data warehousing and data modelling principles. Experience of administering, creating, and maintaining data pipelines in an 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, ETL functional and non-functional requirements. Experience of DBT 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. 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. A willingness to be utilised as a developer across other enterprise applications. Experience with below toolset preferred: Snowflake data warehouse Dbt FiveTran Power BI Analytics Epicor Backend Architecture Ontic Engineering and Manufacturing Inc. is an Equal Opportunity/Affirmative Action 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 requires use of information which is subject to the International Traffic in Arms Regulations (ITAR). All applicants must be U.S. persons within the meaning of the ITAR. The ITAR defines a U.S. person as a U.S. Citizen, U.S. Permanent Resident (i.e. 'Green Card Holder'), Political Asylee, or Refugee. Ontic is a leading global aerospace OEM, providing complex engineered parts and repair services for established aircraft in the defense and commercial market. Boasting a portfolio of 7,500 top-level assemblies, Ontic is proud to work with our customers around the globe, with our team of experts delivering a wide variety of critical technologies, including fuel measurement systems, as well as a range of avionics, cockpit instruments and controls. With over 45 years of product manufacturing and aftermarket support experience, Ontic has operations across North America, UK & Europe, and Asia providing strategic worldwide support to civil and defense customers when and where it is needed. We are more than the sum of our parts. Why not join Ontic today?