Dimensional Modeling

Dimensional Modeling Engineer Jobs

4 jobs found

Today

Data Engineer – Power BI

Intone Networks Remote 🌍 Remote

Remote

Today

Full time Analytics Business Analytics Business Intelligence

Apply Now

Job Description

Intone Networks offers a remote Data Engineer role focused on Power BI development and data modeling. You will design and optimize dashboards and data models, tune performance, and implement row-level security, collaborating with business stakeholders to translate requirements into actionable analytics. This position is remote and requires 8 to 10 years of hands-on Power BI experience.

Responsibilities

Design, develop, and maintain advanced Power BI reports and dashboards.
Build and optimize complex data models using star and snowflake schemas.
Develop efficient DAX measures, calculated columns, and Power Query (M) transformations.
Collaborate with business stakeholders to gather requirements and deliver analytical solutions.
Optimize report performance and implement row-level security (RLS).

Requirements

8–10 years of experience in Power BI development and data modeling.
Strong expertise in Power BI Desktop, Power BI Service, DAX, Power Query (M), and Data Modeling.
Hands-on experience with SQL and relational databases.
Strong understanding of dimensional modeling (Star Schema/Snowflake Schema).
Experience in performance tuning, report optimization, and Row-Level Security (RLS).
Good analytical, problem-solving, and communication skills.

Technologies

Power BI Desktop
Power BI Service
DAX
Power Query (M)
SQL
Relational databases
Star Schema
Snowflake Schema

View full job page →

1mo ago

Data Scientist / Data Analytics Engineer

Transflo Remote 🌍 Remote

Remote

1mo ago Closed

Full time Analytics Automation AWS

This position is no longer accepting applications (closed Jul 12, 2026).

Job Description

Transflo is seeking a Data Scientist / Data Analytics Engineer to design, build, and operationalize analytics solutions across transportation and logistics, delivering both predictive and point-in-time insights on AWS.

Responsibilities

Design, train, validate, and deploy predictive models across regression, classification, time-series forecasting, survival analysis, clustering, anomaly detection, and gradient-boosted or deep learning approaches as appropriate.
Lead model selection, hyperparameter tuning, cross-validation, and performance evaluation using business-aligned metrics such as precision/recall trade-offs, MAPE, RMSE, lift, and calibration.
Develop data products in transportation domains including operational metrics, fraud signals, pricing analytics, and industry trends.
Establish model monitoring, drift detection, retraining cadence, and explainability practices (SHAP, feature importance, partial dependence) to maintain production reliability.
Produce point-in-time analytics, KPI scorecards, and exception reporting to inform daily decisions across dispatch, fleet, customer success, finance, and product teams.
Partner with business stakeholders to translate questions into well-scoped analyses and deliver defensible insights with documented assumptions and data lineage.
Build and maintain reusable analytical datasets, semantic layers, and certified metrics to ensure a single source of truth.
Design and maintain data pipelines (batch and streaming) on AWS using Redshift, S3, Glue, Lambda, Step Functions, Kinesis / MSK, EMR, Athena, and SageMaker.
Apply medallion architecture (bronze, silver, gold) to progressively refine raw operational data into analytics-ready and ML-ready datasets.
Utilize STARR modeling to create performant, business-friendly data models in Redshift and the warehouse layer.
Drive data selection, curation, profiling, and quality enforcement with source-of-truth datasets, lineage documentation, and data contracts.
Collaborate with data engineering and platform teams on CI/CD for data and ML assets, infrastructure as code, and cost-aware AWS design.
Take customer-facing analytics features from concept to implementation in partnership with product, design, and engineering.
Contribute to product discovery through interviews, opportunity sizing, prototyping, and rapid iteration on analytics concepts.
Own the analytical correctness of customer-facing metrics, models, and visualizations, including edge cases and explanations for non-technical users.
Define success metrics for shipped analytics features and drive iterative improvements post-launch.
Translate complex analyses into clear narratives and visuals for technical and non-technical audiences, including executives and customers.
Partner across product, engineering, operations, and commercial teams to embed analytics into workflows and customer-facing products.
Mentor analysts and engineers on statistical rigor, modeling practices, and modern data architecture.

Requirements

Bachelor's degree in Statistics, Mathematics, or Supply Chain Management; Computer Science is acceptable. Master’s degree preferred but not required.
Professional experience in transportation, trucking, freight, logistics, or broader supply chain with working knowledge of loads, stops, shipments, ELD/telematics, TMS, dispatch, and billing data.
Proven track record taking customer-facing analytics products from idea through launch, including discovery, scoping, metric and model design, and production support with real customers. Prepared to discuss at least one end-to-end example.
Strong ability to build advanced analytical models end-to-end: problem framing, data selection, feature engineering, model training/validation, and deployment.
Hands-on experience with AWS PaaS and analytics tooling, including Redshift and services such as S3, Glue, Lambda, Step Functions, Athena, Kinesis, EMR, and SageMaker.
Proficiency in SQL (advanced window functions, performance tuning on Redshift or similar warehouses) and at least one analytics-language (Python preferred) with libraries like pandas, scikit-learn, statsmodels, XGBoost/LightGBM, and PyTorch or TensorFlow as appropriate.
Experience designing and operating production data pipelines with clear orchestration, idempotency, observability, and data quality practices.
Solid grounding in statistics including hypothesis testing, experimental design, regression, time-series, and uncertainty quantification.

Technologies

AWS, Redshift, S3, Glue, Lambda, Step Functions, Kinesis, MSK, EMR, Athena, SageMaker
Python, pandas, scikit-learn, statsmodels, XGBoost, LightGBM, PyTorch, TensorFlow
Jupyter, SQL, QuickSight, Power BI, Looker
Airflow, Git, CI/CD, Terraform, CloudFormation
Medallion architecture, STARR (Star schema / dimensional) modeling

Preferred Qualifications

Master’s degree in Statistics, Mathematics, Operations Research, Supply Chain, Computer Science, or a related field.
Experience implementing medallion architecture in cloud data lakehouse or warehouse environments.
Experience designing STARR / star-schema dimensional models for analytics consumption.
Experience with streaming and event-driven data (Kinesis, Kafka/MSK) for near real-time analytics on transportation events.
Experience deploying and monitoring ML models in production using SageMaker, MLflow, or equivalent MLOps tooling.
Familiarity with BI tools and semantic layer concepts (QuickSight, Power BI, Looker).
Exposure to optimization and operations research techniques applied to transportation problems.
Experience with ELD/HOS data, telematics feeds, geospatial data, TMS/dispatch data, brokerage data, and understanding of transportation backoffice operations.

Core Competencies

Analytical rigor and the ability to defend methodology and assumptions
Business pragmatism and value-driven problem solving
Product mindset with focus on end-user experience
Engineering discipline and reproducible, testable code
Stakeholder partnership and clear communication of trade-offs
Curiosity, ownership, and root-cause problem-solving

Representative Tech Environment

Cloud & Data Platform: AWS (Redshift, S3, Glue, Lambda, Step Functions, Athena, Kinesis, EMR, SageMaker)
Modeling & Analysis: Python (pandas, scikit-learn, statsmodels, XGBoost/LightGBM, PyTorch/TensorFlow), SQL, Jupyter
Data Architecture: Medallion (bronze/silver/gold), STARR dimensional models, data contracts, lineage tooling
Orchestration & DevOps: Airflow / Step Functions, Git, CI/CD, Terraform or CloudFormation
Visualization: QuickSight, Power BI, or Looker

View full job page →

1mo ago

Analytics Engineer II

Texas Roadhouse Louisville, KY

Louisville, KY

1mo ago Closed

Full time Analytics Business Analytics Business Intelligence

This position is no longer accepting applications (closed Jun 22, 2026).

Job Description

Analytics Engineer II at Texas Roadhouse responsible for designing, building, and optimizing enterprise analytics using Microsoft Fabric and Power BI, enabling self-service insights from the Louisville Support Center with a hybrid work arrangement.

Responsibilities

Design, build, and maintain domain-specific semantic models in Power BI and Fabric.
Craft business metrics in DAX, including advanced measures and calculation groups.
Apply dimensional modeling best practices to boost performance, usability, and consistency.
Own data governance tasks such as row-level security, dataset certification, and access controls.
Create and sustain high-impact Power BI reports and applications.
Troubleshoot model and report issues related to performance, data refresh, and logic.
Collaborate with Data Engineering to shape analytics-ready data models.
Monitor analytics asset performance, reliability, and usage.
Participate in CI/CD workflows using Git and Power BI deployment pipelines.
Enable self-service analytics through certified datasets and reusable assets.
Work with stakeholders to gather requirements and validate outcomes.

Requirements

High School diploma or GED required; Bachelor's degree in Computer Science or a related field preferred, with relevant experience substituting for the degree.
4–6 years of experience in Analytics Engineering, BI, or advanced Power BI roles.
Required certifications: DP-600 (Fabric Analytics Engineer) and PL-300 (Power BI Data Analyst).
Proven ownership of production semantic models and governed metrics.
Strong expertise in DAX, dimensional modeling, and performance optimization.
Experience delivering production-grade analytics solutions used by the business.
Solid SQL and data modeling skills.
Hands-on experience with the Microsoft Fabric / Power BI ecosystem aligned to DP-600.
Experience with Git and CI/CD practices.
Experience with Fabric components (Lakehouse, Warehouse, Direct Lake) preferred.
Familiarity with product-oriented analytics teams is a plus.
Experience with tools such as Tabular Editor is preferred.

Technologies

Microsoft Fabric
Power BI
DAX
SQL
Git
PBIP (Power BI deployment pipelines)
Tabular Editor
Fabric Lakehouse
Fabric Warehouse
Fabric Direct Lake

Benefits

Health insurance coverage
Maternity leave
Vacation time
Parental leave
Donor leave
Bereavement leave
Wellness program
Car detailing services
Dry cleaning benefits
Spray tan services
401(k) retirement plan
Tuition reimbursement
Stock units
Holiday bonuses
Willie’s Joynt on-site cafe perks

What’s on Your Plate

Design, build, and maintain domain-aligned semantic models in Power BI and Fabric
Develop business metrics in DAX, including complex measures and calculation groups
Apply dimensional modeling best practices for performance, usability, and consistency
Own data governance: RLS, dataset certification, and access controls
Build and support high-impact Power BI reports and apps
Troubleshoot issues across models and reports (performance, refresh, logic)
Partner with Data Engineering to shape analytics-ready data models
Monitor performance, reliability, and usage of analytics assets
Contribute to CI/CD processes (Git, PBIP, deployment pipelines)
Enable self-service analytics through certified datasets and reusable assets
Collaborate with stakeholders to gather requirements and validate outcomes

Your Recipe for Success

High School diploma or GED required, bachelor's in Computer Science or related field preferred; experience can substitute for the degree
4–6 years in Analytics Engineering, BI, or advanced Power BI roles
DP-600 and PL-300 certifications required
Proven ownership of production semantic models and governed metrics
Strong DAX, dimensional modeling, and performance optimization skills
Experience delivering production-grade analytics solutions used by the business
Solid SQL and data modeling skills
Hands-on experience with Microsoft Fabric / Power BI ecosystem
Experience with Git and CI/CD practices
Fabric experience (Lakehouse, Warehouse, Direct Lake) preferred
Familiarity with product-oriented analytics teams preferred
Experience with Tabular Editor preferred

Why You’ll Love Your Job

Competitive benefits including medical, dental, vision, and fully paid maternity leave
Generous time off: vacation, parental, donor, and bereavement leave
Wellness perks: on-site fitness resources, massages, gym facilities, and a nurse on site
Convenience services such as car detailing and dry cleaning, plus spray tan options
Retirement and education support: 401(k), tuition reimbursement, stock units, and holiday bonuses
On-site cafe perks at Willie’s Joynt

View full job page →

2mo ago

Business Intelligence & SQL Data Engineer

American Pain Consortium Carmel, IN

Carmel, IN

2mo ago Closed

Full time Analytics Business Analytics Business Intelligence

This position is no longer accepting applications (closed Jun 19, 2026).

Job Description

The Business Intelligence and SQL Data Engineer role at American Pain Consortium is an onsite position based in Carmel, Indiana. It combines strategic leadership with hands-on expertise to support Power BI reporting, SQL Server infrastructure, and the enterprise data warehouse, delivering reliable executive reporting across clinical, operational, and financial domains.

Job Summary

In this role, you will provide both strategic direction and practical technical execution for the organization’s Power BI environment, SQL Server backbone, and enterprise data warehouse. You will design scalable data architectures, ensure SQL Server performance and reliability, and serve as the subject matter expert on data modeling, semantic layers, and SQL optimization. You will collaborate closely with Finance, Operations, IT, and executive leadership to enable consistent and accurate reporting across clinical, operational, and financial areas.

Responsibilities

Create and maintain enterprise Power BI dashboards and reports.
Plan, implement, and optimize SQL Server databases.
Develop complex T-SQL queries, views, stored procedures, and ETL processes.
Build and sustain dimensional models, including star schemas and Bronze/Silver/Gold data layers.
Monitor and tune indexing strategies, execution plans, and overall query performance.
Support data integration and alignment across multiple EMR, scheduling, and billing systems.
Ensure backup integrity, disaster recovery readiness, and continuous data availability.
Assist with data migrations and data acquisitions during integrations.
Establish naming conventions, documentation standards, and change governance.
Maintain data integrity through validation and reconciliation processes.
Monitor data quality and promptly address discrepancies.
Partner with leadership to translate business requirements into scalable data solutions.
Maintain SQL Server virtual machines in coordination with IT infrastructure.
Support capacity planning, storage growth forecasting, and patch coordination.
Collaborate with the CIO and executive leadership on analytics strategy.
Develop standardized dashboards to support operational and financial reporting needs.
Build and manage semantic models and DAX measures.
Optimize report performance and ensure reliable data refreshes.
Maintain Power BI gateways, authentication, and scheduled refresh processes.
Partner with Finance and Operations to deliver AR, revenue cycle, KPI, and acquisition reporting.
Support self-service reporting initiatives and enforce data governance standards.

Requirements

Excellent verbal and written communication skills.
Strong analytical and problem solving abilities.
High attention to detail and accuracy.
Ability to manage multiple priorities in a fast paced environment.
Strong documentation and organizational skills.
Ability to communicate technical concepts to non-technical stakeholders.
Ability to translate business requirements into technical solutions.
Bachelor’s Degree in Information Systems, Computer Science, Data Analytics, or related field preferred.
3–7+ years experience with Microsoft SQL Server.
Strong T-SQL experience including joins, CTEs, stored procedures, and performance tuning.
3+ years experience with Microsoft Power BI (DAX, semantic models, dataflows).
Experience designing star schemas or dimensional models.
Experience supporting production SQL environments.
Healthcare or financial reporting experience preferred.

Technologies

Power BI
Microsoft SQL Server
T-SQL
DAX
Power BI Dataflows
Power BI Gateways

Benefits

Medical, Dental, and Vision Insurance
Paid Time Off
Paid Holidays
401(k) Plan with Company Match
Tution Reimbursement
Referral Program

Who We Are

American Pain Consortium’s mission is to empower providers to deliver exceptional patient care.
As an employer, we aim to empower every team member to realize their maximum professional potential and foster a collaborative environment that supports shared success. We value our people as our most important asset, and we began in 1993 with a devoted physician who assembled a leadership team to drive progress.

View full job page →

Dimensional Modeling Engineer Jobs

Data Engineer – Power BI

Data Scientist / Data Analytics Engineer

Analytics Engineer II

Business Intelligence & SQL Data Engineer

Get Dimensional Modeling Engineer Jobs alerts