Senior Data Engineer

About the role

GE Aerospace is hiring a Senior Data Engineer in Dayton. The engineer designs, develops, tests and implements data engineering processes that produce analytical and reporting solutions, prepares data for data science outcomes, manages metadata structures and supports post-deployment activities. Automation opportunities, including AI tools, should be sought to reduce manual work, and results must be delivered on time using agile methodologies.

Key responsibilities

• Build technical data dictionaries and support business glossaries to analyze datasets
• Perform data profiling and analysis for source systems, manually maintained data, machine-generated data and target repositories
• Develop logical and physical data models for OLTP and OLAP solutions
• Develop and maintain data mapping specifications and perform data loads and transformations
• Build automated ETL jobs and maintain metadata structures for reusable ETL components
• Analyze reference datasets, master data management tools and the impact of downstream systems, then recommend solutions
• Design and build data quality rules

Required profile

• Bachelor's degree with at least 2 years of professional experience, or an Associate degree with 5 years, or a high school diploma with 7 years
• Military experience counts as professional experience
• Legal authorization to work in the U.S.; visa sponsorship is not offered
• Access to U.S. export-controlled information is required, contingent on proving U.S. person status (citizen, permanent resident, asylee or refugee)

Required skills

• Data modeling tools such as ERWin or ER Studio
• ETL tools such as Informatica or Talend
• Data catalog, automated discovery and data lineage tools such as Alation, Collibra or TAMR
• Programming in Java, Python or Scala
• SQL for Oracle, MySQL, PostgreSQL or HiveQL
• Big data platforms such as Hadoop, Spark, Hive and NoSQL databases such as Cassandra or HBase
• Handling XML and JSON files and exploratory data analysis