Data Modeler

TechDigital Group; Raleigh (NC); On-site; USD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Data Modeler to join their dynamic team. In this pivotal role, you will be responsible for developing and maintaining data models, conducting thorough data analysis, and collaborating closely with business stakeholders to translate requirements into effective data solutions. You will leverage your expertise in SQL Server and data modeling to ensure optimal performance and consistency with existing data architectures. This role offers an exciting opportunity to contribute to impactful projects within a supportive and innovative environment, where your skills will be valued and your contributions recognized.

Qualifications

• 5+ years of experience with enterprise databases and data modeling.
• Strong communication skills for collaborating with business stakeholders.

Responsibilities

• Develop and maintain data models, data dictionaries, and integration with enterprise architecture.
• Conduct data analysis and collaborate with business owners on requirements.

Skills

Data Analysis

Communication Skills

Agile Methodologies

Data Modeling

SQL Server

ERwin

Azure DevOps

Data Dictionary Creation

Tools

SQL Server Management Studio

Visual Studio

RedGate

Job description

Responsibilities:

1. Perform development or maintenance work on data models, data dictionaries, CRUD matrix, flowcharts, design justifications or other artifacts to meet corporate standards, integration with enterprise data architecture and company goals.
2. Conduct data analysis and capture data requirements.
3. Strong communication skills including written and oral, with ability to work closely with sponsors, business owners, and analysts on requirements and use case design.
4. Create data dictionary and metadata around the data elements. Responsible for defining the source repositories and rules around the transformations.
5. Experience working in Agile or Scrum methodologies.
6. Create the logical and physical models.
7. Strong knowledge of SqlServer or other enterprise databases (5 yrs. exp), ERwin, SqlServer Management Studio, Visual Studio.
8. Contribute to large modeling projects with other data modelers at remote sites.
9. Experience with Azure DevOps, RedGate a plus.
10. Participate in business requirements gathering, perform data analysis, design logical data models, and participate in the design of physical data models.
11. Work with customers to understand and derive meaningful data relationships and translate them into appropriate data models.
12. Serve as a reference and authority on the process of data modeling and ensure consistency with existing data models and data architectures, published standards, and guidelines.
13. Develop, review, approve new data models and enhance existing models.
14. Validate logical data models with business subject matter experts.
15. Work with other members of the development team to ensure all requirements are captured and reflected in the data model.
16. Work with DBA team to design physical models to satisfy optimal performance.
17. Participate in best practices and standards development.
18. Train/mentor others in data modeling.
19. Actively participate in metadata definition and management.
20. Actively participate in designing the data access layer.

Assist and backup DW/BI architect in support of data warehouse/business intelligence functions.