What are the responsibilities and job description for the Data Modeler position at Avance Consulting?
Job Description
Data Modeler
Juno Beach, FL
JD
Must be a US Citizen/green card holder
Must be willing to work from client location at Juno Beach, Florida
Experience with AWS Redshift is a must
Create logical and physical data models using enterprise best practices and standards to ensure high quality and reduced redundancy.
Optimize and update conceptual and physical data models to support new and existing projects.
Be a subject matter expert for all data modeling activities.
Evaluate data models and physical databases for variance and discrepancies and validate business data objects for accuracy and completeness
Strong expertise in understanding current architecture and translating into conceptual data model supporting long term business needs.
Experience in understanding, analyzing and implementing relational, star, entity-relationship, multi-dimensional and object oriented database models
Good working knowledge of SQL
Experience in creating datasets for Power BI dashboards
Excellent consulting and communication skills.
Strong analytical skills with ability to collect, organize, analyze and disseminate information with the attention to detail and accuracy.
