Remote job
BI Data Modeler - Remote
Job details
About this role
Role overview Build and improve the data models and semantic layers that support enterprise reporting, forecasting, self-service analytics, and emerging AI use cases. You’ll translate business needs into dependable, scalable datasets and metrics, partnering with both business stakeholders and technical teams.
Responsibilities - Design and maintain conceptual, logical, physical, dimensional, and semantic models, including star or snowflake schemas and slowly changing dimensions. - Turn analytical requirements into reusable datasets, measures, KPIs, calculations, and reporting definitions. - Develop Power BI semantic models, reports, dashboards, and curated data using DAX, SQL, and Power Query/M. - Validate data quality, reconcile results, and tune models for query performance, scale, storage, and refresh needs. - Integrate warehouse, lake, API, and other data sources in collaboration with engineering and platform teams. - Support governance and operations through security controls, documentation, monitoring, troubleshooting, version control, and deployment practices.
Requirements - Bachelor’s degree in a relevant technical field, or equivalent education and professional experience. - Three to five years of experience in business intelligence, analytics, data modeling, data warehousing, or a related field. - Hands-on experience with dimensional and semantic modeling, Power BI, and SQL. - Familiarity with data quality practices, enterprise data platforms, and governance concepts such as row-level security and metric definitions. - Ability to communicate complex data concepts to both technical colleagues and business users.
Nice to have Experience with Databricks and its Medallion Architecture, Unity Catalog, or semantic and metrics platforms such as dbt, AtScale, or Kyligence. Planning, forecasting, scenario analysis, cloud BI, AI or machine learning data preparation, and automation experience are also useful.
Benefits and work setup The role is fully remote within the United States. Benefits include health, dental, and vision coverage, paid time off, life insurance, a 401(k) match, mental health support, and paid parental leave. The posting lists a monthly estimated pay range of $5,444.76–$9,537.00 and eligibility for a bonus or incentive plan.