Data Analytics Engineer

Data Analytics Engineer position in Bozeman, MT (remote) focusing on the Microsoft Fabric Lakehouse stack, Power BI reporting, and analytics across sales, inventory, customer, and finance to drive insights and decision-making.

Responsibilities

• Collaborate with stakeholders to translate business requirements into scalable, data-driven analytics solutions.
• Demonstrate hands-on expertise with the Microsoft Fabric ecosystem, including Lakehouse, PySpark/SQL notebooks, data pipelines, and deployment pipelines; familiarity with Microsoft Dynamics as a data source is a plus.
• Design data models that connect the Fabric Lakehouse, Power BI semantic models, and reporting layers to ensure consistency across raw, curated, and business-facing data.
• Optimize data models for efficient storage, retrieval, and analysis while preserving data integrity and reliability; knowledge of Fabric capacity optimization is desirable.
• Implement data integration pipelines using Fabric and complementary tools to extract, transform, and load data from diverse sources into a unified data platform.
• Build visually engaging dashboards, reports, and visualizations using Power BI and DAX to enable actionable insights.
• Identify performance bottlenecks and apply targeted optimizations to data processing, queries, and overall system efficiency.
• Provide technical leadership and guidance to data engineers, analysts, and stakeholders to ensure successful project delivery.
• Stay current with advancements in data analytics technologies and industry trends, applying best practices to solution design and implementation.

Requirements

• Experience as a Data Engineer owning core data pipelines, with a focus on Microsoft Fabric and Azure technologies.
• Extensive hands-on knowledge of Microsoft Fabric including the medallion architecture with Lakehouse, PySpark notebooks, and data/deployment pipelines.
• Proven ability to design and maintain scalable semantic models (Power BI / Tabular / DAX) delivering a governed analytics layer across the business.
• Establish and maintain best practices for version control, CI/CD, testing, and deployment of data pipelines and semantic models.
• Proficiency in data visualization using Power BI and DAX.
• Strong problem-solving skills and the ability to design scalable, efficient data analytics architectures.
• Solid understanding of data warehousing concepts, governance, and data quality principles.
• Awareness of data security and compliance considerations in analytics contexts.
• Customer-focused approach to supporting teams and business functions with analytics needs.
• Ability to present, facilitate, and participate in requirements elicitation and brainstorming in small to medium group environments.
• A track record of delivering impactful solutions with ownership and accountability.

Technologies

• Microsoft Fabric
• Lakehouse
• PySpark
• SQL notebooks
• Data pipelines
• Deployment pipelines
• Microsoft Dynamics
• Power BI
• DAX
• Azure
• Tabular

Benefits

• Generous employee discount on a wide range of products from apparel to tools and pet supplies.
• Multiple health insurance options after 60 days to fit diverse needs.
• Dental and vision coverage to complete health protection.
• Life insurance to help secure your family’s financial future.
• Paid vacation to rest and recharge.
• Holiday pay throughout the year to celebrate with family.
• Paid sick time to focus on health without losing pay.
• 401(k) with a 4% company match to support retirement planning.
• Paid parental leave for bonding with a new addition to your family.
• Community Giving Program that matches donations and provides paid volunteer hours.
• Wellness program aimed at reducing medical premiums through credits.
• Training program offering access to over 250 courses to grow skills.
• Other voluntary insurance options available.

Physical Demands

• Sitting for extended periods.
• Repetitive wrist movements while using a keyboard.
• Close vision requirements for computer work.
• Bending, carrying, and pushing as part of duties.
• Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions.