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 with a focus on data modeling 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 ensuring data accuracy and governance. This is an onsite position with no relocation assistance or visa sponsorship offered.

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.

Benefits

• Comprehensive Health Benefits: Affordable Medical, Pharmacy, and Dental plans.
• Wellness Initiatives: Employee wellness programs for a healthy work-life balance.
• Financial Security: Life and Disability Insurance, plus a robust 401(k) Profit Trust Plan.
• Work-Life Balance: Paid Time Off (PTO) and company-paid holidays.
• Growth Opportunities: Career development and advancement within a thriving company.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed