Chubb is looking for a Sr. Data Engineer / Data Warehouse Production Support Lead to ensure the smooth and reliable operation of their North America enterprise data warehouse, which is a strategic application feeding critical business decisions.
Requirements
- Possess a strong understanding of data warehouse technologies, ETL processes, and database management systems
- Demonstrate strong analytical and problem-solving skills to effectively address technical issues and challenges
Responsibilities
- Lead the process of identifying, prioritizing, and resolving production issues, ensuring minimal disruption to business operations.
- Investigate and identify the root causes of incidents to prevent recurrence
- Continuously monitor the data warehouse's performance, identifying bottlenecks and areas for improvement
- Implement performance tuning techniques to optimize query execution times, ETL processes, and overall system performance
- Implement and maintain data validation processes to ensure the accuracy and integrity of data in the data warehouse
- Address data quality issues, including data cleansing and transformation, to ensure data accuracy and consistency
- Participate in the planning and execution of data warehouse releases, ensuring minimal disruption to production operations
Other
- Maintain clear and timely communication with stakeholders, including business users, IT teams, and management, throughout the incident lifecycle.
- Collaborate with other teams to ensure the data warehouse has sufficient resources to meet current and future demands
- Build and maintain strong relationships with business users, IT teams, and other stakeholders
- Maintain comprehensive documentation of the data warehouse architecture, processes, and procedures
- Lead and mentor team members, providing guidance and support as needed