Full time
Information Technology
Telecommunications
SQL
Job Description
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.
Requirements
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