Lead Datawarehouse Architect

As aLead Data Warehouse Analysthere at Honeywell you will lead the charge in optimizing data storage extraction transformation and loading (ETL) processes ensuring that our data warehouse operations run smoothly and efficiently. Your expertise in data modeling SQL and ETL tools will be instrumental in shaping the architecture that underpins our critical data infrastructure. Youll work on cutting-edge projects collaborating with cross-functional teams to provide insights that drive smarter business decisions. This role offers you the opportunity to be at the forefront of data-driven innovation shaping Honeywells future and contributing to our legacy of technological advancement.

You will report directly to ourDirector of Data Managementand youll work out of ourPhoenix AZlocation on aHybridwork schedule.

In this role you will impact the efficiency accuracy and informed decision-making of our data infrastructure ensuring that data is not just stored but harnessed as a strategic asset.

Key Responsibilities

• Design and develop data warehouse solutions to support business intelligence and reporting needs
• Collaborate with crossfunctional teams to gather analyze and translate business requirements into data solutions
• Manage and optimize ETL processes ensuring data quality and integrity throughout the data lifecycle
• Perform data profiling and quality assessments to ensure data accuracy and completeness
• Implement best practices for data security and compliance with data protection regulations
• Monitor and optimize query performance in data warehouses to ensure timely access to critical business information
• Troubleshoot and resolve datarelated issues collaborating with crossfunctional teams as necessary
• Stay uptodate with industry trends and emerging technologies in data warehousing and analytics

YOU MUST HAVE

• 6 years of experience in data warehousing ETL development and data modeling.
• Strong analytical and problem-solving skills.
• Proficiency in SQL for querying manipulating and analyzing data.
• Knowledge of data modeling techniques and practices.
• Solid understanding of data warehousing concepts data architecture and database design principles.
• Ability to work independently and as part of a team managing multiple tasks and projects simultaneously.
• WE VALUE
• Bachelors degree in Computer Science Data Management or a related field.
• Certifications in relevant technologies such as AWS Certified Data Analytics or Microsoft Certified: Azure Data Engineer.
• Experience with data visualization tools like Tableau Power BI or Looker.
• Knowledge of big data technologies and frameworks such as Hadoop and Spark.
• Strong project management and organizational skills.
• Demonstrated ability to mentor and guide junior data analysts.
• A passion for continuous learning and a proactive approach to adopting new technologies and methodologies.
• Previous experience in industries with complex regulatory and compliance requirements such as healthcare or finance.