Job Title: IT - Application - Data Modeler Level IV
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
Technical Competencies:- 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
