Inventory Locator Service (ILS), a division of CAMP has helped customers by collecting data about parts available in the marketplace and organizing them into one user-friendly database. The new and used parts locator service developed by ILS has helped numerous customers in the aviation, marine, and defense sectors find the parts they need, streamline procurement, sell their parts inventory, improve their MRO services, and automate their supply chain operations.

This position reports to the Manager of Database Services and the Data Engineer will primarily participate in planning, designing and implementation of architecture to support web based projects and ETL data ingestion. You have advanced skills and experience in PL/SQL development and data modeling for developing tables, packages and stored procedures for the ILS web-enabled marketplace. You have experience with data loading and data scrubbing in an Oracle environment.

Responsibilities:

• Must have excellent verbal and written communication skills.
• Take ownership and follow through with tasks until completion.
• Manage relationships and expectations with multiple stakeholders.
• Collaborate with cross-functional teams to develop new and enhance existing products and services.
• Drive process improvements to optimize solution delivery, operations and cost efficiencies.
• Guiding project teams in area of expertise.
• Ensure data architecture and standards meet the current and future needs of the business.
• Produce high quality documentation to share with other Data Engineers and Database Administrators to ensure good data governance practices.
• Diagnose and resolve database performance issues.
• Support data acquisition through web and document scraping.
• Support data analytics and reporting to shape new business opportunities and advance capabilities to drive value to customers through market intelligence.
• Discovers new opportunities and solutions for problems by looking beyond current practices and using innovative thinking.
• Demonstrates an interest in personal learning and development.

Requirements:

• 4-7+ years of experience with Oracle SQL and PL/SQL in a web environment. Ability to write efficient and complex Oracle SQL and PL/SQL code.

• 4-7+ years of experience with Oracle Database technologies.

• 4-7+ years of experience with data modeling.

• 2-6+ years of experience with ETL and Data loading preferably with Oracle Data Integrator (ODI).
• 3+ years of experience with Agile development.

• 3+ years supporting micro-service architecture.

Preferred Skills/Experience:

• Aviation Industry Experience.
• Experience with structured and unstructured data.
• Business Intelligence and Analytics Experience.
• Linux command line and scripting.
• Experience with ODI.
• Experience with R and/or Python.
• Experience with SQL Server.
• Coursework or Certificate in Data Science.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)