refresh

Trending Companies

Trending

Jobs

JobsHoneywell

Lead Datawarehouse Architect

Honeywell

Lead Datawarehouse Architect

Honeywell

Phoenix, AZ, United States, US

·

On-site

·

Full-time

·

6d ago

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 Director of Data Management and you’ll work out of our **Phoenix, AZ **location on a Hybrid work 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.

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.

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

Total Views

0

Apply Clicks

0

Mock Applicants

0

Scraps

0

About Honeywell

Honeywell

Honeywell

Public

The future is what we make it.

10000+

Employees

Charlotte

Headquarters

Reviews

3.2

4 reviews

Work Life Balance

3.5

Compensation

4.0

Culture

4.0

Career

3.0

Management

2.5

Pros

Good team and helpful colleagues

Fair pay and good benefits

Training and resources available

Cons

Limited job progression

Old boys club culture

High expectations with unclear answers

Salary Ranges

1,391 data points

Mid/L4

Senior/L5

VP

Director

Mid/L4 · Project Manager

254 reports

$126,088

total / year

Base

$117,535

Stock

-

Bonus

$8,553

$86,649

$184,765

Interview Experience

4 interviews

Difficulty

2.5

/ 5

Duration

14-28 weeks

Offer Rate

25%

Experience

Positive 0%

Neutral 75%

Negative 25%

Interview Process

1

Application Review

2

Recruiter Screen

3

Technical Phone Screen

4

Hiring Manager Interview

5

Panel Interview

6

Online Assessment

7

Offer

Common Questions

Technical Knowledge

Behavioral/STAR

Past Experience

Coding/Algorithm

Culture Fit