Data Engineer - Business Intelligence

San Diego International is built upon the vision that every team member has a stake in bringing our “Good Feelings, Nonstop” brand to life for every passenger and fellow employee. Here at the Airport Authority, we love San Diego as much as we love flying, and we see our airport as an extension of the always friendly and sunny city we call home. If you’re looking for a team that values each other, does great work, and most importantly, has a lot of fun along the way, we invite you to apply today.

The Business Intelligence Department is looking for a detail-oriented individual in a Data Engineer role to design, build, and maintain data pipelines and data warehouse systems that enable the Airport Authority to efficiently collect, process, store, and analyze data from various sources. Enjoy a flexible telecommuting schedule (3 days remote, 2 days on-site) as you provide support for Data Science initiatives and:

• Strong programming skills in Python, C#, or other programming languages commonly used in data engineering.
• Develop and maintain databases, data warehouses, data lakes, documentation for all data pipelines, systems, and processes, ETL processes for integrating data from various sources.
• Design, build and maintain data pipelines and systems that collect, process, store, and analyze data from various sources.
• Collaborate with cross-functional teams to understand their data needs and develop scalable solutions that meet those needs. Optimize data storage and processing for performance and scalability.
• Ensure data quality, security, and privacy by implementing appropriate data governance, audit, and security measures.
• Basic understanding of advanced analytics techniques and machine learning algorithms, enabling them to prepare and process data for these applications
• Remain current on emerging trends and technologies in data engineering, cloud computing, and database management. Familiarity with cloud computing platforms, such as AWS, Azure, or Google Cloud Platforms.

Competencies:

• Problem Solving/Agility: Analyzes situation or factors, collaboratively generates alternatives or solutions, and readily adapts behavior or new work methods to evolving and unexpected situations.
• Process Knowledge: Proficiently analyzes and estimates projects, documents, monitors processes and develops framework for implementation and improvement.
• Communication/Collaboration: Proficiently and tactfully exchange and interpret information verbally and in writing; works effectively on cross-functional teams to accomplish organizational goals.
• Critical Thinking: Critically reviews and translates business requirements, data and information to specify solutions or alternative practice in support of business objectives and strategies.
• Leveraging Technology: Effective use of electronic information and associated systems such as Tableau, Power BI. AWS, Azure, SQL, and/or NoSQL. Expertise in database management systems, such as SQL databases (e.g., Oracle, T-SQL, MySQL, PostgreSQL, MongoDB). Skilled in data integration and ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) processes. Knowledge of data warehousing concepts and technologies (e.g., star schema, snowflake schema, or columnar storage) to design and maintain efficient data storage solutions. Proficient in data quality management and cleansing techniques, ensuring that data is accurate, consistent, and reliable for analysis.

Other Duties

This job description is not designed to cover a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Requirements

Required Education, Training and Experience:

• Graduation from a four-year college or university with a major in computer science, information systems, or closely related field.
• Three years of experience in data engineering or a related field.

Preferred Qualifications:

• One year or more experience with cloud computing platforms.
• Five years or more experience with database management systems such as SQL, or Hadoop.
• Two years or more experience with ETL tools and processes.
• Experience in the aviation industry or with airport operations is preferred.
• Graduate degree in Computer Science, Information Systems, Big Data Analytics or related field.

The starting hiring salary for his position is $108,460.

Pay range for a Data Engineer is $92,701 to $148.322.

EEO Statement

It is the policy of the San Diego County Regional Airport Authority to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, SDCRAA will provide reasonable accommodations for qualified individuals with disabilities.

Physical & Mental Demands

Persons with disabilities may be able to perform the essential duties of this class with reasonable accommodation. Reasonable accommodation will be evaluated on an individual basis and depends, in part, on the specific requirements for the job, the limitations related to disability and the ability of the hiring department to accommodate the limitation.

Under California Government Code Sections 3100 - 3109, public employees are designated disaster service workers. The term "public employees" includes all persons employed by the state or any county, city, state agency, or public district. Disaster service workers are required to participate in such disaster service activities as they may be assigned to them by their employer or law.