Data Engineer

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!
Job Purpose:
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.
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 analyzing data across multiple systems, producing data models, identifying gaps in the data models, and making recommendation for improvements. Your primary focus will be on leveraging Snowflake, dbt, Fivetran, 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.
Main responsibilities:

• Perform exploratory data analysis on a range of complex business problems.
• Administer and maintain the Snowflake Data Warehouse.
• 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
• Support and enforce data quality governance
• 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 desirable)
• Experience building data models and flows from various sources using Kimball Dimensional Modelling techniques.
• Good knowledge of data warehousing and data modelling principles.
• 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.
• Experience with dbt data build tool.
• 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.
• 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 data warehouse
• Dbt
• FiveTran
• Microsoft Fabric/Power BI Analytics
• Power BI dataset administration
• GitHub peer review
• 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.

Ontic is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
Note: This job description is intended to convey information essential to understanding the scope of the position and is not an exhaustive list of skills, efforts, duties, responsibilities, or working conditions associated with it. The company may change responsibilities or requirements as the need arises.
Compensation Pay Range
100-115
Please click here to review Ontic's California Consumer Privacy Act policy.
Ontic Engineering and Manufacturing Inc. is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex including sexual orientation and gender identity, national origin, disability, protected Veteran
Status, or any other characteristic protected by applicable federal, state, or local law.
This position requires use of information which is subject to the International Traffic in Arms Regulations (ITAR). All applicants must be U.S. persons within the meaning of the ITAR. The ITAR defines a U.S. person as a U.S. Citizen, U.S. Permanent Resident (i.e. 'Green Card Holder'), Political Asylee, or Refugee.