Dimensional Modeling

Dimensional Modeling Data Jobs

3 jobs found

1mo ago

Data Scientist / Data Analytics Engineer

Transflo Remote 🌍 Remote

Remote

1mo ago

Full time Analytics Automation AWS

Apply Now

Job Description

The Data Scientist / Data Analytics Engineer role at Transflo is a remote-based position focused on designing, building, and operationalizing advanced analytics across transportation and logistics, delivering both predictive and point-in-time insights on AWS.

Responsibilities

Design, train, validate, and deploy predictive models spanning regression, classification, time-series forecasting, survival analysis, clustering, anomaly detection, and gradient-boosted or deep learning approaches as appropriate to the problem.
Lead model selection, hyperparameter tuning, cross-validation, and rigorous 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 keep production models trustworthy.
Produce point-in-time analytics, KPI scorecards, and exception reporting to support daily decisions across dispatch, fleet, customer success, finance, and product teams.
Partner with business stakeholders to translate questions into well-scoped analyses and deliver clear, defensible insights with documented assumptions and data lineage.
Build and maintain reusable analytical datasets, semantic layers, and certified metrics to ensure a consistent source of truth.
Build and maintain data pipelines (batch and streaming) on AWS using Redshift, S3, Glue, Lambda, Step Functions, Kinesis, MSK, EMR, Athena, and SageMaker.
Implement medallion architecture to progressively refine raw operational data into analytics-ready and ML-ready datasets.
Apply STARR dimensional modeling to construct performant data models in Redshift and the warehouse layer.
Drive data selection, curation, profiling, and quality enforcement; define source-of-truth datasets, document lineage, and codify data contracts and validation tests.
Collaborate with data engineering and platform teams on CI/CD for data and ML assets, infrastructure as code, and cost-aware AWS design.
Turn customer-facing analytics ideas into shipped capabilities through partnerships with product management, design, and engineering.
Contribute to product discovery through customer interviews, opportunity sizing, prototyping, and rapid iteration of analytical concepts.
Own the analytical correctness of customer-facing metrics, models, and visualizations, including definitions, edge cases, and explanations for non-technical users.
Define and measure success metrics for 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 cross-functionally with product, engineering, operations, and commercial teams to embed analytics into workflows and customer-facing products.
Mentor analysts and engineers on statistical rigor, modeling best 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 related supply chain fields, with working knowledge of operational data (loads, stops, shipments, ELD/telematics, TMS, dispatch, billing, etc.).
Proven track record launching customer-facing analytics products from idea through production, including discovery, scoping, model and metric design, collaboration with product/engineering, and production support with real customers. An end-to-end example is expected.
Strong experience building end-to-end analytics models, including problem framing, data curation, feature engineering, model training and validation, and deployment.
Hands-on experience with AWS PaaS and analytics tooling, including Redshift and related services (S3, Glue, Lambda, Step Functions, Athena, Kinesis, EMR, SageMaker).
Proficiency in SQL (advanced window functions, performance tuning on Redshift or similar) and at least one analytics programming language such as Python, with libraries like pandas, scikit-learn, statsmodels, XGBoost/LightGBM, and PyTorch or TensorFlow as appropriate.
Experience designing and operating production data pipelines with attention to orchestration, idempotency, observability, and data quality.
Solid grounding in statistical methods including hypothesis testing, experimental design, regression, time-series analysis, 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
BI / Visualization tools: QuickSight, Power BI, Looker
Orchestration / DevOps: Airflow, Git, CI/CD, Terraform, CloudFormation
Medallion architecture, STARR modeling

Preferred Qualifications

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

Core Competencies

Analytical rigor and the ability to defend methodology, assumptions, and uncertainty.
Business pragmatism and the capacity to ship value quickly with practical models.
Product mindset for customer-facing analytics and willingness to iterate with product and engineering partners.
Engineering discipline, reproducibility, and data lineage awareness.
Stakeholder partnership and clear communication of trade-offs.
Curiosity and ownership in identifying data quality issues and driving root-cause resolution.

Representative Tech Environment

Cloud and Data Platform: AWS stack including Redshift, S3, Glue, Lambda, Step Functions, Athena, Kinesis, EMR, SageMaker
Modeling and Analysis: Python with pandas, scikit-learn, statsmodels, XGBoost/LightGBM, PyTorch/TensorFlow; SQL; Jupyter
Data Architecture: Medallion approach; STARR models; data contracts and lineage tooling
Orchestration and DevOps: Airflow, Step Functions, Git, CI/CD, Terraform or CloudFormation
Visualization: QuickSight, Power BI, 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

What you’ll enjoy Texas Roadhouse offers a hybrid role based at the Louisville Support Center in Louisville, KY, designed for analytics professionals who value impact, collaboration, and growth. You’ll work with Microsoft Fabric and Power BI to design and deliver enterprise analytics, creating semantic models and governed metrics that empower self-service insights across the business. - Comprehensive health coverage (medical, dental, vision) - 100% paid maternity leave - Generous vacation, parental, donor, and bereavement leave - Wellness program with on-site resources - On-site conveniences such as car detailing and dry cleaning - Optional spray tan benefits - 401(k) plan, tuition reimbursement, stock units, and holiday bonuses - Willie’s Joynt on-site cafe perks What you’ll do You will design, build, and maintain domain-aligned semantic models in Power BI and Fabric to support scalable analytics. - Design, build, and maintain domain-aligned semantic models in Power BI / Fabric - Develop business metrics using DAX, including complex measures and calculation groups - Apply dimensional modeling best practices for performance, usability, and consistency - Own data governance responsibilities such as Row-Level Security, dataset certification, and access controls - Build and support high-impact Power BI reports and apps - Troubleshoot issues across models and reports, including performance, refresh, and logic - Partner with Data Engineering to shape analytics-ready data models - Monitor performance, reliability, and usage of analytics assets - Contribute to CI/CD processes using Git, PBIP, and deployment pipelines - Enable self-service analytics through certified datasets and reusable assets - Collaborate with stakeholders to gather requirements and validate outcomes What you’ll bring - HS or GED required; a Bachelor’s in Computer Science or a related field is preferred, though relevant experience can substitute for the degree - 4–6 years in Analytics Engineering, BI, or advanced Power BI roles - DP-600 (Fabric Analytics Engineer) and PL-300 (Power BI Data Analyst) certifications - Demonstrated 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 - Experience with Git and CI/CD practices - Familiarity with Fabric components such as Lakehouse, Warehouse, and Direct Lake (preferred) - Experience with product-oriented analytics teams (preferred) - Experience with Tabular Editor (preferred) Technologies you’ll work with - Microsoft Fabric, Power BI - DAX, SQL - Git, PBIP (Power BI deployment pipelines) - Tabular Editor - Fabric Lakehouse, Fabric Warehouse, Fabric Direct Lake Location and setup - Louisville, KY, hybrid work arrangement at the Louisville Support Center Why this role matters This role focuses on building scalable analytics foundations that empower business users to derive insights quickly and confidently, while maintaining governance and reliability across the data estate. You’ll collaborate across data engineering and business teams to deliver measurable, production-grade analytics assets that drive informed decision-making.

View full job page →

1mo ago

Business Intelligence & SQL Data Engineer

American Pain Consortium Carmel, IN

Carmel, IN

1mo 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 & SQL Data Engineer role at American Pain Consortium is based onsite in Carmel, IN, delivering Power BI, SQL Server, and enterprise data warehouse leadership.

Responsibilities

Create, enhance, and sustain organization-wide Power BI dashboards and reports.
Architect and tune SQL Server databases for performance and reliability.
Build advanced T-SQL queries, views, stored procedures, and ETL pipelines.
Develop and maintain dimensional models using star schemas and manage Bronze, Silver, and Gold data layers.
Monitor and optimize indexing strategies, execution plans, and overall query performance.
Assist data integration across EMR, scheduling, and billing systems to align datasets.
Ensure backup integrity, disaster recovery readiness, and data availability.
Support data integrations and migrations during acquisitions.
Establish naming conventions, documentation standards, and change governance.
Ensure data integrity through validation and reconciliation processes.
Monitor data quality and address discrepancies.
Collaborate with leadership to translate business requirements into scalable data solutions.
Maintain SQL Server virtual machines in coordination with IT infrastructure.
Assist with performance planning, storage growth forecasting, and patch coordination.
Work 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.
Improve report performance and refresh reliability.
Maintain Power BI gateways, authentication, and scheduled refresh processes.
Collaborate with Finance and Operations to deliver AR, revenue cycle, KPI, and acquisition reporting.
Support self-service reporting initiatives and uphold data governance standards.

Requirements

Strong verbal and written communication abilities.
Solid analytical and problem-solving skills.
Meticulous attention to detail and accuracy.
Ability to juggle multiple priorities in a fast-paced setting.
Strong documentation and organizational capabilities.
Capability to translate technical concepts for 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.
Three to seven-plus years of experience with Microsoft SQL Server.
Proficiency in T-SQL (joins, CTEs, stored procedures, performance tuning).
Three or more years of Power BI experience (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) matching
Referral program
Tuition reimbursement
Health insurance
Dental insurance
Vision insurance
Other benefits

Who we are

American Pain Consortium’s mission is to empower providers to deliver exceptional patient care.
As an employer, our mission is to empower every team member to reach their maximum potential and contribute to our shared success, built on hiring the brightest minds in the business.

View full job page →

Dimensional Modeling Data Jobs

Data Scientist / Data Analytics Engineer

Analytics Engineer II

Business Intelligence & SQL Data Engineer

Get Job Alerts