Airport Data Engineer

Job Description:

Airport Data Engineer

Description

ABOUT THE POSITION

The Clark County Department of Aviation (DOA) is seeking qualified candidates to apply for the Airport Data Engineer position. This position provides professional support in leading the design, implementation, and maintenance of DOA’s data analytics infrastructure, focusing on cloud-based solutions. Further, this position develops and maintains Microsoft Power BI dashboards, reports, and data visualizations that translate a variety of data into actionable business insights. Additionally, this position collaborates with stakeholders across DOA to define reporting requirements, manage project timelines, and deliver analytical solutions that support informed decision-making at all levels.

This is an open and continuous recruitment; scheduling dates will vary depending on when the application was received and reviewed by Employee Services.

This examination will establish an Open Competitive Eligibility list to fill current and/or future vacancies that may occur within the next six (6) months at either level or may be extended as needed by Employee Services.

This position is confidential and excluded from membership in the union. Also, this classification is designated exempt under the Fair Labor Standards Act (FLSA), and is therefore, not eligible for overtime.

Employee Services reserves the right to call only the most qualified applicants to the selection process.

MINIMUM REQUIREMENTS

Education and Experience:

Bachelor's Degree in Computer Science, Management Information Systems, or a closely related field and six (6) years of full-time professional level experience in data engineering, with a focus on cloud environments. Possession at time of application and maintenance of a Microsoft Certified Azure Data Engineer Associate or Microsoft Certified Systems Engineer (MCSE) is preferred and may be substituted for education or experience up to two (2) years. Additionally, professional level experience and/or education that has provided the skills and knowledge necessary to perform all job functions at this level may be substituted on a year-for-year basis up to two (2) years.

All qualifying education and each experience must be clearly documented in the “Education” and “Work Experience” sections of the application. Do not substitute a resume for your application or write "see attached resume" on your application. All details must be written in your own words and cannot be copied from job descriptions or other external sources.

Licensing and Certification: AWS Certified Big Data, IBM Certified Data Engineer, Oracle Certified Professional - MySQL, DBA, Certified Data Management Professional (CDMP), SAS Certified Bid Data Professional or similar are preferred. Specified positions may require possession of a valid Nevada Class C driver's license at time of hire.

Pre-Employment Drug Testing: Employment is contingent upon the results of a pre-employment drug examination.

Residency Requirement: Permanent employees must maintain a principal place of residency within the boundaries of Clark County and provide proof of compliance with Nevada motor vehicle registration and drivers' license laws within 90 days of employment.

Citizenship: Candidates must be legally authorized to work in the United States. Please note, Clark County does not provide H1B visa sponsorships or transfers for any employment positions.

Background Check: Employment with the Department of Aviation is contingent upon completion of an education/experience background investigation, a fingerprint-based criminal history record check processed by the FBI, and upon the ability to be granted and maintain a security badge as mandated by the Transportation Security Administration. Note: all prospective hires must present two original government issued ID's upon acceptance of job offer. Examples of acceptable ID's include a Passport, Driver's License or DMV issued ID, birth certificate, Social Security card, Voter Registration card, school issued ID with picture, etc.

Customs and Border Protection Security Seal Program: Employment with the Department of Aviation in this job title is contingent upon a ten year employment and five year residency history record check and the ability to present original identity based documentation in order to meet the requirements for a Security Seal.

PHYSICAL DEMANDS

Mobility to work in a typical office setting and use standard office equipment, stamina to remain seated and maintain concentration for an extended period of time, vision to read printed materials and a computer screen, and hearing and speech to communicate in person or over the telephone. Accommodation may be made for some of these physical demands for otherwise qualified individuals who require and request such accommodation.

EXAMPLES OF DUTIES

• Creates data pipelines, developing efficient ETL processes, and building scalable data models to support analytical and operational needs of the organization.
• Works with confidential and organization sensitive data and systems.
• Designs, develops and maintains data pipelines and ETL processes in a cloud-based and on-premise environments.
• Implements and manages data lakes and data warehouses utilizing cloud-based services.
• Creates and optimizes data models to support stakeholder requirements and analytical needs.
• Collaborates with cross-functional teams to define and implement data solutions.
• Ensures data quality, security, and compliance with industry standards.
• Optimizes data infrastructure for performance, scalability, and cost-efficiency.
• Troubleshoots and resolves complex data-related issues.
• Implements real-time data processing solutions for operations monitoring and reporting.
• Designs and implements data integration strategies to connect various airport systems and external data sources.
• Tests, troubleshoots, refines and documents systems; applies quality assurance and security standards to ensure against the loss of data and a minimal interruption of usage in the event of equipment failure.
• Plans and develops test data to validate new or modified database applications, monitors system performance by the use of appropriate utilities, online capabilities and batch reports.
• Confers with IT and customer staff to define functional requirements, perform data modeling and implement final products; resolves errors and interface problems and ensures integrated systems in accordance with development standards.
• Composes program documentation and user procedures and instructions and assists user departments and staff in implementing new or modified database applications; tracks and evaluates project and systems progress.
• Serves on a variety of committees, project teams and task forces and provides customer service support as required.
• Prepares a variety of technical, statistical and narrative reports, letters, memos and other written materials.
• Contributes to the efficiency and effectiveness of the unit's service to its customers by offering suggestions and directing or participating as an active member of a work team.

Join the Clark County Department of Aviation Family where we offer a comprehensive benefits package that includes:

• Alternative Work Schedules
• More Money in Your Pocket
  • 100% Employer Paid Defined Benefit Retirement
  • No Social Security Deduction
  • No State Income Taxes
• Two Employer Sponsored Health Plans Offered - Choice of PPO or EPO (hybrid of HMO) - eligible first of the month following 15 days of employment
  • Medical - Employer pays 90% of premium
    • Pharmacy Benefits (30, 90-day retail or mail order fills)
    • 24/7 Telephone Advice Nurse - no employee cost
    • Teledoc, Doctoroo, and Dispatch Health
• Retiree insurance - eligible after 5 years of service
• Dental
• Vision
• Life Insurance - Employer Paid
• AD&D - Employer Paid
• Long Term Disability - Employer Paid
• Generous Leave Accruals that include:
  • 13 Paid Holidays plus a Floating Birthday Holiday, and an additional Floating Holiday
  • Paid Vacation Leave
  • Paid Sick Leave
  • Holiday Leave
• Other leave options
  • Catastrophic Leave
  • Parental Leave - Up to 90 days
• Tool Allowance for certain eligible positions.
• Wide Variety of Voluntary Benefits that include
  • Guardian - Accident, Cancer, Critical Illness, Hospital Indemnity, and Short-Term Disability Insurance.
  • Trustmark - Permanent Life Insurance benefits and long-term care.
  • Sunlife Financial - Basic and Voluntary Life Insurance, AD&D, and long-term disability insurance
  • TASC - Flexible Spending Account - FSA & Dependent Day Care Debit Card Available
  • Morgan Stanley - Deferred Compensation Plan
• Employee Assistance Program
• The Department of Aviation, a department of Clark County, is an affirmative action/equal opportunity employer
• Community Volunteer Opportunities
• Comprehensive training program
• Wellness program

Closing Date/Time: Continuous

Salary:

$38.23 - $56.51 Hourly