Job Description SummaryThe Sr Data Architect is primarily responsible for the design, implementation and maintenance of data integration between multiple systems to support the needs of the AI team and Enterprise Solutions Teams. The position is responsible for recommending and developing user inter
JSfirm

Sr Data Engineer

GE Aerospace • 
Cincinnati, Ohio, United States
Position Type: Permanent
Job Description:
Job Description SummaryThe Sr Data Architect is primarily responsible for the design, implementation and maintenance of data integration between multiple systems to support the needs of the AI team and Enterprise Solutions Teams. The position is responsible for recommending and developing user interfaces and data flows to ensure high data quality standards, repeatability and scalability of data models are designed and maintained and data redundancy is reduced. General tasks and responsibilities will include: Understand and translate business needs into short-term and long-term data flow strategies to satisfy enterprise architecture and development cycle needs; Work with the AI team to design and implement data strategies, build data flows and develop conceptual, logical and technical data models and ETL processes. Optimize and update user interfaces and data models to support new and existing projects. Develop best practices for standard naming conventions and coding practices to ensure consistency of data models. Recommend opportunities for reuse of data models in new environments. Perform reverse engineering of data models from databases and SQL scripts. Adopt best practices in developing reports and analytical insights including data integrity, testing, analysis, validation, and documentation. Validate business data objects for completeness and accuracy. Analyze data-related system integration challenges and propose appropriate solutions. Develop data models according to enterprise standards. 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

In this role, you will:

- 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

- Bachelors Degree in Computer Science or “STEM” Majors (Science, Technology, Engineering and Math)

- Three (3) years of responsible experience in the field of data processing, applications and software development.

Desired Characteristics Technical Expertise:

- Five (5) years of responsible experience in the field of data processing, applications and software development.
- Exposure to Extract, Transform & Load (ETL) tools like Informatica or Talend.
- Hands-on experience in programming languages like Python and Java.
- 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.

- Exposure to industry standard data catalog, automated data discovery and data lineage tools (e.g., Alation, Collibra, TAMR).

- Exposure to industry standard data modeling tools (e.g., ERWin, ER Studio).

- Exposure to and understanding of Artificial Intelligence.

- Have built solutions with public cloud providers, such as AWS, Azure, or GCP.

Leadership Skills:
- Ability to work effectively with multi-disciplinary teams (e.g., UX, GE Business teams, AI teams, Enterprise Solutions 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 Information

GE offers a great work environment, professional development, challenging careers, and competitive compensation. GE 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 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).

Relocation Assistance Provided: No

LI-Remote - This is a remote position
(Job and company information not to be copied, shared, scraped, or otherwise disseminated/distributed without explicit consent of JSfirm, LLC)

JSfirm, LLC

Roanoke, TX

jobs@jsfirm.com

JSfirm LLC, Privacy Policy

All rights reserved. 2001-2024 JSfirm