Data Integration Analyst

United Technologies Corporation East Hartford , CT 06108

Posted 4 days ago

Date Posted:
2019-07-09-07:00

Country:

United States of America

Location:

PW100: East Hartford 400 Main Street, East Hartford, CT, 06118 USA

The sky has no limits

Flight is an instrument of human progress. It not only gets people where they want to go, it carries humanity to places it never thought possible.

At Pratt & Whitney, you will be part of an evolving, globally diverse company that's moving fast to craft the future of aviation. Customers all over the world depend on our technology and the people behind it. As part of the team you'll help answer today's challenges in powered flight while crafting and supporting tomorrow's solutions.

Pratt & Whitney, a recognized leading producer of the world's most powerful jet engines, is looking for dedicated individuals to support our organization. If you aspire to work in a dynamic environment and possess the motivation to convert new ideas into practice, this may be the opportunity you've been looking for.

Inclusion Powers Innovation:

We unlock our employees' full potential through a versatile and engaging culture that values everybody's opinion, driving innovation. The goal of our diversity strategy is to build a workforce and environment where every employee is valued, so innovation and creativity thrive and to ensure that all employees are engaged and empowered.

Data Integration Analyst

Have you considered what it may be like to join our team and bring your career to Pratt & Whitney?

The Data Integration Analyst will be responsible for:

  • Providing data support for critical activities of the Military Engines organization, such as field operations, product improvement, maintenance forecasting, part forecasting, business planning, proposal development and safety analysis;

  • Data support typically entails analyzing data requirements and providing periodic reports and one-time data results;

  • Creating database queries and procedural code, when existing queries and code are not sufficient to satisfy data requests;

  • Performing analyses to ensure high data quality, including identifying and addressing erroneous data;

  • Assisting in requirements specification, contractor guidance, and development of new data applications, such as for a new large-scale consolidated data system being built to support multiple engine data needs;

  • Providing data management and database development services for existing database systems to maintain a high level of database readiness and integrity.

Do you have the education?

Degree in Computer Science, or related field, with corresponding relevant work experience:

  • BA/BS degree w/ 5+ years of experience outlined in the Basic Qualifications
  • MA/MS degree w/ 3+ years of experience outlined in the Basic Qualifications

Basic Qualifications:

BA/BS degree w/ 5+ years of experience in the following:

MA/MS degree w/ 3+ years of experience in the following:

  • Expert level in SQL to query and manipulate data in relational databases; extensive experience in writing stored procedures and UDFs is required;

  • Advanced skills in Database Management Systems such as Oracle including ability to automate processes using application code;

  • Expertise in Business Intelligence and Visualization software such as Business Objects, Qlik Sense or similar is required;

  • Experience building custom ETL (Extract Transform and Load);

  • In-depth understanding of data warehouse concepts;

  • Project management skills using agile methodology including ability to prioritize, meet deadlines and follow through on completion of high-profile projects;

  • Self-motivated & capable of working independently as well as within a group environment;

  • Able to work well in an environment that emphasizes continuous process improvement and process standardization;

  • U.S. Citizenship and the ability to obtain a security clearance are required for this position

Preferred Qualifications:

  • Experience with scripting and programming languages such as Python, Java, and VBScript;

  • Knowledge in data cleansing techniques using off-the-shelf software products;

  • Experience with frameworks for distributed computing, in particular Hortonworks/ Cloudera implementation of Hadoop.

  • Statistical experience is a plus

PWRSR

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.

Privacy Policy and Terms:

Click on this link to read the Policy and Terms


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Integration Analyst

Pratt & Whitney

Posted 7 days ago

VIEW JOBS 10/8/2019 12:00:00 AM 2020-01-06T00:00 Date Posted: 2019-07-09-07:00 Country: United States of America Location: PW100: East Hartford 400 Main Street, East Hartford, CT, 06118 USA The sky has no limits Flight is an instrument of human progress. It not only gets people where they want to go, it carries humanity to places it never thought possible. At Pratt & Whitney, you will be part of an evolving, globally diverse company that's moving fast to craft the future of aviation. Customers all over the world depend on our technology and the people behind it. As part of the team you'll help answer today's challenges in powered flight while crafting and supporting tomorrow's solutions. Pratt & Whitney, a recognized leading producer of the world's most powerful jet engines, is looking for dedicated individuals to support our organization. If you aspire to work in a dynamic environment and possess the motivation to convert new ideas into practice, this may be the opportunity you've been looking for. Inclusion Powers Innovation: We unlock our employees' full potential through a versatile and engaging culture that values everybody's opinion, driving innovation. The goal of our diversity strategy is to build a workforce and environment where every employee is valued, so innovation and creativity thrive and to ensure that all employees are engaged and empowered. Data Integration Analyst Have you considered what it may be like to join our team and bring your career to Pratt & Whitney? The Data Integration Analyst will be responsible for: * Providing data support for critical activities of the Military Engines organization, such as field operations, product improvement, maintenance forecasting, part forecasting, business planning, proposal development and safety analysis; * Data support typically entails analyzing data requirements and providing periodic reports and one-time data results; * Creating database queries and procedural code, when existing queries and code are not sufficient to satisfy data requests; * Performing analyses to ensure high data quality, including identifying and addressing erroneous data; * Assisting in requirements specification, contractor guidance, and development of new data applications, such as for a new large-scale consolidated data system being built to support multiple engine data needs; * Providing data management and database development services for existing database systems to maintain a high level of database readiness and integrity. Do you have the education? Degree in Computer Science, or related field, with corresponding relevant work experience: * BA/BS degree w/ 5+ years of experience outlined in the Basic Qualifications * MA/MS degree w/ 3+ years of experience outlined in the Basic Qualifications Basic Qualifications: BA/BS degree w/ 5+ years of experience in the following: MA/MS degree w/ 3+ years of experience in the following: * Expert level in SQL to query and manipulate data in relational databases; extensive experience in writing stored procedures and UDFs is required; * Advanced skills in Database Management Systems such as Oracle including ability to automate processes using application code; * Expertise in Business Intelligence and Visualization software such as Business Objects, Qlik Sense or similar is required; * Experience building custom ETL (Extract Transform and Load); * In-depth understanding of data warehouse concepts; * Project management skills using agile methodology including ability to prioritize, meet deadlines and follow through on completion of high-profile projects; * Self-motivated & capable of working independently as well as within a group environment; * Able to work well in an environment that emphasizes continuous process improvement and process standardization; * U.S. Citizenship and the ability to obtain a security clearance are required for this position Preferred Qualifications: * Experience with scripting and programming languages such as Python, Java, and VBScript; * Knowledge in data cleansing techniques using off-the-shelf software products; * Experience with frameworks for distributed computing, in particular Hortonworks/ Cloudera implementation of Hadoop. * Statistical experience is a plus PWRSR 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. Privacy Policy and Terms: Click on this link to read the Policy and Terms Pratt & Whitney East Hartford CT

Data Integration Analyst

United Technologies Corporation