Data Engineer - Business Intelligence
San Diego County Regional Airport Authority, United States
Job Description
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:
- Design, build and maintain data pipelines and systems that collect, process, store, and analyze data from various sources.
- Develop and maintain databases, data warehouses, data lakes, documentation for all data pipelines, systems, and processes, ETL processes for integrating data from various sources.
- Ensure data quality, security, and privacy by implementing appropriate data governance, audit, and security measures.
- 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.
- 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.
- Strong programming skills in Python, C#, or other programming languages commonly used in data engineering.
- Basic understanding of advanced analytics techniques and machine learning algorithms, enabling them to prepare and process data for these applications
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.
- Critical Thinking: Critically reviews and translates business requirements, data and information to specify solutions or alternative practice in support of business objectives and strategies.
- Communication/Collaboration: Proficiently and tactfully exchange and interpret information verbally and in writing; works effectively on cross-functional teams to accomplish organizational goals.
- Process Knowledge: Proficiently analyzes and estimates projects, documents, monitors processes and develops framework for implementation and improvement.
- 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:
- Graduate degree in Computer Science, Information Systems, Big Data Analytics or related field.
- 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.
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 orig