Business Intelligence (BI) Specialist II

Welcome to San Diego International Airport, where our core purpose is to create an exceptional experience for both our community and visitors from around the world. It extends beyond just flights; we embody the vibrant spirit of San Diego itself—sunny, welcoming, and full of life. We are committed to attracting, fostering, and empowering a team of talented individuals who can deliver our strategic goals:

• Advance Airport Development
• Transform the Customer Experience
• Optimize Ongoing Business
• Cultivate Our Culture

Here, you’ll find a workplace culture that thrives on diversity and is anchored in our collective mindsets: collaboration, empathy, inclusivity, thoughtful decision-making, active listening, and always believing the best in people. If you are ready to contribute to a team that values meaningful impact and enjoys the journey along the way, we invite you to apply today and help us connect our community to the world.

Why You'll Love Working at SAN:

• Location:  The new Airport Authority Administration building, located on the San Diego International Airport campus and near the waterfront, providing stunning views of our runway, San Diego Bay, the Pacific Ocean, and the city skyline.
• Hybrid Work Schedule: We offer a flexible hybrid schedule, with an opportunity for remote work based on operational requirements, while supporting both in-office collaboration and remote productivity. 
• Salary: The hiring salary for Business Intelligence (BI) Specialist II is starting at $82,337. The full pay range for Business Intelligence (BI) Specialist II is $70,373-$112,597.
• Benefits: You will enjoy 14 paid holidays, 18 – 33 days of vacation (PTO), annual employer funded Lifestyle Spending Account which you can use to invest in your personal development and growth activities, parental and child care benefits, salary continuance for family & parental leave, tuition reimbursement, ensure your future with our retirement plan options including our comprehensive pension plan, 457 defined contribution plan, and more!
• Wellness: Take advantage of multiple on-site gyms with regular fitness classes, outdoor working areas, fitness discounts for all levels and goals, monthly fruit deliveries, rewards for volunteer time, financial wellness advisors, and a campus with easy access to some of San Diego's best walking trails.
• Application Deadline: January 16, 2025. Applications will be reviewed after the closing date.

About the Job:

The Business Intelligence team is looking for a Business Intelligence (BI) Specialist II with a solution-oriented mindset and a passion for transforming data into actionable insights and solutions. In this role, you’ll collaborate with internal customers to offer innovative and  alternative strategies that address the unique challenges of San Diego International Airport, directly influencing operations, financial performance, and the passenger experience.

Expertise in BI tools like Power BI or Tableau, advanced scripting languages such as SQL, R, or Python, and a deep understanding of data visualization and business KPIs are essential. This role requires the ability to translate complex data into meaningful insights and provide actionable recommendations that drive impactful decision-making. As a trusted advisor and technical leader, the candidate will play a pivotal role in shaping  the  organization’s impactful data-driven culture.

What You’ll Do:

• Collaboration and Stakeholder Engagement: Work closely with business units and project stakeholders to gather requirements, understand objectives, and define KPIs that drive value.
• Data Analysis and Scripting: Conduct comprehensive analyses using advanced reporting tools and scripting languages such as SQL, R, or Python.
• Insight Delivery: Provide clear, coherent, and insightful recommendations grounded in data analysis and subject-matter expertise.
• Report and Dashboard Design: Create actionable reports, visualizations, and dashboards by leveraging appropriate datasets and models to deliver meaningful insights.
• BI Solution Optimization: Maintain and enhance existing BI solutions while fostering a data-driven culture throughout the organization.
• Continuous Improvement: Stay ahead of emerging BI trends and technologies to ensure the organization's BI tools and processes remain cutting-edge.

The Skills We Are Looking For:

1. Reporting and Analysis—Analyze and report on data trends across sectors like airline operations and financial functions, utilizing advanced querying and scripting languages to create meaningful insights.
2. Technical & Process Knowledge— Expertise in BI tools such as Power BI, Tableau, Excel, and SSRS, with strong knowledge of KPIs, data warehousing, and ETL/ELT processes.
3. Visualization and Data Modeling— Design interactive visualizations and scalable data models to provide actionable business insights.
4. Communication/Collaboration— Translate complex data concepts into actionable insights through professional engagement with stakeholders.
5. Leadership and Independence— Lead technical initiatives and operate independently on complex projects.
6. Problem Solving/Agility— Solve complex problems proactively, adapting to changing business needs with innovative BI solutions.
7. Project Management— Oversee multiple BI projects simultaneously, ensuring quality and timely completion.

The Experience You Need to Have**:

• Three years of related experience demonstrating expertise in creating detailed reports, data-driven presentations, and insightful data analysis, or any equivalent combination of education, training, and/or experience.
• Graduation from an accredited four-year college or university with a major in business administration, computer Science, information management, or a closely related field.

Preferred Education, Certification, and Licenses:

• Master’s degree in mathematics, business administration, economics, computer science, information management, statistics, or a related field.
• Microsoft Certified Power BI Data Analyst Associate, Project Management Professional (PMP), Certified Analytics Professional (CAP), Certified Data Management Professional (CDMP), Certified Business Analysis Professional (CBAP) or similar certification.
• Lean Six Sigma or similar certification.

**Lacking some of the skills or experiences we've listed? No worries! Here at the San Diego International Airport, we're on a mission to cultivate a workforce as dynamic and diverse as the community we serve. While certain roles may require specific qualifications, we understand that talent comes in many forms. Some of our positions may not require specific degrees, and we're always open to individuals who bring a willingness to learn and a commitment to excellence. If you think this could be you, we encourage you to apply, and even if this position isn't the right role for you, we will add you to our database to consider for other opportunities in the future that align with your unique knowledge and skills. There's a chance we have the perfect spot for you to land!

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. If you need any form of accommodation during the recruitment process, please inform the Talent Acquisition Partner (Recruiter).

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.