San Diego County Regional Airport Authority
Data Warehouse Manager
San Diego County Regional Airport Authority, San Diego, California, United States, 92189
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 Data Warehouse Manager starting at $133,686. The full pay range for Data Warehouse Manager is $114,261-$182,818. 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:
December 4, 2024. Applications will be reviewed after the closing date. About the Job:
The Business Intelligence department is looking for a
Data Warehouse Manager
with a strong focus on data architecture, ETL/ELT processes, and cloud-based data solutions to drive the development and optimization of the organization's data infrastructure. This role is a blend of leadership and technical expertise, providing an exciting opportunity to innovate and shape the data systems that support the organization's business goals.
The ideal candidate will have a passion for staying ahead of trends in data warehousing and technology, an ability to lead cross-functional teams, and the technical acumen to directly contribute to the development of scalable and efficient data solutions. The role offers a unique combination of building cutting-edge infrastructure while maintaining a strategic, leadership-driven approach to ensure data consistency, quality, and performance across the organization.
What You'll Do:
Collaborate Across Teams:
Work with data engineers, architects, and the BI team to gather data requirements and align strategies, ensuring the data warehouse meets business objectives. Lead Data Warehouse Design:
Oversee the creation of scalable data warehouse architecture, including ETL/ELT processes, data modeling, and database schemas, ensuring efficient data management and integration. Drive Optimization:
Actively contribute to developing and optimizing data warehouse solutions, solving complex challenges while ensuring data quality and performance. Implement Data Governance:
Establish data governance frameworks, enforce naming conventions, and ensure compliance with security standards and organizational policies to maintain data integrity. Lead and Mentor Team:
Manage the day-to-day operations of the data warehouse team, providing leadership, mentoring, and ensuring project deliverables align with business requirements. Ensure Cost-Effectiveness:
Oversee the performance and cost efficiency of the data warehouse, ensuring optimal resource utilization, tracking expenses, and aligning projects with budget constraints. Stay Ahead of Trends:
Keep current on emerging data technologies and best practices, integrating advancements to enhance operations and support evolving business needs. The Skills We Are Looking For: Technical & Process Knowledge:
Manages the design, development, and maintenance of the data warehouse, ensuring accurate data storage, processing, and availability. Demonstrates expertise in ETL/ELT processes, data architecture, and cloud platforms (e.g., Snowflake, Redshift, Synapse), while actively contributing to technical development and optimization. Knowledge Application:
Ensures smooth data integration from multiple sources, establishing best practices and governance standards for security, quality, and scalability. Communication/Collaboration:
Works with business units and technical teams to understand requirements and deliver solutions, translating business needs into clear technical execution. Leadership & Influencing:
Balances leadership and technical work, mentoring the team and setting clear expectations for project execution and delivery. Problem Solving/Agility:
Adapts to evolving business needs by leading the team in finding solutions to technical challenges, improving processes, and enhancing data workflows. Project Management:
Oversees multiple projects, ensuring alignment with business priorities, effective resource allocation, and timely delivery. Risk Assessment:
Analyzes business requirements, assesses risks, defines problems, and drives solutions, engaging stakeholders and advancing projects without requiring close oversight.
Requirements
The Experience You Need to Have**:
Five years of increasingly responsible data engineering, data warehousing, or a related field, including technical leadership, with at least three years of a leadership role in data warehousing or data engineering capacity, and any equivalent combination of education, training, and/or experience. Graduation from an accredited four-year college or university with a major in computer science, information systems, data science, or a closely related field. Preferred Licenses; Certificates; Special Requirements:
Master's degree in Data Science, Computer Science, Information Management, or a related field. Certification with a Snowflake's SnowPro Core and Advanced (Architect, Data Engineer), Azure Data Engineer Associate (DP-203) and Azure Solutions Architect Expert, AWS Certified Big Data - Specialty, AWS Certified Data Analytics, and AWS Certified Solutions Architect (Associate or Professional), Google Cloud Platform Professional Data Engineer or Professional Cloud Architect, Certified Data Management Professional (CDMP), Certified Business Intelligence Professional (CBIP), Databricks Certified Data Engineer Associate or Professional, and Project Management Professional (PMP). Experience with cloud-based data warehousing solutions (e.g., Snowflake, Azure, Redshift) and automation tools (e.g., AWS Glue, Azure Data Factory). Familiarity with budget and resource management for data infrastructure projects.
**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.
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 Data Warehouse Manager starting at $133,686. The full pay range for Data Warehouse Manager is $114,261-$182,818. 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:
December 4, 2024. Applications will be reviewed after the closing date. About the Job:
The Business Intelligence department is looking for a
Data Warehouse Manager
with a strong focus on data architecture, ETL/ELT processes, and cloud-based data solutions to drive the development and optimization of the organization's data infrastructure. This role is a blend of leadership and technical expertise, providing an exciting opportunity to innovate and shape the data systems that support the organization's business goals.
The ideal candidate will have a passion for staying ahead of trends in data warehousing and technology, an ability to lead cross-functional teams, and the technical acumen to directly contribute to the development of scalable and efficient data solutions. The role offers a unique combination of building cutting-edge infrastructure while maintaining a strategic, leadership-driven approach to ensure data consistency, quality, and performance across the organization.
What You'll Do:
Collaborate Across Teams:
Work with data engineers, architects, and the BI team to gather data requirements and align strategies, ensuring the data warehouse meets business objectives. Lead Data Warehouse Design:
Oversee the creation of scalable data warehouse architecture, including ETL/ELT processes, data modeling, and database schemas, ensuring efficient data management and integration. Drive Optimization:
Actively contribute to developing and optimizing data warehouse solutions, solving complex challenges while ensuring data quality and performance. Implement Data Governance:
Establish data governance frameworks, enforce naming conventions, and ensure compliance with security standards and organizational policies to maintain data integrity. Lead and Mentor Team:
Manage the day-to-day operations of the data warehouse team, providing leadership, mentoring, and ensuring project deliverables align with business requirements. Ensure Cost-Effectiveness:
Oversee the performance and cost efficiency of the data warehouse, ensuring optimal resource utilization, tracking expenses, and aligning projects with budget constraints. Stay Ahead of Trends:
Keep current on emerging data technologies and best practices, integrating advancements to enhance operations and support evolving business needs. The Skills We Are Looking For: Technical & Process Knowledge:
Manages the design, development, and maintenance of the data warehouse, ensuring accurate data storage, processing, and availability. Demonstrates expertise in ETL/ELT processes, data architecture, and cloud platforms (e.g., Snowflake, Redshift, Synapse), while actively contributing to technical development and optimization. Knowledge Application:
Ensures smooth data integration from multiple sources, establishing best practices and governance standards for security, quality, and scalability. Communication/Collaboration:
Works with business units and technical teams to understand requirements and deliver solutions, translating business needs into clear technical execution. Leadership & Influencing:
Balances leadership and technical work, mentoring the team and setting clear expectations for project execution and delivery. Problem Solving/Agility:
Adapts to evolving business needs by leading the team in finding solutions to technical challenges, improving processes, and enhancing data workflows. Project Management:
Oversees multiple projects, ensuring alignment with business priorities, effective resource allocation, and timely delivery. Risk Assessment:
Analyzes business requirements, assesses risks, defines problems, and drives solutions, engaging stakeholders and advancing projects without requiring close oversight.
Requirements
The Experience You Need to Have**:
Five years of increasingly responsible data engineering, data warehousing, or a related field, including technical leadership, with at least three years of a leadership role in data warehousing or data engineering capacity, and any equivalent combination of education, training, and/or experience. Graduation from an accredited four-year college or university with a major in computer science, information systems, data science, or a closely related field. Preferred Licenses; Certificates; Special Requirements:
Master's degree in Data Science, Computer Science, Information Management, or a related field. Certification with a Snowflake's SnowPro Core and Advanced (Architect, Data Engineer), Azure Data Engineer Associate (DP-203) and Azure Solutions Architect Expert, AWS Certified Big Data - Specialty, AWS Certified Data Analytics, and AWS Certified Solutions Architect (Associate or Professional), Google Cloud Platform Professional Data Engineer or Professional Cloud Architect, Certified Data Management Professional (CDMP), Certified Business Intelligence Professional (CBIP), Databricks Certified Data Engineer Associate or Professional, and Project Management Professional (PMP). Experience with cloud-based data warehousing solutions (e.g., Snowflake, Azure, Redshift) and automation tools (e.g., AWS Glue, Azure Data Factory). Familiarity with budget and resource management for data infrastructure projects.
**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.