BI Developer - Data Modeling & SQL

Description

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 BI Developer like you!

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.

• Help prepare semantic models for AI-enabled reporting, including Copilot and Q&A.

What You’ll Bring

• 2–4 years of hands-on experience with T-SQL and Power BI.

• Experience with DAX and dimensional modeling.

• Strong SQL skills and experience building reliable reporting datasets.

• Ability to troubleshoot data issues and validate reporting accuracy.

• Strong attention to detail and commitment to trusted, consistent reporting.

• Clear communication skills and the ability to partner with both technical and business teams.

Nice to Have

• Experience with manufacturing, ERP, or operational data.

• Experience with Microsoft Dynamics 365.

• Familiarity with Azure SQL, Microsoft Fabric, Tabular Editor, DAX Studio, or Azure DevOps.

• Experience supporting governed BI environments, certified datasets, or self-service reporting users.

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!

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

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights (https://www.eeoc.gov/poster) notice from the Department of Labor.