1766

Company Profile:

Duncan Aviation is the largest, family-owned maintenance, repair and overhaul (MRO) facility in the world providing complete nose-to-tail services for business aircraft. We value the individual experiences and diversity of our workforce and are proud to be a Veteran-Friendly Employer. Individuals of all backgrounds, nationalities, disability status, and military service are encouraged to apply.

Are you ready for an Experience. Unlike any other? Apply today!

The Sales Database Analyst is the primary administrator for Duncan Aviation's Customer Relationship Management (CRM) and Jet Aviation Knowledge Base (JAKB) databases. Responsible for daily updates and ongoing maintenance of the various data tables contained within the CRM and JAKB database to identify significant maintenance and service events and locates essential information for sales teams to pursue. Builds and maintains relational databases that are reliant on or leverage a higher level of data from internal and external information resources. Builds and distributes various reports used at all levels in the company. Protects the integrity of the information contained within the CRM and identifies areas where a process change or refinement of data could result in improved output. Provides administrative and clerical functions to support the Engine Sales team and builds campaigns and transactions for sales teams to pursue.

Essential Job Functions

1. Researches and maintains core aircraft data using various internal and external resources to track significant service and upgrade opportunities for the aircraft and passes this information along to Sales team members.
2. Assists in the maintenance and enhancement of internal information systems with relevant information for generating new and ongoing sales and marketing campaigns. Uses Structured Query Language (SQL) and custom database queries to leverage information assets, enhance information value, and retrieve information within the AS400 for sales and management through custom lists, campaign queries, and business intelligence reports.
3. Uses Microsoft Access to build and maintain relational databases used to create and generate highly complex queries to connect internal and external data, protect information integrity, build custom reports, identify new sales opportunities, and evaluate historic information. Assists in populating the sales pipeline for regional managers and sales teams and for extracting historical data for reporting and forecasting purposes.
4. Works closely with sales and marketing team members to generate call lists and campaigns and provides technical support and regular status updates and reports. Serves as liaison between CRM users, sales, IT, and Accounting.
5. Researches customers, aircraft owners, and operators information and maintains CRM by continuously and accurately adding and updating information using first-hand information, JetNet reports, log books, the AS400 and other sources. Updates key aircraft information, inspection programs, engine information, competitive information, contact information, mailing addresses, complete aircraft listings, etc. Coordinates with Sales Teams, Regional Managers, and other departments regarding AS400 and CRM information. Researches engine status and enters information into the Jet Aviation Knowledge Base (JAKB).
6. Creates and maintains reports, spreadsheets and documentation using information from the CRM, JetNet, and other customer and prospect lists and reports as requested.
7. Responsible for creating and maintaining a guidebook of knowledge management procedures. Assists Supervisor with developing new procedures and implementing training for team members.
8. Perform other related duties as assigned by management.

Job Specific Requirements

• Licenses: N/A
• Attendance: Regularly scheduled attendance required
• Physical: Repetitive motion; tolerates sitting, proficient typing and data entry skills
• Environmental: N/A

Education and Experience

• Associates degree in computer science or related field or equivalent experience required
• Minimum two years previous database administration experience and IT related experience required
• Advanced proficiency with Microsoft software (Word, Excel, Access, etc.) required
• Experience with Structured Query Language (SQL)

Available Benefits

• Moving is expensive and hard work! Relocation Assistance is available for those that qualify.
• Duncan offers a comprehensive Benefits Package (Medical, Dental, Vision, Vacation/Holiday) that is available to team members on day one.
• Plan for your medical needs with a Health Savings Account (employer and employee contributions).
• Save for your future through our 401(k) program where you can begin contributions within your first 45 days, 50% match on first 6% contributed
• Enjoy Duncan Aviation's On-Site Fitness & Health Clinics at the MRO locations
• Take advantage of a variety of In-House Training opportunities, or use Tuition Assistance to further your education.
  
  

Duncan Aviation is an Equal Opportunity and Affirmative Action Employer. EOE Minorities/Females/Protected Veterans/Disabled

Works Multiple Shifts: 0

Multiple Shifts Work Time:

Multiple Shifts Work Week:

Work Week Start: Monday

Work Week End: Friday

Work Start Time: 8:00 AM

Work End Time: 5:00 PM

Job Type: Full Time Regular