Sr Data Engineer
Job Description
GE Aerospace is seeking a Sr Data Engineer to design, develop, test, and implement data engineering processes that support analytical and reporting needs. In this onsite role in Dayton, OH, you will also prepare data to enable data science outcomes, focusing on automation, timely delivery, and execution aligned with agile methodologies.
Core Responsibilities
- Build technical data dictionaries and support business glossaries to help analyze datasets.
- 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.
- Run data loads and data transformations using multiple tools and technologies.
- Build automated ETL jobs based on the established data mapping specifications.
- Maintain metadata structures required for reusable ETL components.
- Analyze reference datasets and familiarize with MDM tools.
- Assess the impact of downstream systems and products.
- Conduct deep-dive data analysis to derive solutions and make recommendations.
- Design and build Data Quality (DQ) rules.
Required Qualifications
- Bachelor’s degree from an accredited university or college with minimum 2 years of professional experience.
- Legal authorization to work in the U.S. is required. The employer will not sponsor individuals for employment visas, now or in the future, for this job.
- Exposure to industry standard data modeling tools (e.g., ERWin, ER Studio).
- Exposure to ETL tools such as Informatica or Talend.
- Exposure to industry standard data catalog, automated data discovery, and data lineage tools (e.g., Alation, Collibra, TAMR).
- Hands-on experience in programming languages: Java, Python, or Scala.
- Hands-on experience writing SQL scripts for Oracle, MySQL, PostgreSQL, or HiveQL, plus experience with Big Data / Hadoop / Spark / Hive / NoSQL database engines (e.g., Cassandra or HBase).
- Exposure to unstructured datasets and the ability to handle XML and JSON file formats.
- Ability to conduct exploratory data analysis, generate visual summaries of data, and proactively identify data quality issues.
Additional Notes
- Military experience is equivalent to professional experience.
- This role requires access to U.S. export-controlled information. Employment will be contingent upon proof that you meet the status of a U.S. Person as one of the following: U.S. lawful permanent resident, U.S. Citizen, or granted asylee or refugee status (a protected individual under the Immigration and Naturalization Act, 8 U.S.C. 1324b(a)(3)).
- Relocation assistance: No.
Tools and Technologies
- ERWin, ER Studio, Informatica, Talend
- Alation, Collibra, TAMR
- Java, Python, Scala
- SQL, Oracle, MySQL, PostgreSQL, HiveQL
- Hadoop, Spark, Hive, Cassandra, HBase
- XML, JSON
Location: Dayton, OH (onsite)