Power BI Developer

Calfus Inc.; Los Angeles (CA); On-site; USD 120,000 - 145,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Paid time off

Job summary

Calfus Inc. in the United States is seeking a senior Power BI Developer who can build data models on ERP data and create trusted reporting for operations, supply chain, and finance.

You will design star-schema models on ERP data, write DAX, optimize measures, and develop SQL views and Power Query transformations. Onsite in Burbank, US citizen or GC required.

This role emphasizes data modeling over visuals and requires 5+ years BI, 3+ Power BI, and experience with manufacturing ERP data.

Qualifications

• 5+ years in BI or analytics, with 3+ years hands-on Power BI.
• Hands-on experience reporting against a manufacturing ERP (any major ERP).
• Expert DAX — you understand filter context and can debug someone else's measures.
• Advanced SQL against large transactional tables.
• Power Query / M and Power BI Service administration.
• Familiarity with manufacturing concepts: production orders, BOMs, routings, inventory, WIP, cost.
• Able to work onsite in Burbank five days a week.
• U.S. Citizen or Green Card holder (ITAR requirement).

Responsibilities

• Build and maintain Power BI datasets, reports, and dashboards for operations, supply chain, and finance.
• Design star-schema data models on top of ERP data.
• Write and optimize complex DAX measures.
• Tune models and reports for speed as data volumes grow.
• Write SQL views and Power Query transformations to feed the reporting layer.
• Set up row-level security, refresh schedules, and workspace governance.
• Work directly with plant, ops, and finance teams to define metrics and validate numbers.

Skills

BI analytics

Power BI

DAX

SQL

Power Query

Data modeling

ERP familiarity

Tools

Tabular Editor

DAX Studio

VertiPaq Analyzer

Job description

At Calfus, we are known for delivering cutting-edge AI agents and products that transform businesses in previously unimaginable ways. We empower companies to harness the full potential of AI, unlocking opportunities they never imagined possible before the AI era. Our software engineering teams are highly valued by customers, whether start-ups or established enterprises, because we consistently deliver solutions that drive revenue growth. Our ERP solution teams have successfully implemented cloud solutions and developed tools that seamlessly integrate with ERP systems, reducing manual work so teams can focus on high-impact tasks.

None of this would be possible without talent like you! Our global teams thrive on collaboration, and we’re actively looking for skilled professionals to strengthen our in-house expertise and help us deliver exceptional AI, software engineering, and solutions using enterprise applications.

As one of the fastest-growing companies in our industry, we take pride in fostering a culture of innovation where new ideas are always welcomed without hesitation. We are driven and expect the same dedication from our team members. Our speed, agility, and dedication set us apart, and we perform best when surrounded by high-energy, driven individuals.

About the Role

We need a senior Power BI Developer who has built reporting on top of a manufacturing ERP. Any ERP works - SAP, Oracle, Dynamics, Epicor, Infor, NetSuite, or similar. What matters is that you know how manufacturing data behaves and can turn it into model’s people trust. This role is about the data model, not just the visuals. You will build the datasets and write the DAX behind them.

Eligibility: U.S. Citizens and Green Card holders only (due to ITAR requirements)

What You'll Do

• Build and maintain Power BI datasets, reports, and dashboards for operations, supply chain, and finance.
• Design star-schema data models on top of ERP data.
• Write and optimize complex DAX measures.
• Tune models and reports for speed as data volumes grow.
• Write SQL views and Power Query transformations to feed the reporting layer.
• Set up row-level security, refresh schedules, and workspace governance.
• Work directly with plant, ops, and finance teams to define metrics and validate numbers.

What We're Looking For

• 5+ years in BI or analytics, with 3+ years hands-on Power BI.
• Hands-on experience reporting against a manufacturing ERP (any major ERP).
• Expert DAX — you understand filter context and can debug someone else's measures.
• Advanced SQL against large transactional tables.
• Power Query / M and Power BI Service administration.
• Familiarity with manufacturing concepts: production orders, BOMs, routings, inventory, WIP, cost.
• Able to work onsite in Burbank five days a week.
• U.S. Citizen or Green Card holder (ITAR requirement).

Nice to Have

• Tabular Editor, DAX Studio, VertiPaq Analyzer.
• Experience migrating SSRS, Crystal, or Excel reporting into Power BI.
• Aerospace, defense, or discrete manufacturing background.

Compensation:

Salary range: Between $120,000.00 to $145,000.00 per year. Pay is based on several factors including geographical locations but not limited to education, work experience, certifications, etc.

Offered Benefits:

Calfus prioritizes the well-being and financial security of its employees & families by providing comprehensive health coverage, which includes medical (by Kaiser & Aetna), Dental & Vision (by Guardian) plans. This ensures that employees and families have access to essential healthcare services, addressing both preventive and ongoing medical needs.

Additionally, Calfus understands the importance of long-term financial planning for its employees. To support this, the company offers a retirement savings plan (401k) where you can start saving as soon as you join!

We offer paid time off (PTO) to eligible U.S. employees. PTO is designed to give you flexibility for rest, personal time, and life needs. Details on accrual and usage are provided in the company's PTO policy.

Calfus Inc. is an Equal Opportunity Employer.

Calfus provides equal opportunity employment (EOE) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. Calfus complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has a presence.

All your information will be kept confidential according to EEO guidelines.