Data Engineer

GE Aerospace; Arkansas City (KS); On-site; USD 90,000 - 120,000; Full time

Job summary

GE Aerospace is seeking a data engineer to develop, test, and implement data solutions that generate analytical and reporting outputs. You will analyze data needs for data science outcomes, manage metadata structures, and support post-deployment activities as required.

You will build automated ETL jobs, create data mappings, and ensure data quality. The role includes designing and maintaining Spotfire dashboards and providing daily dashboard support for customers.

Qualifications

• Bachelor's degree or equivalent with 1+ years of experience, or an associate with 4+ years, or high school with 6+ years.
• Proven ability to analyze datasets using data dictionaries and business glossaries.
• Experience building and validating ETL mappings and data quality rules.
• Experience with Spotfire or similar BI dashboards is a plus, along with data modeling concepts.

Responsibilities

• Analyze datasets using data dictionaries and glossaries.
• Develop ETL jobs and data mappings from functional requirements.
• Load and transform data using multiple tools/technologies.
• Validate mapping results against expected outputs.
• Design, develop, and support Spotfire dashboards.
• Perform daily maintenance of dashboards and analytical solutions.

Skills

Data profiling

SQL scripting

ETL development

Python/Java/Scala

Big data technologies

Power Query

Spark/Hadoop

NoSQL databases

XML/JSON handling

Education

Bachelor's degree

Associates degree

High School Diploma

Tools

Informatica

Talend

Oracle

MySQL

PostgreSQL

Hive

Hadoop

Spark

NoSQL (Cassandra/HBase)

Job description

Job Description Summary

Responsible for developing, testing and implementing data engineering solutions 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.

Job Description

Roles and Responsibilities

In this role, you will:

• Leverage technical data dictionaries and business glossaries to analyze the datasets
• Perform data profiling and data analysis for any source systems and the target data repositories
• Understand metadata and the underlying data structures needed to standardize the data load processes.
• Develop 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
• Validate the data mapping results and match with the expected results
• Implement Data Quality (DQ) rules provided
• Design, develop, implement, and support Spotfire reporting dashboards.
• Daily maintenance support of dashboards

Minimum Qualifications

Bachelor's degree from accredited university or college with minimum of 1 years of professional experience OR Associates degree with minimum of 4 years of professional experience OR High School Diploma with minimum of 6 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.
• Ability to be on-site for the role to support customers.

Preferred Qualifications

• Ability to understand logical and physical data models, big data storage architecture, data modeling methodologies, metadata management, master data management & data lineage techniques
• Hands-on experience in programming languages like Java, Python or Scala
• Hands-on experience in writing SQL scripts for Oracle, MySQL, PostgreSQL or Hive
• Experience in handling both Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) data models
• Experience in Excel's modern analytics suite, specifically data modeling via Power Query and structured reporting through Pivot Tables
• 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
• Exposure to Extract, Transform & Load (ETL) tools like Informatica or Talend

Domain Expertise

• Exposure to handling machine or sensor datasets from industrial businesses
• Knowledge of for industrial applications in a commercial/finance/industrial/manufacturing settings.
• Exposure to finance and accounting data domains

Leadership skills

• Partner with other team members to understand the project objectives and resolve technical issues.
• Communicate project status or challenges in a clear and concise manner to the cross team members.

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