Data Modeler

Cambay; Reston (VA); On-site; USD 90,000 - 110,000; Full time

Job summary

Cambay is looking for a skilled Data Modeler based in Reston, VA. The role involves translating business requirements into logical data models, conforming to modeling processes, and delivering essential data artifacts for successful BI initiatives.

The ideal candidate will have at least five years of experience in data modeling, expertise in relational and dimensional modeling, and proficiency with tools like ER Studio and ERWin. Strong analytical skills and the ability to work effectively with diverse teams are essential for success in this position.

Qualifications

• Minimum of five years’ hands-on experience in data modeling.
• Strong analytical skills with a problem-solving approach.
• Experience with data management standards and practices.

Responsibilities

• Translate business and data requirements into logical data models.
• Conform with modeling processes and procedures.
• Deliver data models, data dictionaries, and project artifacts.

Skills

Data modeling expertise

Relational modeling

Dimensional modeling

Analytical skills

Work with multifunctional teams

Experience with ER Studio

Experience with ERWin

Experience in database design

Proficiency in Microsoft Excel

Tools

ER Studio

ERWin

Microsoft Excel

Job description

Cambay Consulting Business Intelligence Consulting Services comprise low-risk, high-impact, short-cycle diagnostic and assessment studies that facilitate the execution of a client organization's BI/DW initiative at its various lifecycle stages. The Business Intelligence Solutions practice helps clients articulate problem definition and then propose alternate solutions and best practices, and recommend an implementation plan. The deliverables enable clients to take quick and well-informed decisions for the success of the BI/DW initiative.

Our area of focus in BI Technology to develop Agile and economic solutions is using the following products:

• Microsoft SQL Server 2008 R2
• SSIS - SQL Server Integration Services
• SSRS - SQL Server Reporting Services
• SSAS - SQL Server Analysis Services
• Oracle 10g RAC
• SAP Crystal Reports
• SAP Business Objects
• SAP Crystal Reports Dashboard

Job Description

Title: Data Modeler
Location: Reston, VA

Key Job Functions

• Translate the business and data requirements into logical data model.
• Conform with modeling process and procedures.
• Ability to clearly walk thru the model with design/architecture/delivery teams.
• Deliver data models, data dictionaries, data maps, and other data modeling artifacts per established project plans.

Required Knowledge and Skills

• Minimum of five years’ hands‑on experience in data modeling.
• Expertise in relational and dimensional modeling in OLTP and Data Warehousing environment.
• Expertise with data management standards and data model practices.
• Strong analytical skills with a problem‑solving approach capable of managing multiple priorities.
• Work effectively with multifunctional teams and ability to build good working relationships.
• Experience with ER Studio, ERWin modeling tools and ER/Studio Repository or ERWin Model Mart.
• Experience in database development, design, and best practices.
• Experience in Microsoft Excel, Pivot Tables, Pivot Charts.

Desired Knowledge and Skills

• Prior mortgage experience.
• Schema‑On‑Read modeling (Hadoop/Hive) & Redshift physical modeling experience preferred.

EEO Statement

All your information will be kept confidential according to EEO guidelines.