JobRialto
Data Modeler
JobRialto, Houston, Texas, United States, 77246
Job Description:
Roles and Responsibilities:
Possess a Business/Process Analyst view and work closely with data owners to develop an in-depth understanding of their data needs.
Represent business concepts, their definitions, properties, and relationships via modeling.
Design and maintain domain based conceptual and logical data models.
Collaborate with Application leads and ETL Lead from various data domains to ensure consistency of data models and other deliverables.
Experience and Skills
10+ years of relevant experience in Datawarehouse & DataMart
Hands on experience with using tools to document process, data models, flows and requirement management using tools such as Erwin, SQL Developer, Excel, Visio, PowerPoint, Confluence, Jira.
7+ yrs. of professional experience with in-depth Conceptual / Logical/ Physical Data Modelling skillset.
Recent 5+ years must be in OLAP/Data Warehouse Data modeling experience.
Strong in SQL, PLSQL and good understanding of Oracle E-Business Suite data tables (functional aspect) and oracle cloud ERP (SCM, Inv).
Demonstrated ability in developing domain based conceptual and logical data models.
Good understanding of data management concepts - data models, data governance, data quality, metadata management, master data management, data profiling and data pipeline design.
Good to have knowledge on Inmon Architecture (Preferred) and/or Kimball Architecture and dimensional modelling
Comfortable driving execution of tasks with limited information or ambiguity, and mentoring junior data analysts, ETL developer and Data quality analyst
Excellent organizational skills, attention to detail, ability to monitor linkages/dependencies and tight deadlines
Clarity and precision in oral/written communication
Strong collaboration skills, with good track record in establishing partnerships and teamwork
Education:
Bachelors Degree
Roles and Responsibilities:
Possess a Business/Process Analyst view and work closely with data owners to develop an in-depth understanding of their data needs.
Represent business concepts, their definitions, properties, and relationships via modeling.
Design and maintain domain based conceptual and logical data models.
Collaborate with Application leads and ETL Lead from various data domains to ensure consistency of data models and other deliverables.
Experience and Skills
10+ years of relevant experience in Datawarehouse & DataMart
Hands on experience with using tools to document process, data models, flows and requirement management using tools such as Erwin, SQL Developer, Excel, Visio, PowerPoint, Confluence, Jira.
7+ yrs. of professional experience with in-depth Conceptual / Logical/ Physical Data Modelling skillset.
Recent 5+ years must be in OLAP/Data Warehouse Data modeling experience.
Strong in SQL, PLSQL and good understanding of Oracle E-Business Suite data tables (functional aspect) and oracle cloud ERP (SCM, Inv).
Demonstrated ability in developing domain based conceptual and logical data models.
Good understanding of data management concepts - data models, data governance, data quality, metadata management, master data management, data profiling and data pipeline design.
Good to have knowledge on Inmon Architecture (Preferred) and/or Kimball Architecture and dimensional modelling
Comfortable driving execution of tasks with limited information or ambiguity, and mentoring junior data analysts, ETL developer and Data quality analyst
Excellent organizational skills, attention to detail, ability to monitor linkages/dependencies and tight deadlines
Clarity and precision in oral/written communication
Strong collaboration skills, with good track record in establishing partnerships and teamwork
Education:
Bachelors Degree