Business Intelligence Developer

Ultradent Products Inc. seeks a Business Intelligence Developer to build, implement, automate, and support cloud based Microsoft BI solutions on Azure, with a strong CRM and Finance focus to deliver richer customer insights and more accurate financial reporting.

Location

South Jordan, Utah, onsite

Responsibilities

• Collaborate with internal stakeholders, primarily within CRM and Finance, to identify business needs, define solution visions, address objections, and deliver measurable results through solid technical expertise.
• Design and implement ETL routines in Azure Data Factory, build and maintain Power BI semantic models (data cubes), and develop high performing reports and dashboards for CRM analytics (customer lifecycle, pipeline, retention) and Finance reporting (P&L, budgeting, forecasting, revenue recognition).
• Define physical table structures in Azure Data Warehouse, including modifications required to support reporting requirements and the overall data model.
• Apply data modeling principles to build tabular models from scratch and continuously improve those models based on user feedback.
• Coordinate with Project Managers, Business Analysts, stakeholders, and management throughout all phases of the Software Development Life Cycle, ensuring deadlines are met and output quality remains high.
• Leverage AI capabilities, including Power BI Copilot and AI Builder, and agentic automation tools to accelerate report delivery, surface anomalies, and reduce manual data preparation effort.

Requirements

• A four-year degree in Information Systems, Computer Science, Statistics, Business, Accounting, Finance, or a related field from an accredited university, or equivalent additional experience.
• Minimum of five years of successful, results-oriented experience across a diverse range of business and IT functions.
• Experience developing pricing models, financial KPIs, and CRM driven metrics and reporting.
• Hands-on experience with the Microsoft BI Stack, including Azure Data Warehouse, Azure Data Factory, Power BI (semantic models/data cubes), and Power Platform.
• Strong command of Power BI, including data cube (tabular model) design, DAX, Power Query, and report or dashboard development.
• Experience integrating CRM data (Dynamics 365, Salesforce) into Azure-based BI solutions to support sales, pipeline, and customer analytics.
• Proficiency with SQL, including DDL, stored procedures, views, and functions.
• Familiarity with AI powered BI features (Power BI Copilot, AI Builder) and an interest in applying AI automation and agentic tools to data and reporting workflows.
• In-depth experience with source control management systems such as Git.
• High performance orientation with the ability to work well under pressure, prioritize projects, meet deadlines, and maintain flexibility.
• Strong attention to detail, organization, and time management skills.
• Self-starter with a positive attitude and the ability to deliver projects on time with minimal supervision.

Technologies

• Azure Data Warehouse
• Azure Data Factory
• Power BI (semantic models/data cubes)
• Power Platform
• DAX
• Power Query
• SQL
• Git
• Dynamics 365
• Salesforce
• Power BI Copilot
• AI Builder