Senior Data Engineer

Ontic, a leading licensor and manufacturer of complex engineering parts for the global aerospace and defence industries, are now recruiting for a Data Platform Engineer to join our Global Data Team.

Ontic is 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.

With over 1,300 employees across four time zones and seven sites, we have more than doubled in size since 2019 and are continuing to grow at pace. Data is one of Ontic’s biggest assets, and this role will play a key part in helping us make sure it is accessible, reliable and actionable for stakeholders across the organisation.

The Role:

Reporting to the Data Architecture Manager, you will be part of the Ontic Global Data Team and will play a key role in designing, developing and maintaining our data architecture, data pipelines and analytics capability.

Your focus will be on leveraging tools including Snowflake, dbt, Fivetran, GitHub and Power BI to support the development of robust data platforms, models, governance and reporting capability across the business.

Key responsibilities include:

• Performing exploratory data analysis on a range of complex business problems
• Interpreting business processes into clear data requirements
• Defining and enforcing key data attribute governance strategies
• Acting as a geographical data leader within the Global Data Team
• Collaborating on data team initiatives that support Ontic’s global strategic pillars
• Administering and maintaining the Snowflake Data Warehouse
• Devising and maintaining data engineering development standards in line with best practice
• Contributing to data pipelines that clean, transform and aggregate data from disparate sources into reporting data stores
• Producing data models, identifying gaps and making recommendations for improvement
• Providing input into the company data strategy by suggesting, testing and proving new technologies and innovations
• Translating data into valuable insights that inform data-driven decisions
• Developing dashboards and reports to present data insights to stakeholders across the business
• Supporting end-user technical questions and assisting in data education
• Hosting on-site data quality clinics
• Participating in and auditing data governance activities

This is a varied and exciting role that will suit a self-starter who is keen to deeply understand Ontic’s wider business objectives and how data projects support them. You will work closely with a variety of stakeholders, including site and enterprise leadership teams, the geographically spread Global Data Team, external strategic technology partners and niche providers.

About You:

You’ll be an experienced data professional with a strong background in data warehousing, data modelling, analytics engineering and data platform governance.

We’re looking for:

• Proven experience administering and working within a data warehouse environment, with Snowflake experience highly preferred
• Strong SQL programming experience in a commercial setting
• Experience building data models and data flows from various sources using Kimball Dimensional Modelling techniques
• Proven knowledge of data warehousing and data modelling principles
• Experience using dbt
• Experience administering, creating and maintaining data pipelines in an ELT application that cleans, transforms and aggregates data from disparate sources into reporting data stores
• Experience documenting ELT specifications, including source-to-target mappings, business rules, data validation requirements, and functional and non-functional requirements
• Experience using BI reporting tools, such as Power BI, with the ability to develop reports and dashboards
• The ability to influence technical and non-technical stakeholders
• Strong analytical and problem-solving skills with excellent attention to detail
• Excellent oral and written communication skills, with the ability to translate data insights into concise executive summaries and presentations
• The ability to present findings in a structured and clear way, with actionable insights
• The ability to multi-task and manage priorities effectively
• A proactive and independent approach to meeting stakeholder needs while working to tight deadlines
• An appreciation of data security, CCPA, GDPR and PII data handling principles
• Awareness of AI tools and technologies, with experience using tools such as OpenAI Codex, Snowflake Cortex or Snowflake Intelligence preferred
• Willingness to be utilised as a developer across other enterprise applications
• Experience working within the aerospace, engineering or manufacturing sectors would be advantageous

Experience with the below toolset is preferred:

• Snowflake cloud platform
• dbt
• Fivetran or Precog
• Microsoft Fabric / Power BI Analytics
• GitHub SDLC
• Kimball Dimensional Modelling
• Dynamics 365 backend
• Infor Syteline and/or Infor Visual ERP backend
• SQL

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 + 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.

Ontic is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

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!