Power BI Developer - Data Modeling (Arlington, TX)

Are you ready to bring your IT skills to a team that values precision and innovation? At Martin Sprocket & Gear, we’re dedicated to producing quality mechanical power transmission components, material handling systems, and custom forgings with excellence, and we're looking for a skilled Power BI Developer like you!

Work Arrangement: Onsite in Arlington, TX

Relocation Assistance: Not available

Work Authorization Applicants must be legally authorized to work in the United States at the time of hire. For this position, the company is unable to provide visa sponsorship now or in the future.

What You’ll Do

• 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.

What You’ll Bring

• 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 Have

• 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).

Interview Process

Candidates will complete a short hands-on modeling and SQL exercise as part of the interview process.

Your Schedule:

• Monday – Friday, 8:00 AM – 5:00 PM.

To perform this job successfully, you must be able to report daily to the branch to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable qualified candidates with disabilities to perform the essential functions.

Why Martin Sprocket & Gear, Inc.?

Founded in 1951 by Joe Martin Sr., Martin Sprocket & Gear is a global leader in mechanical power transmission components, material handling systems, and custom forgings. We are proud to remain family-owned and operate on a simple philosophy:

"Make a quality product, have plenty of it available, and be easy to do business with!"

With dedicated employees, regional facilities, and strong distributor partnerships, Martin offers stability, growth potential, and a dynamic work environment for all team members.

Why You Will Love Working Here:

At Martin, our people are our greatest asset. We foster an inclusive, collaborative environment where innovation and growth thrive, and your contributions are valued as part of a team dedicated to excellence. Here is what you’ll enjoy when you join our team:

• 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.

• Competitive Pay & Perks

Ready to Join Us?

Apply today and become part of Martin Sprocket & Gear’s legacy of quality and excellence!

Disclaimers The above statements describe the general nature and level of work being performed by candidates applying for this specific role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of candidates hired.

Martin Sprocket & Gear is an EEO Employer and an E-Verify participating employer. We do not discriminate based on race, religion, national origin, sex, sexual orientation, gender identity, age, physical or mental disability, marital status, or veteran status.