United Technologies Corporation Hadoop Data Architect in East Hartford, Connecticut

Job ID: 64026BR

City: East Hartford

State: Connecticut

Country: United States

Category: Information Technology

Job Type: Full Time

Description:

Pratt & Whitney is a world leader in aircraft engines and auxiliary power units. Headquartered in East Hartford, Connecticut, the company has locations around the United States and across the world.

We are a global leader in aviation propulsion and we are behind many of the major advances in both military and commercial engines. We design, manufacture and service aircraft engines, auxiliary and ground power units, and small turbojet propulsion products.

Do you have the experience to join our Team?

We are looking for talented, enthusiastic, and career-minded individual to join the Digital Enterprise Applications team. You will have the opportunity to design and implement solutions across a wide range of use cases including analytics, machine learning, digital thread and artificial intelligence. You will design and execute solutions for customers in engineering, manufacturing, sales and aftermarket. With several ongoing analytics initiatives, you will work alongside a highly talented team to deliver results for our customers.

You will assume a combination of project management responsibilities working with our customers, partners, and the digital team to build and deliver new solutions to meet Pratt & Whitney’s growing analytics needs.

Your Responsibilities

  • Perform architecture design for business model /data analyst for data projects and initiatives, creating conceptual and logical business models used to generate physical data models and database schemas

  • Identify and document current and future state data architectures

  • Develop standard work to promote and develop data architecture standard methodologies

  • Work closely with business and IT teams to clarify and refine functional data requirements

  • Establish new data standards and processes to support the Hadoop environment

  • Collaborate with various departments, architects, project managers and technical managers to provide estimates, develop overall implementation solution plan and serve as a lead, when required, to implement solutions

  • Create effective data models to support relational, OLAP, and NoSQL based databases

  • Effectively present / communicate data models to the business, IT and the project teams

  • Create and maintain a metadata management capability to integrate data dictionaries with the enterprise business glossary

  • Participate in architectural discussions to build confidence and ensure customer success when building new and migrating existing applications, software and services on the platform

Inclusion Powers Innovation:

We unlock our employees’ full potential through a versitile and engaging culture that values everybody’s opinion, driving innovation.

The goal of our diversity strategy is to create a workforce and environment where every employee is valued so innovation and creativity thrive and to ensure that all employees are engaged and empowered.

Employee Resource Groups:

The 9 ERGs have a collective mission of supporting P&W's recruitment, development and retention efforts through workshops, and events that promote personal/professional development, employee engagement, community involvement and business value.

  • All ERGs are open to all UTC employees, participation is voluntary

  • ERGs strive to provide short and long-term professional and personal benefits to their members

  • There are many other employee organizations at P&W, often more recreational in nature (e.g. jazz band and bicycling club).

A Great Place To Work!

Vacation:

We’re known for moving the world forward – building machines that run for hours, days and weeks without pause. But, people aren’t machines.

This year, UTC updated the vacation policy to provide more vacation time sooner. As soon as you start your role, you’ll be eligible for 15 paid vacation days (10-19 yrs., 20 days & 20+ yrs., 25 days).

Birth and Parental leave:

As a mother or father you have time off options to consider while caring for and bonding with your child.

UTC offers 8 paid weeks of birth and adoption leave and 4 paid weeks for parental leave.

Employee Scholar Program:

We are celebrating the 20th anniversary of the ESP!

We believe that individual and corporate success is driven by lifelong learning; we enable employees to continue their higher education. We want to have the best-educated workforce on the planet.

ESP is one of the most comprehensive company-sponsored employee education programs in the world. More than 45,000 employees have earned more than 38,000 degrees.

Pratt & Whitney is an Equal Opportunity Employer.

Qualification:

Basic Qualifications:

  • US Person (Permanent Greed Card or US Citizen) due to program requirements

  • Bachelor Degree in Computer Science, IT, or related field

  • You need at least 5 years of experience of data modeling support combined of these environments: warehouse, DataMart, business intelligence, and big data

Preferred Qualifications:

  • Strong experience using at least one of the top data modeling tools, such as Erwin, ER/Studio or PowerDesigner

  • Experience in architecture and implementation of large and highly complex big data projects

  • On premises Big Data platforms such as Hortonworks

  • Big Data Analytic frameworks and query tools such as Spark, Hive, HDF, HDFS

  • Streaming data tools and techniques such as Kafka

  • ETL (Extract-Transform-Load) tools such as Attunity, Business Object Data Services, Informatica

  • Continuous delivery and deployment using Agile Methodologies.

  • Data Warehouse and DataMart design and implementation

  • NoSQL environments such as HBase, Phoenix

  • Data modeling of relational and dimensional databases

  • Metadata management, data lineage, data governance, especially as related to Big Data

  • Structured, Unstructured, Semi-Structured Data techniques and processes

Education: Bachelor Degree in Computer Science, IT, or related field

United Technologies Corporation is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.

Qualification:

Basic Qualifications:

  • US Person (Permanent Greed Card or US Citizen) due to program requirements

  • Bachelor Degree in Computer Science, IT, or related field

  • You need at least 5 years of experience of data modeling support combined of these environments: warehouse, DataMart, business intelligence, and big data

Preferred Qualifications:

  • Strong experience using at least one of the top data modeling tools, such as Erwin, ER/Studio or PowerDesigner

  • Experience in architecture and implementation of large and highly complex big data projects

  • On premises Big Data platforms such as Hortonworks

  • Big Data Analytic frameworks and query tools such as Spark, Hive, HDF, HDFS

  • Streaming data tools and techniques such as Kafka

  • ETL (Extract-Transform-Load) tools such as Attunity, Business Object Data Services, Informatica

  • Continuous delivery and deployment using Agile Methodologies.

  • Data Warehouse and DataMart design and implementation

  • NoSQL environments such as HBase, Phoenix

  • Data modeling of relational and dimensional databases

  • Metadata management, data lineage, data governance, especially as related to Big Data

  • Structured, Unstructured, Semi-Structured Data techniques and processes

United Technologies Corporation is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.