ZipRecruiter

Log In

1

Data Dimensions Jobs in Washington (NOW HIRING)

USM

Sr. Data Modeler BI

Washington, DC

... dimensions, and enterprise hierarchy etc. 3. Transform Logical Data Models into Physical Data ... Design for the IBM DB2 database, for the both the Integration and Access Layers in the three tier ...

Guidehouse

Sales & Marketing Data Manager

Mclean, VA

$135K - $225K/yr

The Sales & Marketing Data Manager is an internal IT role that serves as a strategic partner to ... Lead definition of key business metrics, calculations, and dimensions that enable consistent ...

Halvik

Data Architect

Arlington, VA · On-site

$73.25 - $94.25/hr

Designing strategies for handling slowly changing dimensions Preferred Skills: * Ability to ... Data Cataloging Experience (2+ years) * Architecting a data cataloging strategy for a myriad of ...

Halvik

Data Architect

Washington, DC · On-site

$175K - $185K/yr

Designing strategies for handling slowly changing dimensions Preferred Skills: * Ability to ... Data Cataloging Experience (2+ years) * Architecting a data cataloging strategy for a myriad of ...

Halvik

Data Architect

Washington, DC · On-site

$175K - $185K/yr

Designing strategies for handling slowly changing dimensions Preferred Skills: * Ability to ... Data Cataloging Experience (2+ years) * Architecting a data cataloging strategy for a myriad of ...

Halvik

Data Architect

Arlington, VA · Hybrid

$73.25 - $94.25/hr

Designing strategies for handling slowly changing dimensions Preferred Skills: * Ability to ... Data Cataloging Experience (2+ years) * Architecting a data cataloging strategy for a myriad of ...

next page

Showing results 1-20

All JobsData Dimensions JobsData Dimensions Jobs in Washington

Data Dimensions information

What are Data Dimensions?

Data dimensions are attributes or perspectives by which data can be categorized, organized, and analyzed. In the context of data management and analytics, dimensions such as time, geography, product, or customer allow users to slice and dice data for deeper insights. For example, a sales dataset might have dimensions like region and sales period, enabling users to analyze performance by different locations or times. Understanding data dimensions is essential for building effective reports, dashboards, and business intelligence solutions. They help transform raw data into meaningful information for decision-making.

What are the key skills and qualifications needed to thrive as a Data Analyst, and why are they important?

To thrive as a Data Analyst, you need strong analytical skills, proficiency in statistics, and a background in mathematics or computer science. Familiarity with data analysis tools like SQL, Excel, Python, R, and data visualization platforms such as Tableau is typically required. Excellent problem-solving, attention to detail, and effective communication skills set top performers apart in this role. These skills are essential for extracting meaningful insights from data, supporting business decisions, and clearly conveying findings to stakeholders.

What are some common challenges faced by professionals working in data dimensions roles, and how can they overcome them?

Professionals in data dimensions roles often encounter challenges related to ensuring data quality, consistency, and proper integration across multiple data sources. Managing large volumes of data and maintaining accurate dimensional hierarchies can be complex, especially in organizations with rapidly evolving datasets. To overcome these challenges, it's important to establish clear data governance practices, collaborate closely with data engineers and business analysts, and leverage robust data management tools. Continuous learning and staying updated on best practices in data modeling and warehousing also contribute to long-term success in this field.
What are popular job titles related to Data Dimensions jobs in Washington? For Data Dimensions jobs in Washington, the most frequently searched job titles are:
What job categories do people searching Data Dimensions jobs in Washington look for? The top searched job categories for Data Dimensions jobs in Washington are:
Data Dimensions jobs near you
Infographic showing various Data Dimensions job openings in Washington as of July 2026, with employment types broken down into 1% As Needed, 81% Full Time, 16% Part Time, and 2% Contract. Highlights an 85% Physical, 5% Hybrid, and 10% Remote job distribution.

Sr. Data Modeler BI

USM

Washington, DC

Full-time

Re-posted 19 days ago

Job description

Company Description

Businesses face challenges every day building responsive and agile IT capabilities to grow and stay ahead. Since everyone has access to the same tools, your competitive advantage directly depends on how you apply technology - on the people leading, supporting and optimizing your IT initiatives. USM Business Systems, established in 1999, is an industry-leading private talent management firm, specializing in providing unique IT turnkey solutions, IT staffing solutions, and Talent management insights, enabling you to sustain a truly competitive advantage in this fast-moving environment. USM has offices throughout the US and offshore delivery centers in India. USM is a certified Minority Business Enterprise and is a CMMi Level 3 Organization.

USM is recognized as one of the fastest growing IT Temporary Staffing firms in the US and most recently was ranked #3 on the list of the Top Temporary Staffing firms in the DC Metro Area - Washington Business Journal (2016).

Job Description

1. Rapidly developing dimensional models or analytical data sets based on specific business requirements. Experience in ER - dimensional model design and implementation of STAR and SNOWFLAKE schemas is a must.

2. Work with the Architecture and Governance team to set strategy for conformed dimensions, and enterprise hierarchy etc.

3. Transform Logical Data Models into Physical Data Design for the IBM DB2 database, for the both the Integration and Access Layers in the three tier architecture.

4. Engage with Data Architects, Directors and Business Users to understand data access paths and business use.

5. Apply appropriate Denormalization and Audit Balance and Control columns.

6. Perform data profiling, and business rules investigations on source data, to ensure correct design of the Integration and Access layers.

7. Map and document data transformations of data from a business terms perspective.

8. Support project delivery teams in assessing their resource needs to deliver the Integration and Access layers.

Qualifications

Job Title: Sr. Data Modeler BI

Location: Washington DC

Duration: 12+ months

GC or Citizens Only

Locals to VA, DC, MD, DE

Required Skills

Dimensional Modeling

o At least 5 year hands on experience designing and implementing Star Schemas

o At least 5 year experience implementing Data Warehouse presentation layer - including design and definition of logical tables, physical sources, dimensions, columns, aggregation rules

o At least 5 year experience in writing advanced SQL queries, views, and optimization of SQL queries

o Comprehensive Knowledge of Ralph Kimball's Data Modeling Concepts including Transaction dimensions, conformed dimensions and facts, slowly changing dimension, multi-Star/ Snowflake Schema Modeling, different types of Fact tables

o Implementing a virtual semantic layer (virtual star schema) using views on a multi-tiered normalized Integrated Operational Data Store is a huge plus

3NF (Relational) Logical and Physical Modeling

o This position is not focused on 3NF data modeling but experience with 3NF models is required

o At least 2 year hands on experience with 3NF Data Modeling and NORMALIZED schema

o Comprehensive Knowledge of Bill Inmon's Data Modeling Concepts (Logical and Physical) including 3NF, Supertypes, Subtypes, Abstraction, Associative entities / tables

o Experience with IBM DB2 Physical Modeling and Performance Tuning

Business Intelligence

o This position is not focused on BI platform but rather on the data platforms, but experience with BI platforms is required

o Hands-on experience with BI application architecture and development

o Hands-on experience in designing technical architecture, installation and configuration of BI Stack components

o Extensive knowledge in Presentation layer such as MOLAP, ROLAP, HOLAP, Ad-hoc reports.

o Experience creating mockup reports, demo, & storyline a plus

Proven ability to work in a team environment

Thrives in an environment of changing priorities

Excellent problem solving and critical thinking skills.

Additional Information

If you are interested in the below position please forward your profile to Saikirann@usmsystems(dot)com or call me on 703-880-4146.

Apply