Data Architect / Data Modeler (SAP)

First Genesis; St. Louis (MO); On-site; USD 90,000 - 120,000; Full time

Job summary

First Genesis in St. Louis, Missouri is looking for a Data Architect/Data Modeler to lead data design initiatives within the Data and Analytics team. The successful candidate will develop data architecture solutions, manage data quality, and ensure effective data governance.

The ideal applicant will hold a Bachelor’s degree and possess at least 5 years of experience in SAP Data Management, alongside proficiency in SQL and data modeling techniques. This dynamic role requires strong critical thinking and communication skills.

Qualifications

• Minimum 5 years’ experience in SAP Data Management and Governance.
• Advanced competency in SQL and database handling languages.
• Expert in physical and logical data modeling.

Responsibilities

• Create and manage data architecture and workflows.
• Conduct data quality management and governance.
• Collaborate with teams to translate data requirements into solutions.

Skills

Critical thinking

Analytical skills

Communication

Leadership

SQL

Data modeling

Data governance

BI and Data visualization

Education

Bachelor’s Degree in Engineering Technology, Computer Science, or closely related field

Tools

TOAD for Oracle

SQL Server Database

SAP HANA

R Programming

Tableau

SSMS

SSIS

Access

Excel

Data Services

Job description

Location: Houston, TX

Job Description:

Title: Data Architect/Data Modeler

Need: We have an immediate opening for a Data Design Lead on the Data and Analytics team. The team works closely with the business to proactively develop solutions, deliver training, and understand the current and future technologies needed to understand data.

Work environment: The work environment is fast paced and dynamic. Individuals will be handling multiple activities in a team as well as individual contributor environment.

Primary functions: data architecture, data development and design, data quality management, reference and master data management, data integration, data governance

Primary Deliverables: Data architecture, data workflow logical models, physical source data models, data profiling reports and data audits, data definitions, data taxonomy, data metrics, meta-data, data lineage, data cleansing services

Activities: data modeling, data audit, detailed data design, define rules, establish master data solutions, define hierarchies and affiliations, distribute reference and master data, profile/analyze/assess data quality, design data quality management procedures, clean and correct data quality defects, establish data governance

Requirements:

• Demonstrate critical thinking, analytical skills, and employ judgment to offer thoughtful, concise input toward resolutions of problems.
• Be able to translate data requirements into business processes and reverse engineer business processes into data requirements. Comprehension of DevOps and Agile development and application to data centric architecture and solutions.
• Strong communication and interpersonal skills with strong English proficiency.
• Leadership skills needed to successfully promote ideas, coordinate work activities, and plan deliverables within a project team.
• Minimum Bachelor’s Degree in Engineering Technology, Computer Science, or closely related field.
• A minimum of 5 years’ experience in SAP Data Management and Governance, SAP Data Services (Data Extract, Data Profiling, de-duplication).
• Advanced competency in TOAD for Oracle, SQL Server Database, SAP HANA, R Programming and Tableau.
• Advanced expert database handling languages (SQL and variants).
• Expert in data modeling (physical and logical), ER diagrams, data dictionary, data map, normalize/denormalize, agile data modeling.
• Expert in data manipulation tools such as: SSMS, SSIS, TOAD, Access, Excel, Info Steward, Data Services.
• Practical skill sets in BI and Data visualization tools.
• Knowledge of other programming languages and ability to write code (i.e. VBA, python, XML).
• Working knowledge of ETL.
• Working knowledge of SAP.
• Basic Project Management and Business Process modeling.

Additional Information

All your information will be kept confidential according to EEO guidelines. #3568