Senior Data Engineer
Data is Ontic’s biggest asset. We’re looking for someone who is passionate about data and who has the technical and soft skills to propel our data platform through an exciting period of growth. We are looking for someone with a unique blend of data platform governance and architecture, data and analytics engineering and data science. Somebody with the ability to communicate effectively across the board in a way that makes the complex seem simple.
As part of the Ontic Global Data Team, you will be responsible for designing, developing, and maintaining our data architecture and pipelines. You will also be responsible for analysing data across multiple systems, producing data models, identifying gaps in the data models, and making recommendations for improvements. Your primary focus will be on leveraging Snowflake, dbt, Fivetran, GitHub and Power BI to ensure our data is accessible, reliable, and actionable for stakeholders across the organization. In addition to technical proficiency, this role requires strong stakeholder engagement skills to collaborate effectively with teams across the company. 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.
This requires an on-site presence at one of our geographical sites in Gloucestershire, UK, for 1 - 3 days per week and occasional travel to USA sites from time to time.
Main responsibilities:
- Perform exploratory data analysis on a range of complex business problems.
- Interpret business processes into data requirements.
- Define and enforce key data attribute governance strategies.
- Act as geographical data leader, reporting directly to the Data Architecture Manager.
- Collaborate on data team initiatives impacting Ontic’s global strategic pillars.
- Administer and maintain the Snowflake Data Warehouse.
- Devise and maintain data engineering development standards in line with best practice
- 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 highly preferred)
- Ability to influence a team of technical and non-technical stakeholders
- Experience building data models and flows from various sources using Kimball Dimensional Modelling techniques.
- Proven knowledge of data warehousing and data modelling principles.
- 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.
- Awareness and familiarity with AI tool and technologies – preference for tools such as OpenAI Codex, Snowflake Cortex, Snowflake Intelligence
- 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.
- 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 of working in the Aerospace, Engineering, Manufacturing sectors
Experience with below toolset preferred:
- Snowflake cloud platform
- Dbt
- FiveTran, Precog
- Microsoft Fabric/Power BI Analytics
- GitHub SDLC
- Kimball Dimensional Modelling
- Dynamics 365 Backend
- Infor Syteline and/or Infor Visual ERP Backend
- SQL
Key Working Relationships:
- A variety of key stakeholders including site and enterprise leadership teams
- Geographically spread Global Data Team
- External mix of strategic technology partners and niche providers.
Applicants must have the legal right to work in the UK.
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!
