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. 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 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.
Interpret business processes into data requirements.
Define and enforce key data attribute governance strategies.
Act as geographical data leader, reporting directly to the global director.
Collaborate on data team initiatives impacting Ontic's global strategic pillars.
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
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)
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.
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 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.
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
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
$110-$130. Budgeted $130
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.
#J-18808-Ljbffr
