Data Modeler

Overview

On Site
$140,000 - $170,000
Full Time

Skills

Data Modeling
Data Modelling
SQL
Star Schema
Erwin
Power Designer
Data Warehousing
ETL

Job Details

Note: This is a fulltime and onsite/hybrid opportunity.

Job Role: Data Modeler
Location: Charlotte, NC


Job Description

Data Modeler

Must Have Technical/Functional Skills

  • Architect knowledge and good experience in star schema for data modelling.
  • Advanced skills in SQL and database design principles
  • Expertise in data modeling methodologies (3NF, Star Schema, Snowflake Schema)
  • Strong understanding of SQL and data modeling concepts
  • Proficiency in data modeling tools such as Erwin or Power Designer or similar tools
  • Experience in designing and implementing database structures
  • Ability to create and maintain conceptual, logical, and physical data models
  • Familiarity with data warehousing and ETL processes
  • Knowledge of industry best practices for data modeling and database design
  • Ability to collaborate with cross-functional teams to gather and analyze data requirements
  • Experience in performance tuning and optimization of database queries
  • Strong analytical and problem-solving skills- Excellent communication and documentation skills.
  • Experience with SQL Server, SSRS, SSIS, and SSAS tools or any other relevant ETL or Reporting tools preferred.
  • Comfortable making decisions and leading.
  • A problem solver and critical thinker.
  • Familiar with version control and relational databases.

 

Roles & Responsibilities

  • Develop and maintain complex data models for business data analysis and reporting purposes.
  • Collaborate with stakeholders and cross-functional teams to understand data requirements and design appropriate data models that align with business needs.
  • Evaluate and recommend data modeling tools and technologies to improve efficiency and accuracy of data modeling processes.
  • Create and maintain data dictionaries and metadata repositories to ensure consistency and integrity of data models.
  • Identify and resolve data model performance issues to optimize database performance and enhance overall system functionality.
  • Document and communicate data model designs and standards to ensure understanding and compliance across the organization.
  • Stay current with industry best practices and trends in data modeling and incorporate new techniques and methodologies into our data modeling processes


ABOUT Ztek:

Website:

Ztek Consulting Inc is a minority- and woman-owned business enterprise that leverages a unique blend of human talent, machine learning algorithms, and artificial intelligence to provide customized talent management solutions for clients. Ztek s diversity-focused hiring models have proven successful, particularly in hiring veterans. The company's veteran-focused hiring and deployment program, Z-V.E.T, matches skilled veterans with clients' needs in various areas.

Ztek Consulting | Talent Matters

 

Ztek is a minority and woman-owned business enterprise that provides customized talent management solutions for clients.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.