Senior Data Modeler

Description

Job Id: 65064

Senior Data Modeler
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. They provide complex development and recommend solutions.

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 work with network administrators to establish security protocols. 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.

Senior Data Modeler Qualifications
Bachelor's Degree from an accredited college or university or equivalent practical and relevant experience.
Seven (7) years of IT BSA experience.
This position must pass a criminal history records check.
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).
Expert 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 Knowledge and Skill with Cloud API and Microsoft Azure API management (Postman).
Working Knowledge and Skill – Cloud Technology (Azure etc).
Advanced experience in data warehousing design, BI concepts and best practices.
Advanced experience working with developers to build ETLs for loading data for reporting.

Experience that provides a plus:
Tableau experience.
SSRS experience.
Power BI experience.
Snowflake experience.

Salary: $75-$85/hr. (DOE) 

Benefits
Benefits are available to eligible VanderHouwen contractors and include coverage for medical, dental, vision, life insurance, short and long term disability, and matching 401k.

About VanderHouwen 
VanderHouwen is an award-winning, Women-Owned, WBENC certified professional staffing firm. Founded in 1987, VanderHouwen has been successfully placing experienced professionals throughout the Pacific Northwest and nationwide. Our recruitment teams are highly specialized in either Technology and IT, Engineering, or Accounting and Finance career markets. Our recruiters value building meaningful, professional relationships with each candidate as well as developing honed knowledge of companies' staffing needs and workplaces. Partner with us to land your next exciting career.

VanderHouwen is an Equal Opportunity Employer and participates in E-Verify. VanderHouwen does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state or federal civil rights laws.

#LI-Remote