Sr. Data Modeler

VanderHouwen; Portland (OR); Remote; USD 125,000 - 150,000; Full time

Job summary

A leading staffing firm is seeking a skilled Senior Data Modeler to design and maintain enterprise-level data models in a fully remote capacity. The ideal candidate has 7+ years of experience in data modeling, proficiency in SQL, and familiarity with tools such as Snowflake and Azure. Exceptional communication skills are necessary for collaborating with non-technical stakeholders. Competitive compensation of $70-$80/hr based on experience.

Benefits

Medical insurance

Dental insurance

Vision insurance

Life insurance

401(k) matching

Qualifications

• Minimum 7 years of experience in IT development with a focus on data modeling.
• Hands-on experience with Snowflake, Azure, and Microsoft SQL Server environments.
• Expertise with data modeling tools such as Erwin, ER/Studio, Mural, or Swagger.

Responsibilities

• Design, develop, and maintain enterprise-level data models.
• Collaborate with cross-functional stakeholders to translate data requirements.
• Lead data modeling projects and enforce technical standards.

Skills

Data modeling concepts

SQL proficiency

Team collaboration

Technical communication

Troubleshooting

Education

Bachelor's degree in a related field

Tools

Snowflake

Azure

Microsoft SQL Server

SSIS

Azure Data Factory

Azure Data Lake

Erwin

Power BI

Tableau

Job description

Senior Data Modeler
Our client is seeking a skilled Senior Data Modeler to design, develop, and maintain enterprise-level data models that power business intelligence and analytics across the organization. This role requires a balance of technical depth and strong communication, as you’ll be working closely with non-technical stakeholders to ensure data solutions are understood and actionable. The ideal candidate is collaborative, clear in communication, and brings proven experience with enterprise data modeling in modern cloud environments.

This role is fully remote.

• Design, develop, and maintain data models that support enterprise BI platforms across on-premises and cloud environments.
• Collaborate with cross-functional stakeholders to understand data requirements and translate them into effective data modeling solutions.
• Lead and manage data modeling projects with internal departments and external partners to ensure integrated, scalable solutions.
• Document data models, maintain data dictionaries, and provide training to ensure usability across technical teams.
• Establish and enforce technical standards, performance tuning practices, and documentation protocols for enterprise data systems.
• Support the change control process for data systems, coordinating closely with technical and infrastructure teams.
• Provide expert-level troubleshooting and guidance for complex data integration and modeling challenges.

Senior Data Modeler Qualifications

• Bachelor’s degree in a related field or equivalent combination of education and professional experience.
• Minimum of 7 years of experience in IT development with a focus on data modeling.
• Demonstrated expertise in data modeling concepts including dimensional models, star schemas, and source-to-target mappings.
• Advanced proficiency in SQL, including stored procedures, functions, query optimization, and views.
• Must have hands-on experience with Snowflake, Azure, and Microsoft SQL Server environments.
• Skilled in data transformation tools such as SSIS, Azure Data Factory, and Azure Data Lake.
• Proficient with source control systems like Azure DevOps, Git, or Subversion.
• Excellent communication skills with the ability to explain technical solutions to non-technical stakeholders.
• Expertise with data modeling tools such as Erwin, ER/Studio, Mural, or Swagger.
• Prior experience collaborating with ETL developers to build data pipelines for reporting and analytics use cases.
• Familiarity with BI tools such as Tableau, SSRS, and Power BI is a plus.

Compensation: $70-$80/hr. (DOE)

Benefits
VanderHouwen Contractors Enjoy Exceptional Benefit Perks! As an eligible contract employee with VanderHouwen, you'll have access to a full suite of benefits designed with your well-being in mind. Our comprehensive package includes medical, dental, vision, life insurance, short- and long-term disability, and a matching 401(k) to help secure your future.

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