Data Modeler

2 days ago

Houston, Texas, United States GDH Full time $50,000 - $66,000 per year

We are seeking an experienced Data Modeler for a technically challenging contract opportunity. This role is ideal for professionals with a strong background in data modeling, analytics engineering, and hands-on experience with Microsoft Fabric and Power BI. As a Data Modeler, you will play a pivotal role in designing and implementing robust data models that support key business domains and drive insights. The position offers a flexible, hybrid work arrangement, allowing you to split your time between remote and on-site work, and is available for immediate start.

Responsibilities

  • Design and develop dimensional models in the Gold layer for domains such as Commercial/Operations, Membership/Education, Product/Clinical, and Compliance/Quality.
  • Define model grain, surrogate keys, conformed dimensions, and implement role-playing dimensions to ensure scalable and maintainable data architecture.
  • Implement Slowly Changing Dimensions (SCD) Type 1 and 2 in Delta (Warehouse/Lakehouse) for key dimensions including Customer, Product, Practitioner, and Membership.
  • Handle late-arriving facts and dimensions, inferred members, and construct bridge tables for many-to-many relationships (such as formulations with multiple actives or allergens).
  • Build and maintain Power BI semantic models, ensuring clean star schemas, effective relationship management, hierarchies, and display folders.
  • Author advanced DAX measures to support business KPIs, including revenue, margin, order volume, inventory metrics, membership retention, and compliance indicators.
  • Configure incremental refresh, aggregations, and Row-Level Security (RLS) in Power BI to optimize performance and ensure data governance.
  • Collaborate with data engineering and business intelligence teams to specify Silver data contracts, review pipeline outputs, and ensure data model readiness.
  • Maintain comprehensive documentation, including data dictionaries, lineage, SCD behavior, and certified metric definitions, applying appropriate sensitivity labels and endorsements.

Qualifications

  • 3–5 years of experience in data modeling or analytics engineering, with a proven track record of strong SQL proficiency.
  • Hands-on expertise with Microsoft Fabric, including Lakehouse/Warehouse, OneLake, Delta tables, Dataflows Gen2 or Pipelines, and SQL endpoints.
  • Advanced knowledge of dimensional modeling, including star schemas, fact types (transactional, periodic snapshot, accumulating), bridge tables, degenerate and junk dimensions.
  • Demonstrated experience with SCD Type 1 and 2 implementations using MERGE, effective/expiry dating, and handling late-arriving data.
  • Proficiency in Power BI semantic modeling and DAX, including clean tabular model design, CALCULATE/KEEPFILTERS/USERELATIONSHIP functions, and date intelligence.
  • Experience configuring incremental refresh, basic aggregations, and Row-Level Security in Power BI.
  • Strong understanding of data quality and governance best practices, including defining tests, documenting metrics, and managing endorsements and sensitivity labels.
  • Excellent communication skills with the ability to translate stakeholder requirements into effective data models and certified measures.
  • Healthcare, life sciences, or pharmacy domain experience is a plus, especially with product master data, compliance artifacts, and membership or continuing education tracking.

Pay Range:
$50.00 – $66.00 per hour

This position offers a hybrid schedule, with time split between the office and remote work.

  • Logical Data Modeler

    2 weeks ago

    Houston, Texas, United States Steadfast International Services, LLC Full time $114,000 - $144,000 per year

    Logical Data ModelerLocation: Houston, TXSkills:data modeling, database design, or data architecture., cloud platforms (e.g., Azure, Google, and AWS) and cloud-native databases., installation, configuration, and maintenance of Oracle DBMS., ETL processes., data modeling tools (e.g. ERwin, ER/Studio, etc).If you post this job on a job board, please do not use...

  • Snowflake AI/ML Data Modeler

    4 days ago

    Houston, Texas, United States MSR Technology Group Full time $104,000 - $160,000 per year

    Hi all, Looking forSnowflake AI/ML Data Modeler consultant.The ideal candidate will have experience working with medium to complex data structures in a corporate environment. They should be proficient in working hands-on with data in Snowflake, transforming data with DBT, and visualizing it efficiently in Power BI, including implementing logic in DAX....

  • Senior Data

    3 days ago

    Houston, Texas, United States Calpine Full time $120,000 - $200,000 per year

    Calpine Corporation is America's largest generator of electricity from natural gas and geothermal resources with operations in competitive power markets. Its fleet of 77 power plants in operation represents over 27,000 megawatts of generation capacity. Through wholesale power operations and its retail businesses, Calpine serves customers in 22 states and...

  • Data Scientist

    4 days ago

    Houston, Texas, United States Love's Travel Stops Full time $120,000 - $200,000 per year

    BASIC PURPOSE: As a Data Scientist (AI) supporting Musket Corp's energy trade floor (specializing in refined products), you will develop and deploy advanced AI and machine learning solutions that directly enhance trading performance, market analysis, and operational efficiency. This role blends cutting-edge AI innovation with real-world trading...

  • Data Engineer

    3 days ago

    Houston, Texas, United States X4 Technology Full time $100,000 - $150,000 per year

    About the Company:This is a fantastic opportunity to join an internationally renowned powerhouse within the supply chain industry. You will have the opportunity to work on a variety of different projects across teams. In this position, you'll be the architect of our data pipelines, instrumental in operationalizing data & advanced analytics to drive...

  • Data Analytics Engineer

    4 days ago

    Houston, Texas, United States Compunnel Inc. Full time $120,000 - $180,000 per year

    Goal/PurposeMove all data across the various project stewardship applications into a single cloud database (SQL to Snowflake). aka create a hub for project data across IT.TeamAgile teamData Engineers, Visualization Developers, Data Modelers - will be converting everyone into Analytics EngineersMUST HAVE:Snowflake/DBT - everything is done with DBT, this is...

  • Data Scientist

    3 days ago

    Houston, Texas, United States Brooksource Full time $120,000 - $180,000 per year

    Data ScientistFortune 500 Oil & Gas ClientHouston, TXOverviewWe're seeking Data Scientists to support the modernization and AI transformation of a leading drilling engineering software portfolio. These roles sit at the intersection of data science, software engineering, and petroleum domain expertise—helping to bring legacy applications into the cloud...

  • Data Architect

    4 days ago

    Houston, Texas, United States CAMP Facility Services Full time $120,000 - $180,000 per year

    Founded in 1978, CAMP Facility Services offers a vibrant work environment and a strong commitment to quality, accessible support, and holistic project management. We prioritize relationships with clients and staff alike, treating everyone like family.Specializing in commercial construction and building maintenance, we serve construction managers, property...

  • Data Scientist

    4 days ago

    Houston, Texas, United States Primary Services Full time $80,000 - $120,000 per year

    Join a forward-thinking organization that combines innovation, flexibility, and purpose. Enjoy a fully remote role with a people-centered culture and outstanding opportunities for growth. This is your chance to shape the future of data-driven energy while working alongside passionate professionals from across the country.Primary Services is looking for a...

  • Data Engineer

    4 days ago

    Houston, Texas, United States Templeton & Partners - Innovative & Inclusive Hiring Solutions Full time $120,000 - $180,000 per year

    About the RoleWe are seeking aSenior Data Engineerto design and build robust, scalable data foundations and end-to-end solutions that unlock business value through data-driven insights. In this strategic role, you'll help shape and embed a data-driven culture across both IT and business functions, supporting global energy and trading operations.As a...