Senior Data Engineer
Job Description
Lead cloud and on-prem data engineering efforts for airport data analytics infrastructure.
Responsibilities
- Provide lead direction, training, and work review to a data team; organize and assign work, set priorities, follow up, and control project status to support coordination and completion
- Lead and mentor data professionals with technical guidance and project direction
- Design and build data pipelines, including efficient ETL processes and scalable data models for analytical and operational needs
- Handle confidential and organization-sensitive data and systems
- Develop and maintain data pipelines and ETL in both cloud-based and on-premise environments
- Implement and manage data lakes and data warehouses using cloud services
- Create and optimize data models aligned to stakeholder requirements and analytical goals
- Collaborate with cross-functional teams to define and implement data solutions
- Ensure data quality, security, and compliance with industry standards
- Optimize data infrastructure for performance, scalability, and cost-efficiency
- Troubleshoot and resolve complex data-related issues
- Implement real-time data processing solutions for operations monitoring and reporting
- Design and implement data integration strategies connecting airport systems and external data sources
- Test, troubleshoot, refine, and document systems; apply QA and security standards to protect against data loss and minimize interruption during equipment failure
- Plan and develop test data for validation of new or modified database applications; monitor performance using utilities, online capabilities, and batch reports
- Work with IT and customer staff to define functional requirements, perform data modeling, and implement final products; resolve errors and interface problems while adhering to development standards
- Prepare program documentation and user procedures/instructions; assist user departments in implementing new or modified database applications; track and evaluate project and systems progress
- Serve on committees, project teams, and task forces; provide customer service support as required
- Produce technical, statistical, and narrative reports, letters, memos, and other written materials
- Improve unit effectiveness by suggesting improvements and participating as an active member of a work team
Requirements
- Bachelor's Degree in Computer Science, Management Information Systems, or a closely related field
- Seven (7) years of full-time professional experience in data engineering, focused on cloud environments
- At time of application and maintained thereafter: Microsoft Certified Azure Data Engineer Associate or Microsoft Certified Systems Engineer (MCSE) is preferred; may be substituted for education or experience up to two (2) years
- Professional-level experience and/or education that provides the skills/knowledge to perform all functions at this level may be substituted year-for-year up to two (2) years
- Clearly document qualifying education in the application’s Education section and each experience in the Work Experience section
- Do not substitute a resume for the application or write “see attached resume” on the application
- Legally authorized to work in the United States; Clark County does not provide H1B visa sponsorships or transfers
- 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 preferred
- Some positions may require a valid Nevada Class C Driver's License at time of hire
- Employment is contingent upon results of a pre-employment drug examination
- Permanent employees must maintain a principal place of residency within Clark County and provide proof of compliance with Nevada motor vehicle registration and driver’s license laws within 90 days of employment
- Department of Aviation employment contingent upon completion of an education/experience background investigation, FBI-processed fingerprint-based criminal history check, and ability to be granted and maintain a TSA security badge
- Upon acceptance of job offer, present two original government-issued IDs
Technologies
- Cloud-based solutions
- ETL
- Data pipelines
- Data models
- Data lakes
- Data warehouses
- Real-time data processing
- Microsoft Certified Azure Data Engineer Associate
- Microsoft Certified Systems Engineer (MCSE)
- AWS Certified Big Data
- IBM Certified Data Engineer
- Oracle Certified Professional - MySQL
- Certified Data Management Professional (CDMP)
- SAS Certified Bid Data Professional
- FBI
Benefits
- Alternative Work Schedules
- 100% Employer Paid Defined Benefit Retirement
- No Social Security Deduction
- No State Income Taxes
- Two employer sponsored health plans (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)
- 13 paid holidays plus a Floating Birthday Holiday and an additional Floating Holiday
- Paid Vacation Leave
- Paid Sick Leave
- Holiday Leave
- Catastrophic Leave
- Parental Leave (up to 90 days)
- Tool Allowance for certain eligible positions
- Guardian coverage (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
- Comprehensive training program
- Wellness program
- Community Volunteer Opportunities
About the Position
- Provides project and program leadership to professional and technical staff
- Confidential role excluded from membership in the union
- Designated exempt under the Fair Labor Standards Act (FLSA), not eligible for overtime
- This examination establishes 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
- Employee Services reserves the right to call only the most qualified applicants to the selection process
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
- Hearing and speech to communicate in person or over the telephone
- Accommodation may be made for some physical demands for otherwise qualified individuals who require and request accommodation
Location: Harry Reid International Airport, NV (onsite)
Salary: USD 88,254 - 130,353 per year
Experience: 7 years (minimum)
Education: Bachelor’s Degree in Computer Science, Management Information Systems, or a closely related field