Vacancy expired!
Role:Data MOdelerLocation: REMOTE in CA, NV, TX, FLDuration: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:SQLTeradataAzure data stack: ADF, Databricks, ADLS, SynapseBhargavi AnkamIT RecruiterStaffing | Thoughtwave Software and Solutions Limitedwww.thoughtwavesoft.com314 N. Lake St, Suite 6, Aurora IL 60506