Sr Data Engineer

-; West Chester (Chester County); On-site; USD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Data Engineer to design and implement innovative data engineering processes. This role involves analyzing datasets, building data models, and developing automated ETL jobs to support data science outcomes. The ideal candidate will have a strong foundation in programming languages such as Java and Python, along with experience in SQL and data modeling tools. Join a dynamic team that values collaboration and offers opportunities for professional growth in a supportive environment. If you're passionate about data and eager to make a significant impact, this is the perfect opportunity for you.

Benefits

Professional Development

Challenging Careers

Competitive Compensation

Relocation Assistance

Qualifications

• Minimum 2 years of experience in data engineering or related field.
• Experience with data modeling and ETL processes.
• Hands-on experience with programming languages and SQL.

Responsibilities

• Design and implement data engineering processes for analysis.
• Build and maintain data models and ETL jobs.
• Analyze datasets and ensure data quality.

Skills

Data Analysis

SQL

Java

Python

Data Modeling

ETL Tools

Big Data

Data Quality

Education

Bachelor's Degree

Associate's Degree

High School Diploma

Tools

Informatica

Talend

ERWin

Alation

Collibra

Job description

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. Accountable to deliver results in a timely manner using agile methodologies.

Job Description

Roles and Responsibilities

• Support data engineering activities in Cost as a Technology team for multiple products in the team including Prodigy
• 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

Education 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.

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:

• Ability to work effectively with multi-disciplinary teams (e.g., UX, GE Business teams) and understand the inter-dependencies between them.
• Ability to showcase teamwork skills to achieve common goals, provide resolutions and share ideas.
• Demonstrate the presentation and influencing skills

Additional Job Description

Compensation Grade

LPB2

This role requires access to U.S. export-controlled information. Therefore, for applicants who are not asylees, refugees, lawful permanent residents or U.S. Citizens (i.e., not a protected individual under the Immigration and Naturalization Act, 8 U.S.C. 1324b(a)(3), otherwise known as a U.S. Person), final offers will be contingent on the ability to obtain authorization for access to U.S. export-controlled information from the U.S. Government.

Additional Information

GE Aerospace offers a great work environment, professional development, challenging careers, and competitive compensation. GE Aerospace is an Equal Opportunities 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.

Relocation Assistance Provided: Yes