Source description
About the role
Role:Data MOdeler
Location: REMOTE in CA, NV, TX, FL Duration:12 Months
Must haves: 7 years of data warehouse experience, 2-3 years in Azure cloud, SQL, Teradata, Azure data stack: ADF, Databricks, ADLS, Synapse
Responsibilities
Engage the business users to assess their BI and Analytics needs. Review the business process and conceptualize the entities that interoperate within the business process. Determine how the various entities are related and develop entity relationship diagrams that represent the connections among the entities. Identify each entity's characteristics and properties and ensure that the entities can be differentiated within the model. Develop a logical data model and validate the model to ensure that it serves the needs of the business application and its consumers. Transform the logical representation of the model into a physical representation and work with database administrators to instantiate and manage the data. Collaborate with the BI and Analytics teams on creating the optimized, reusable dimensional model, complete with metadata and lineage information. Optimize the model to ensure predictable performance. Maintain the metadata -- the "data about the data" describing the data model, its structure, and semantics. Recommend and establish standards, guidelines, and procedures for design and maintenance. Build models using Erwin and maintain these models in the Erwin mart.
Basic Qualifications: SQL Teradata Azure data stack: ADF, Databricks, ADLS, Synapse
Bhargavi Ankam IT Recruiter Staffing | Thoughtwave Software and Solutions Limited 6306891366 bhargavi@thoughtwavesoft.com www.thoughtwavesoft.com 314 N. Lake St, Suite 6, Aurora IL 60506
More at Thoughtwave Software and Solutions