Analytics Engineer

Role Description

Hecla is transforming current ad-hoc Excel-based reporting into a unified data platform. Working with external consultants, we are building the framework for an enterprise analytics platform. The Analytics Engineer will absorb and extend this framework, becoming the internal owner of standards and metrics created in the build-out. You will design, build, and govern the semantic layer that sits between our data pipelines and the business. This role owns the definitions that run the business: KPIs, metrics, dimensions, and hierarchies that business users and report developers can trust and reuse. You will work closely with data engineers, Power BI developers, and operational stakeholders to ensure that business logic is encoded once, governed centrally, and reliably delivered.

• Design and maintain production-grade Microsoft Fabric semantic models that serve as the single source of truth for enterprise metrics
• Define, document, and enforce KPI and metric definitions in collaboration with operational and finance stakeholders
• Build clean, reusable DAX measures and optimized data model relationships across fact and dimension structures
• Design and deliver analysis-ready data structures that translate warehouse data into formats optimized for reporting and decision-making
• Partner with data engineers to align pipeline outputs with semantic layer requirements, ensuring data arriving from upstream processes meets the structure and quality needed for governed reporting
• Establish and enforce naming conventions, measure governance standards, and row-level security patterns
• Audit available operational datasets against business decision needs, identifying gaps and defining requirements for upstream pipeline development
• Manage the lifecycle of metric definitions including versioning, deprecation, and change communication to downstream report consumers
• Document semantic models and provide guidance to Power BI developers consuming them
• Stay current with the Microsoft Fabric and Power BI ecosystem and help shape platform evolution

Qualifications

• 3+ years of experience designing and deploying semantic models or BI data models in production environments
• Analytical mindset; ability to challenge requirements and ensure the right business questions are being answered
• Demonstrated ability to translate ambiguous business requirements into governed, reusable metric definitions
• Strong communication skills with non-technical audiences
• Strong DAX skills with deep understanding of filter context, measure reuse, and model performance optimization
• Solid SQL fundamentals and experience designing star schema or medallion-layer data structures
• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent experience

Preferred Qualifications

• Mining, manufacturing, or process industry background
• Experience with Microsoft Fabric, including Lakehouses, Warehouses, and Dataflows Gen2
• Familiarity with layered data architecture patterns such as medallion architecture (bronze/silver/gold) or equivalent staging and transformation frameworks
• Microsoft Power BI PL-300 certification or DP-600 Fabric Analytics Engineer certification
• Experience with dbt or other transformation frameworks for gold-layer modeling
• Familiarity with data governance tooling such as Microsoft Purview
• Familiarity with IFS Cloud or similar ERP analytical layers
• Experience working alongside or inheriting work from external consultants
• Demonstrated ability to leverage AI tools and emerging technologies to accelerate analytics development

Work Requirements

• Travel: 10-20% of travel may be required, depending on business need
• Work Schedule: Standard business hours with flexibility for different time zones