DATA MODELER

Overview

Remote
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Data Modeler
ERWIN
AZURE
Snowflake

Job Details

This should be an Azure / SQL Server person with Snowflake, who specifically focuses on data modeling.

Scope of Work: The IT Data Modeler Senior is a highly skilled and experienced professional responsible for designing, developing, and maintaining data models for the organization. They will work with stakeholders to understand their data needs and develop solutions that meet those needs.

The IT Data Modeler Senior is responsible for documenting and maintaining the data models, as well as training others on how to use them.

In addition to these duties, the IT Data Modeler Senior is responsible for leading and managing data modeling projects in collaboration with departments and outside agencies to build integrated solutions. They build consensus with management, users, and vendors to problem solve development needs, formulate scope and objectives for data modeling projects and define outcomes.

The IT Data Modeler Senior provides expert design, development, performance tuning, and maintenance of complex mission critical data and analytic systems. They establish and enforce database technical, procedural, and documentation standards. They provide troubleshooting and technical assistance to staff on the most complex database problems. They manage the database system change control process, coordinating efforts of network and technical staff.
Required Skills and Abilities: Bachelor's Degree from an accredited college or university or equivalent practical and relevant experience.
Nine(9) years of IT Development/Data Modeling Experience
This position must pass a criminal history records check.

The skills:
Advanced knowledge of or skill in Snowflake
Advanced knowledge of or skill in Azure
Expert level of skills and knowledge around Data Modeling techniques and processes (including Dimensional Models, Star Schemas. Fact and Dimension Entities, Fact and Dimension Attributes, source to target mappings)
Expert level of skills with Data Modeling tools (example: Erwin, Mural Boards, Swagger)
Advanced level of skill with SQL programming including stored procedures, query plans, functions and views
Advanced knowledge of or skill in Microsoft SQL Server Integration Services (SSIS)
Advanced Knowledge and Skill - Data Transformation Tools (SSIS, Azure Data Factory, Azure Data Lakes, Cloud, etc)
Advanced Knowledge and Skill - Source control (Azure DevOps, Subversion, GIT)
Advanced experience in data warehousing design, BI concepts and best practices
Advanced experience working with developers to build ETLs for loading data for reporting
* Tableau experience
* SSRS experience
* Power BI experience
* ER Studio for Data Modeling

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.