Senior Data Engineer

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.
• Contribute 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.

• 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, Five Tran, Precog, Microsoft Fabric/Power BI Analytics, Git Hub, SDLC, Kimball Dimensional Modelling, Dynamics 365 Backend, Infor Syteline and/or Infor Visual ERP Backend, SQL