Airport Data Engineer
Indexed description
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.
THE SALARY FOR THIS RECRUITMENT HAS BEEN CHANGED AND IS NOW IN THE JOB ANNOUNCEMENT.
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.
- 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
The following questions 1-7 will be used to assist in determining if candidates meet the minimum qualifications.
Which describes your highest level of education completed? (Applicants with foreign or international education, including full degrees, partial degrees, or individual credits, must obtain a professional credential evaluation from an accredited evaluation agency. The evaluation must verify the U.S. educational equivalency and, if the applicant is offered a position, an original and verifiable copy must be submitted to the Clark County Department of Aviation at the candidate’s expense.)
- High School Diploma or GED
- Trade School or Technical Degree
- Some College (1-29 semester credits)
- Some College (30-59 semester credits)
- Some College (60-89 semester credits)
- Some College (90-120+ semester credits)
- Associate's Degree
- Bachelor's Degree
- Master's Degree or higher
- None of the above
Please indicate the major of your degree that best qualifies you for this position.
- Computer Science
- Management Information Systems
- Data Science
- Information Systems
- Statistics
- Other
- Not Applicable
If you indicated "Other" in question 2, please list what major your degree was in. Type N/A if this is not applicable to you.
04
Indicate your full-time professional level experience in data engineering, with a focus on cloud environments.
- No Experience
- Less than 2 years
- 2 to 3 years
- 3 to 4 years
- 4 to 5 years
- 5 to 6 years
- 6 to 7 years
- 7 to 8 years
- 8 to 9 years
- 9 to 10 years
- More than 10 years
Please list the employer(s) on your application where your experience was obtained in question 4. Type N/A if you have no related experience. See Template Below.
Employer Name
Job Title:
Hours Worked Per Week
Dates of Employment:
06
This classification allows for substitution of education and/or experience up to two (2) years if you possess and have maintained a current Microsoft Certified Azure Data Engineer Associate or Microsoft Certified Systems Engineer (MCSE). In order for your certification(s) to be considered as a substitute for your education and/or experience, you must either attach your certification(s) to your application or email it to [email protected] at the time of application.
Indicate which of the following applies to you. Select all that apply:
- I possess and have maintained a current Microsoft Certified Azure Data Engineer Associate certification. I understand that in order for my certification to be considered as a substitution for my education and/or experience, I must either attach my certification to my application or email it to [email protected] at the time of application.
- I possess and have maintained a current Microsoft Certified Systems Engineer (MCSE) certification. I understand that in order for my certification to be considered as a substitution for my education and/or experience, I must either attach my certification to my application or email it to [email protected] at the time of application.
- I do not possess or have not maintained a current Microsoft Certified Azure Data Engineer Associate certification or Microsoft Certified Systems Engineer (MCSE) certification.
Do you currently hold a valid driver's license?
- Yes, I currently hold a valid Nevada driver's license.
- Yes, I currently hold a valid driver's license from another state.
- No, I do not currently hold a valid driver's license.
The following skills assessment is a self-assessment used to evaluate an applicant's training and experience.
I Understand That
- Part-time experience must be prorated and credited as half of full-time experience (i.e., if you performed the task for two years in a part-time position, 20 hours per week, you can only credit yourself with one year of experience in that area)
- The education, knowledge, and experience levels indicated by my skills assessment responses must be supported and clearly documented in the "Education" and "Work Experience" sections of my application;
- Any falsification or misrepresentation of the information listed on the employment application or skills assessment may result in removal from the eligibility list or rescinding a job offer;
- Responses to assessment questions that are not supported and clearly documented in the "Education" and "Work Experience" sections on the application may result in question scores being adjusted to receive zero points;
- Assessment scores may be used to consider applicants for the selection process;
- I further understand that since exam scores will be automatically generated based on the applicant's response to each item in the assessment, score appeals will not be allowed for this recruitment.
- I have read and understand the above information regarding the completion of the following skills assessment questions. I further understand that this recruitment includes a skills assessment and that the answers I provide must be consistent with the "education" and "work history" sections details on my application and that scoring appeals will not be allowed for this recruitment.
Indicate if you possess any of the following certifications. Select all that apply:
- Azure Data Fundamentals
- Microsoft Power BI Data Analyst Associate
- Tableau Desktop Specialist
- Google Data Analytics Professional Certificate
- Certified Analytics Professional (CAP)
- Similar data-related professional certifications
- None of the above
If you answered, "Similar data-related professional certifications" in question 9, please list your current and professional certifications relevant to this position. See template below. Type N/A if this is not applicable to you.
Certification
Name of agency or institution administering the certification:
11
Indicate your full-time professional experience using Microsoft Power BI, including building reports, dashboards, and interactive visuals.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience designing and publishing Microsoft Power BI dashboards for business stakeholders.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience with DAX (Data Analysis Expressions) for calculated measures and columns in Microsoft Power BI.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience using Power Query (M language) for data transformation within Microsoft Power BI or Excel.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience building semantic models or data models in Microsoft Power BI (e.g. star schema, relationships, hierarchies).
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience defining KPIs, measures, and business logic within a semantic/tabular model.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience using Microsoft Fabric or Analysis Services (SSAS) tabular models.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience gathering and documenting business requirements from non-technical stakeholders.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience facilitating requirement workshops or stakeholder interviews.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience working with data warehouses or lakehouse platforms (e.g. Snowflake, Azure Synapse, Databricks, Fabric).
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience writing Business Requirements Documents (BRDs) or Functional Specifications.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience writing SQL queries for data extraction, transformation, or analysis.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience with ETL/ELT pipelines or data pipeline tools.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience translating business needs into data or reporting solutions.
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Indicate your full-time professional experience with Azure Data services (e.g. Data Factory, Blob Storage, Azure SQL).
- No Experience
- Less than 2 years
- 2 to 5 years
- 5 to 8 years
- More than 8 years
Please list the employer(s) on your application where your experience was obtained in questions 11-25. Type N/A if you have no related experience. See Template Below.
Dates Of Employment
- Required Question
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search