Business Intelligence (BI) Developer

Wheeler Machinery Co•Salt Lake City, UT

just now

About The Position

The BI Developer builds and maintains BI tools, dashboards, reports, semantic models, and interfaces. With a primary focus on transforming Silver layer data into curated Gold layer tables in Microsoft Fabric, this role handles coding for data integration, transformation, visualization (using Power BI/Fabric), and custom solutions to deliver high-quality data assets and actionable insights.

Requirements

Bachelor's degree in Computer Science, Data Analytics, Information Systems, or related field (or equivalent experience).
3+ years in BI/data development roles,
Proficiency in SQL, DAX, and data modeling; familiarity with medallion architecture (Bronze/Silver/Gold layers).
Experience building semantic models and Power BI reports/dashboards.
Solid understanding of data warehousing principles, ETL processes, and analytics techniques.
Excellent communication skills to bridge technical and business audiences.

Nice To Haves

Certifications in Microsoft Fabric, Power BI, or Azure Data fundamentals.
Knowledge of Python/Spark for advanced transformations.
Hands-on experience in Microsoft Fabric (Lakehouse, Data Pipelines, Notebooks) or similar (e.g., Azure Synapse, Databricks).

Responsibilities

Design, build, and maintain Gold layer tables in Microsoft Fabric Lakehouse, with a focus on transforming Silver layer sources through cleansing, aggregation, and business-rule applications within a medallion architecture.
Develop and optimize semantic models in Power BI/Fabric, including relationships, DAX measures, and calculations to support reusable data assets.
Implement ETL/ELT pipelines using Fabric tools (Dataflows, Notebooks, Pipelines) to enable efficient transformations, quality checks, and performance tuning.
Ensure data lineage and quality standards across layers.
Create interactive dashboards, reports, and visualizations in Power BI to translate data into clear, actionable insights for stakeholders.
Perform data analysis to identify trends, patterns, and opportunities that support business decision-making.
Gather requirements from business users, prototype solutions, and iterate on reports and models.
Contribute to self-service BI enablement by documenting models and supporting user adoption of semantic models.
Participate in code reviews, knowledge sharing, and process improvements to enhance overall team efficiency.
Participate in daily stand-up meetings and follow agile development practices along with any assigned duties.