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 Creedmoor, NC, USA or Miramar, FL, USA for at least 3 days per week; and occasional travel to UK sites from time to time.

Main responsibilities:

• Perform exploratory data analysis on a range of complex business systems and 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
• Act as technical lead on Data Platform technologies
• 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
• GitHub SDLC
• Kimball Dimensional Modelling
• JIRA
• Microsoft Fabric/Power BI Analytics
• 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 USA.

Our Benefits:

• Comprehensive medical insurance
• Competitive PTO, holiday pay, and sick leave
• Company 401K plan with up to 4% matched contribution
• Annual bonus program (varies by level and discretionary based on company and individual performance)
• Flexible working arrangements
• Paid volunteering opportunities
• Access to mental health champions across our sites
• Commitment to development
• Employee referral program

Compensation Pay Range

TBC

Please click here to review Ontic's California Consumer Privacy Act policy.