As a Lead Data Warehouse Analyst here 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. You'll 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 Honeywell's future, and contributing to our legacy of technological advancement.
You will report directly to our [title] and you’ll work out of our [City, State] location on a [Hybrid, On-site, Remote] work schedule.
In this role, your expertise in optimizing data processes and architecture will drive efficiency, accuracy, and informed decision-making. As an individual contributor, you'll influence the core of our data infrastructure, providing insights that are instrumental in shaping our future. Your role will help Honeywell maintain its reputation as a leader in technological advancement by ensuring data is not just stored but harnessed as a strategic asset. Join us in this essential position and be a driving force behind reshaping our data landscape, where data isn't just managed; it's a catalyst for innovation and excellence.
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
- Bachelor's 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.