Job Description

Essential Responsibilities:

In this role, you will:

- Design & 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 or sensor generated data and target data repositories
- Design & 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
- Build a variety of data loading & data transformation methods using multiple tools and technologies.
- Design & build automated Extract, Transform & Load (ETL) jobs based on data mapping specifications
- Manage 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 changes to downstream systems/products and recommend alternatives to minimize the impact.
- Derive solutions and make recommendations from deep dive data analysis proactively.
- Design and build Data Quality (DQ) rules.

- Familiar with XML - including XML syntax, schemas

- Familiar with querying REST data sources returning XML Javascript, JSON

- Attitude - ability to "dig in" and work through ambiguity to unknowns to find answers. I think this is critical.

Qualifications/Requirements:

For roles outside USA:

Bachelor's Degree in Computer Science or "STEM" Majors (Science, Technology, Engineering and Math) with advanced experience.

For roles in USA:Bachelor's Degree in Computer Science or "STEM" Majors (Science, Technology, Engineering and Math) with minimum years of experience 5years

Desired Characteristics:

Experience with IBM Engineering Lifecycle Management (ELM), Engineering Workflow Manager (EWM), Engineering Test Manager (ETM), and Engineering Requirements Manager (ERM). Experience using the API's and security model within those tools. Experience with reporting tools such a IBM Rational Publishing Enginer (RPE), Business Intelligence Reporting Tool (BIRT), IBM Report Builder, and/or Spotfire. Understanding of cybersecurity, CMMC, and/or Export Control regulations. Jenkins automation or other CI/CD experience. Scrum/agile experience.

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

- BM Jazz reporting experience.

• Humble: respectful, receptive, agile, eager to learn
• Transparent: shares critical information, speaks with candor, contributes constructively
• Focused: quick learner, strategically prioritizes work, committed
• Leadership ability: strong communicator, decision-maker, collaborative
• Problem solver: analytical-minded, challenges existing processes, critical thinker

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:

- A good team player with self-driven execution capabilities.
- Ability to communicate ideas clearly with cross teams.
- Ability to showcase teamwork skills to achieve common goals, provide resolutions and share ideas.
- Demonstrate the presentation and influencing skills

Note
This Job Description is intended to provide a high level guide to the role. However, it is not intended to amend or otherwise restrict/expand the duties required from each individual employee as set out in their respective employment contract and/or as otherwise agreed between an employee and their manager.

Additional Information

Relocation Assistance Provided: No