Data Modeler

ROLE: Data ModelerOnsite Location
Experience/Preferred Skills Required:

• Experience with SQL server, Azure Synapse Analytics, Azure Databricks, Big Data, and Azure SQL PaaS DB is preferred.
• Experience in Information Technology and 7+ years of Data Modeling experience.
• Proven track record of experience in data modeling and evaluating data from multiple sources, reconciling conflicts, decomposing high-level data into details as well as taking details and bringing to a higher level for general communication. Experience with data profiling, cleansing, and conforming rules.
• Strong working experience in interpreting business information requirements to create new and update existing Conceptual, Logical, Physical (both dimensional and relational) data models in OLTP, ODS / OLAP (data warehouse), and integration environments.
• Strong working experience with Erwin Data Modeler tool or other tools
• Experience creating SQL queries to perform data profiling and determine cleansing and conforming requirements without tools mandatory.
• Experience in ETL, Data Warehousing, ODS Data Marts, and performance tuning methods.
• Knowledge of emerging modeling techniques and experience in physical data modeling for relational and NoSQL/unstructured databases .
• Ability to communicate with others in a diverse business and IT environment from both cultural and experience aspects. Should have good communication and writing skills.
• Experience in Big Data, ETL tools such as ADF, Informatica or Data Stage ETL tool.