Data Modeler

7 days ago

Houston, TX, United States Clearpoint Full time

Title: Data Modeler

Location: Houston, Texas

Type: Contract to hire

Hourly Rate: $60.00 - $65.00

Summary:

The Data Modeler design Gold-layer star schemas and Power BI semantic models. You'll partner with data engineering and BI to move data from Bronze → Silver → Gold in a Medallion architecture and deliver certified, performant metrics for leadership and operational teams responsible for cleaning up to optimize work flows. This position will require hands-on Data Modeler experience.

Duties:

- Commercial/Operations: Orders and order lines, inventory availability, shipment/fulfillment, returns, pricing, promotions, member subscriptions.

- Membership lifecycle, entitlements, course enrollments and completions (CE), event attendance, certifications.

- Product catalog (APIs, bases, devices), formulations/recipes and versioning, stability/BUD attributes, allergens, SDS/CoA linkage.

- USP 795/797/800 compliance data, audit findings, corrective actions, sensitivity labeling, support case/ticketing.

- Define model grain, surrogate keys, conformed dimensions (e.g., Customer/Account, Product, Practitioner, Date, Geography), and role-playing dimensions.

- Implement SCD Type 1/2 in Delta (Warehouse/Lakehouse) for key dims (Customer, Product, Practitioner, Membership).

- Handle late-arriving facts/dimensions, inferred members, and bridge tables for many-to-many (e.g., formulation → multiple actives/allergens).

- Build and maintain Power BI semantic models

- Clean star schemas, relationship management, hierarchies, display folders.

- Author DAX measures for revenue, margin, order volume, fill rates/OTIF, inventory days, membership MRR/retention/churn, education completions, compliance KPIs.

- Implement time intelligence (MTD/QTD/YTD, PY), semi-additive measures (inventory snapshots).

- Configure incremental refresh, aggregations where needed, and Row-Level Security (e.g., by region/account team).

- Propose partitioning/clustering/Z-ordering strategies in Delta; consider Warehouse materialized views for heavy rollups; reduce cardinality in Power BI; choose pre-aggregation vs. Aggregations in PBI.

- Specify Silver contracts and quality checks (dedupe, CDC alignment, schema expectations).

- Review Pipelines/Dataflows Gen2/Notebooks outputs for model-readiness and effective dating.

- Maintain data dictionaries, lineage, SCD behavior, and certified metric definitions; apply sensitivity labels and endorsements.

Requirements:

- 7+ years of Data Modeling experience

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

- Hands-on Microsoft Fabric

- Lakehouse/Warehouse, OneLake, 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.

  • Data Modeller

    1 day ago

    Houston, TX, United States Infosys USAAvance Consulting Full time

    Data Modeller Houston TX FulltimeRequired Qualifications: At least 4 years of experience in Information Technology. Proficiency in Data Modeling using tools like ERWIN.  ETL development experience with strong SQL background such as Python/R, Scala, Java, Hive, Spark, Kafka Preferable hands-on in Data bricks and coming from strong data background with...

  • Data Modeller

    7 days ago

    Houston, TX, United States Infosys USAAvance Consulting Full time

    Data Modeller Houston TX FulltimeRequired Qualifications: At least 4 years of experience in Information Technology. Proficiency in Data Modeling using tools like ERWIN.  ETL development experience with strong SQL background such as Python/R, Scala, Java, Hive, Spark, Kafka Preferable hands-on in Data bricks and coming from strong data background with...

  • Data Modeller

    3 days ago

    Houston, TX, United States Infosys USAAvance Consulting Full time

    Data Modeller Houston TX FulltimeRequired Qualifications: At least 4 years of experience in Information Technology. Proficiency in Data Modeling using tools like ERWIN.  ETL development experience with strong SQL background such as Python/R, Scala, Java, Hive, Spark, Kafka Preferable hands-on in Data bricks and coming from strong data background with...

  • Logical Data Modeler

    3 days ago

    Houston, TX, United States Global Channel Management Full time

    About the job Logical Data Modeler Logical Data Modeler needs 3+ years of experience in data modeling, database design, or data architecture. Logical Data Modeler requires: Bachelor's degree or technical certification with a minimum of three (3) years' related experience. Experience with supporting Oracle databases. Experience with cloud platforms (e.g.,...

  • Logical Data Modeler

    21 hours ago

    Houston, TX, United States Global Channel Management Full time

    About the job Logical Data Modeler Logical Data Modeler needs 3+ years of experience in data modeling, database design, or data architecture. Logical Data Modeler requires: Bachelor's degree or technical certification with a minimum of three (3) years' related experience. Experience with supporting Oracle databases. Experience with cloud platforms (e.g.,...

  • Logical Data Modeler

    23 hours ago

    Houston, TX, United States Axelon Full time

    Title: Logical Data Modeler Location: Houston, TX Key Responsibilities: • Design and maintain logical data models that reflect business requirements and support enterprise data architecture. • Collaborate with business analysts and stakeholders to gather and interpret data requirements. • Translate business needs into normalized data structures...

  • Logical Data Modeler

    4 days ago

    Houston, TX, United States Axelon Full time

    Title: Logical Data Modeler Location: Houston, TX Key Responsibilities: • Design and maintain logical data models that reflect business requirements and support enterprise data architecture. • Collaborate with business analysts and stakeholders to gather and interpret data requirements. • Translate business needs into normalized data structures...

  • Logical Data Modeler

    3 days ago

    Houston, TX, United States Axelon Full time

    Title: Logical Data Modeler Location: Houston, TX Key Responsibilities: • Design and maintain logical data models that reflect business requirements and support enterprise data architecture. • Collaborate with business analysts and stakeholders to gather and interpret data requirements. • Translate business needs into normalized data structures...

  • Data Architect

    2 weeks ago

    Houston, TX, United States Insight Global Full time

    Insight Global is looking for a Data Architect/ Modeler to lead the enterprise data modeling initiatives and make high-level design decisions. You will be responsible for overseeing the creation and maintenance of conceptual, logical, and physical data models, as well as ensuring alignment with data quality, integrity, and governance standards. This is a...

  • Data Architect

    2 weeks ago

    Houston, TX, United States Insight Global Full time

    Insight Global is looking for a Data Architect/ Modeler to lead the enterprise data modeling initiatives and make high-level design decisions. You will be responsible for overseeing the creation and maintenance of conceptual, logical, and physical data models, as well as ensuring alignment with data quality, integrity, and governance standards. This is a...