Power BI Developer - Data Modeling (Arlington, TX)

Martin Sprocket & Gear•Arlington, TX

7h•Onsite

About The Position

Martin Sprocket & Gear is seeking a skilled Power BI Developer to join their team in Arlington, TX. The role involves building and maintaining Azure SQL tables and views, developing and optimizing Power BI semantic models, and supporting business users with various reporting needs. The company is a global leader in mechanical power transmission components, material handling systems, and custom forgings, and is dedicated to producing quality products with excellence.

Requirements

2–4 years of hands-on Power BI development experience, including building production-ready semantic models with relationships, DAX measures, dimensional modeling, and scheduled refresh configuration.
Strong understanding of DAX and model behavior, including filter context, calculated measures, time intelligence, and troubleshooting measures that produce unexpected results.
Proficiency with T-SQL and experience developing reporting-ready tables, views, and business logic in SQL; experience moving logic from Power Query or DAX into governed SQL when appropriate.
Experience validating report and model outputs against source data, investigating discrepancies, identifying root causes, and implementing reliable fixes.
Working knowledge of Power BI Service, including workspace support, refresh monitoring, deployment support, and assisting self-service report builders.
Strong documentation habits, including maintaining clear definitions for measures, key columns, data sources, business rules, calculation logic, grain, and filters.

Nice To Haves

Experience with Microsoft Fabric, Tabular Editor, or DAX Studio.
Exposure to Microsoft Dynamics 365 Finance & Operations data structures.
Experience with Git or Azure DevOps for versioning SQL or Power BI artifacts.
Manufacturing or distribution data (bookings, billings, COGS, inventory, quotes).

Responsibilities

Build and maintain Azure SQL tables and views that support governed reporting.
Develop and optimize Power BI semantic models, including relationships, DAX measures, and refresh setup.
Move business logic into scalable SQL where appropriate.
Monitor scheduled refreshes and troubleshoot failures.
Validate reporting outputs against source data and resolve discrepancies.
Maintain clear documentation for key metrics, measures, data sources, and business definitions.
Support report certification, deployment reviews, and governance standards.
Assist business users with ad hoc analysis, self-service reporting, paginated reports, subscriptions, and Analyze in Excel.