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.