Sr Data Engineer

Y99000 General Electric Company; Dayton (OH); Presencial; USD 90.000 - 130.000; Jornada completa

Descripción de la vacante

GE Aerospace in Dayton, OH is seeking a data engineer to design, develop, test, and implement data engineering processes for analytics and reporting. You will analyze data for data science outcomes and manage metadata structures, providing post-deployment support as needed.

Responsibilities include building data dictionaries, data profiling, data modeling for OLTP/OLAP, and developing ETL jobs. Strong SQL and programming skills are essential, along with experience in big data technologies and

Formación

• Bachelor's degree or higher with professional experience in data engineering.
• Experience with ETL tools and data modeling.
• Proficiency in SQL and programming languages (Java/Python/Scala).
• Exposure to Big Data technologies and data governance tools.

Responsabilidades

• Design and implement data engineering processes for analytics and reporting.
• Analyze data for data science outcomes and prepare datasets.
• Manage metadata structures and support post-deployment activities.
• Identify automation opportunities using AI tools to improve efficiency and reduce manual work.
• Deliver timely results using agile methodologies.

Conocimientos

Java

Python

Scala

SQL

Data analysis

Exploratory data analysis

Educación

Bachelor's degree

Associates degree with 5 years experience

High School Diploma with 7 years experience

Herramientas

ERWin

ER Studio

Informatica

Talend

Alation

Collibra

TAMR

Hadoop

Spark

Hive

NoSQL (Cassandra/HBase)

Descripción del empleo

Job Description Summary

Responsible for designing, developing, testing and implementing data engineering processes to generate analytical and reporting solutions.

Responsible for analyzing and preparing the data needed for data science based outcomes.

Also responsible for managing and maintaining metadata data structures besides providing necessary support for post-deployment related activities when needed.

Expected to actively look for automation opportunities, using artificial intelligence tools where appropriate, to reduce manual work and improve process efficiency.

Accountable to deliver results in a timely manner using agile methodologies.

Roles and Responsibilities

Build technical data dictionaries and support business glossaries to analyze the datasets.

Perform data profiling and data analysis for source systems, manually maintained data, machine generated data and target data repositories.

Build both logical and physical data models for both Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) solutions.

Develop and maintain data mapping specifications based on the results of data analysis and functional requirements.

Perform a variety of data loads & data transformations using multiple tools and technologies.

Build automated Extract, Transform & Load (ETL) jobs based on data mapping specifications.

Maintain metadata structures needed for building reusable Extract, Transform & Load (ETL) components.

Analyze reference datasets and familiarize with Master Data Management (MDM) tools.

Analyze the impact of downstream systems and products.

Derive solutions and make recommendations from deep dive data analysis.

Design and build Data Quality (DQ) rules needed.

Minimum Qualification

Bachelor’s degree from accredited university or college with minimum of 2 years of professional experience OR Associates degree with minimum of 5 years of professional experience OR High School Diploma with minimum of 7 years of professional experience.

Note: Military experience is equivalent to professional experience.

Eligibility Requirement

• Legal authorization to work in the U.S. is required. We will not sponsor individuals for employment visas, now or in the future, for this job.

Desired Characteristics

Technical Expertise: Exposure to industry standard data modeling tools (e.g., ERWin, ER Studio, etc.). Exposure to Extract, Transform & Load (ETL) tools like Informatica or Talend Exposure to industry standard data catalog, automated data discovery and data lineage tools (e.g., Alation, Collibra, TAMR etc., ) Hands-on experience in programming languages like Java, Python or Scala Hands-on experience in writing SQL scripts for Oracle, MySQL, PostgreSQL or HiveQL - Experience with Big Data / Hadoop / Spark / Hive / NoSQL database engines (i.e. Cassandra or HBase) Exposure to unstructured datasets and ability to handle XML, JSON file formats Conduct exploratory data analysis and generate visual summaries of data. Identify data quality issues proactively.

This role requires access to U.S. export-controlled information. Therefore, employment will be contingent upon the ability to prove that you meet the status of a U.S. Person as one of the following: U.S. lawful permanent resident, U.S. Citizen, have been granted asylee or refugee status (i.e., a protected individual under the Immigration and Naturalization Act, 8 U.S.C. 1324b(a)(3)).

Additional Information

GE Aerospace offers a great work environment, professional development, challenging careers, and competitive compensation.

GE Aerospace is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law.

GE Aerospace will only employ those who are legally authorized to work in the United States for this opening.

Any offer of employment is conditioned upon the successful completion of a drug screen (as applicable).

Employees may also be subject to random and reasonable-suspicion drug and alcohol testing.

• Relocation Assistance Provided: No

At GE Aerospace, we invent the future of flight, lift people up, and bring them home safely. We are a world-leading provider of jet engines, components, and integrated systems for commercial and military aircraft.

At GE Aerospace, respect for people is core to our culture and commitment to FLIGHT DECK, our proprietary lean operating model.

We attract, develop, and retain industry-leading talent from all backgrounds and cultivate communities where people are respected and empowered to reach their fullest potential.

For the people of GE Aerospace, their work isn't just a job. It's their passion and purpose.

We work and win as one team, accountable to each other and our customers, and we are always finding a better way to climb higher together.

We were meant to fly.