Data Modeler Job at ClearpointCo, Houston, TX

bHRMSDNGRExXVHhNUEc2bGZ0azZFNnM9
  • ClearpointCo
  • Houston, TX

Job Description

********* NO THIRD PARTIES PLEASE********

This is a contract to hire position for a very stable organization. Great teammates and a great opportunity for growth and a long career. I-10 West Houston area location for the company.

****The position is REMOTE; however, I am seeking a local Houston candidate as there will be periodic times to come into the office for team meetings. Texas area candidates that are willing to relocate to Houston or at the very least commit to coming to periodic on-site team meetings.

Summary:

Seeking a Data Modeler that will be responsible for cleaning up to optimize workflows.

This position will require strong hands-on Data Modeler experience. MUST have strong Microsoft Fabric experience, which is a key component for this particular role.

Requirements:

- 7+ years of Data Modeling experience

- 3+ years in data modeling or analytics engineering with strong SQL.

- Must have 2-3 years plus of hands-on Microsoft Fabric experience.

- Lakehouse/Warehouse, One Lake, Delta tables, Dataflows Gen2 or Pipelines; familiarity with SQL endpoint usage.

- Star schemas; fact types (transactional, periodic snapshot, accumulating); bridge tables for M: N; degenerate and junk dimensions.

- SCD Type 1/2 with MERGE; effective/expiry dating; handling late-arriving data.

- Power BI semantic modeling and DAX

- Clean tabular model design; CALCULATE/KEEPFILTERS/USERELATIONSHIP; date intelligence; semi-additive measures; model properties (data types, sort-by, formatting).

- Incremental refresh; basic aggregations; RLS.

- Define tests (unique/not-null/accepted values), document metrics, manage endorsements; apply sensitivity labels for PII/regulated data.

Translate stakeholder requirements into grain/facts/dimensions and certified measures; collaborate across DE, BI, and business teams.

Job Tags

Contract work, Work at office, Local area, Remote work, Relocation,

Similar Jobs

The Middlesex Corporation

Parts Specialist - Heavy Equipment Job at The Middlesex Corporation

 ...preventative maintenance schedules Receive, inspect, and verify shipments of parts for accuracy and damage Maintain accurate inventory records using inventory management software Organize and label parts storage areas to optimize space and retrieval efficiency Issue... 

Regency Pacific Management

Medication Aide Job at Regency Pacific Management

 ...compassionate care in a nurturing environment. We are looking for caring and compassionate individuals to join our team. As a medication aide, you assist our senior residents in their daily well-being, including personal services, medication assistance, and social-... 

T3W Business Solutions, Inc.

Sr. Data Scientist Job at T3W Business Solutions, Inc.

T3W Business Solutions, Inc. is a Woman-Owned Small Business with Headquarters located in San Diego, CA. It is our mission to help our clients develop strategies to optimize their use of space and resources resulting in maximum benefits; we also deliver quality data and...

Reading Area Community College

Bilingual Connection Coach - College Advisor Job at Reading Area Community College

 ...Reframing Enrollment and Advising through the implementation of coaching, proactive advising, and early interventions while...  ...successful. These student interactions take place both in person and online, with over 50% of the Student Success Center appointments occurring... 

Gardens of Eastbrooke

Certified Medication Aide Job at Gardens of Eastbrooke

 ...purpose of your job position is to assist in the administering of medications to residents as ordered by the attending physician, under the...  .... Delegation of Authority As Certified Medication Aide you are delegated the administrative authority, responsibility...