What are the responsibilities and job description for the Business Intelligence (BI) Developer position at Wheeler Machinery Co.?
Description
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.
This position is not remote. Applicants must be located in the Salt Lake City, UT area and available to work on-site Monday through Friday from 8:00 a.m. to 5:00 p.m.
Key Responsibilities
__________________________________________________________________________________________________________________
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c).
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.
This position is not remote. Applicants must be located in the Salt Lake City, UT area and available to work on-site Monday through Friday from 8:00 a.m. to 5:00 p.m.
Key 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.
- 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.
- 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).
__________________________________________________________________________________________________________________
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c).