Join GE Aerospace in Dayton, OH (onsite) to design and deliver data engineering capabilities that support analytical and reporting solutions. This role emphasizes automation, reliable data delivery using agile methodologies, and the ability to translate data analysis into reusable ETL components, metadata structures, and data quality controls.
Responsibilities
- Build technical data dictionaries and support business glossaries to enable dataset analysis.
- Perform data profiling and data analysis across source systems, manually maintained data, machine generated data, and target repositories.
- Create logical and physical data models for both OLTP and OLAP solutions.
- Develop and maintain data mapping specifications based on analysis results and functional requirements.
- Execute data loads and transformations using multiple tools and technologies.
- Build automated ETL jobs aligned to mapping specifications.
- Maintain metadata structures that enable reusable ETL components.
- Analyze reference datasets and become familiar with Master Data Management (MDM) tools.
- Assess downstream impact on systems and products.
- Use deep dive analysis to derive solutions and provide recommendations.
- Design and build Data Quality (DQ) rules to identify and address data quality issues proactively.
Requirements
- Bachelor’s degree from an accredited university or college with a minimum of 2 years of professional experience, or an Associate’s degree with a minimum of 5 years of professional experience, or a High School Diploma with a minimum of 7 years of professional experience.
- Legal authorization to work in the U.S. is required. GE Aerospace will not sponsor individuals for employment visas, now or in the future, for this job.
- Exposure to industry standard data modeling tools (for example, ERWin, ER Studio).
- Exposure to ETL tools such as Informatica or Talend.
- Exposure to data catalog, automated data discovery, and data lineage tools (for example, Alation, Collibra, TAMR).
- Hands-on experience with programming languages such as Java, Python, or Scala.
- Hands-on experience writing SQL scripts for Oracle, MySQL, PostgreSQL, or HiveQL.
- Experience with Big Data technologies including Hadoop, Spark, Hive, and HiveQL, plus NoSQL database engines such as Cassandra or HBase.
- Exposure to unstructured datasets and ability to work with XML and JSON file formats.
- Ability to conduct exploratory data analysis and generate visual summaries of data, including identifying data quality issues proactively.
Technologies: ERWin, ER Studio, Informatica, Talend, Alation, Collibra, TAMR, Java, Python, Scala, SQL, Oracle, MySQL, PostgreSQL, HiveQL, Hadoop, Spark, Hive, Cassandra, HBase, XML, JSON
Eligibility / Legal: Military experience is equivalent to professional experience.
Export-Controlled Information: This role requires access to U.S. export-controlled information. Employment is contingent upon proving status of a U.S. Person: U.S. lawful permanent resident, U.S. Citizen, or granted asylee or refugee status (protected individual under the Immigration and Nationality Act, 8 U.S.C. 1324b(a)(3)).
Relocation Assistance: No
