Data Analytics Engineer

Description

We are seeking a highly skilled and experienced Data Analytics Engineer with a strong focus on Microsoft technologies to join our team. As a Data Analytics Engineer, you will play a critical role in designing, implementing, and optimizing data analytics solutions leveraging Microsoft's suite of tools and technologies. Your expertise will be instrumental in transforming complex data into actionable insights, driving business growth, and supporting decision‑making processes while actively participating in new opportunity pursuits.

You will work with retail data domains such as sales, inventory, customer, and finance to design models that power operational and analytical decision‑making across the business. This role is very technically focused and will co‑own the design and evolution of the company’s Microsoft Fabric Lakehouse architecture, including the downstream Power BI semantic layer. Your workplace is flexible – we have offices in Bozeman Montana or wherever you feel most productive.

This position can be fully remote for candidates residing in AZ, CO, FL, GA, IA, , MT, MO, NE, NV, NC, PA, SD, TN, TX, UT, VA, WY
.

As a Murdoch’s Team Member in this role, you will …

• Collaborate with stakeholders to understand business requirements and translate them into scalable and efficient data analytics solutions.
• Possess in-depth knowledge and hands‑on experience with Microsoft Fabric ecosystem (Lakehouse, PySpark/SQL notebooks, data pipelines, and deployment pipelines). Understanding Microsoft Dynamics as a data source a big plus.
• Design data models that bridge the Fabric Lakehouse, Power BI semantic models, and reporting layers, ensuring consistency between raw, curated, and business‑facing data.
• Optimize data models to support efficient data storage, retrieval, and analysis, ensuring data integrity, accuracy, and reliability. Knowledge of Fabric capacity (CU) optimization a big plus.
• Implement data integration pipelines using Microsoft Fabric and other relevant tools to extract, transform, and load data from various sources into a unified data platform.
• Create visually appealing and interactive dashboards, reports, and visualizations using Microsoft Power BI and DAX language, enabling users to gain valuable insights from data.
• Identify performance bottlenecks and implement optimizations to improve data processing, query performance, and overall system efficiency.
• Collaborate with cross‑functional teams, providing technical leadership and guidance to data engineers, analysts, and other stakeholders to ensure successful project delivery.
• Keep abreast of the latest advancements in data analytics technologies (Microsoft based and others) and industry trends, continuously enhancing your expertise and applying best practices in solution design and implementation.

As a Murdochian in this role, you must…

• Experience as a Data Engineer owning core data pipelines, with a primary focus on Microsoft Fabric and Azure technologies.
• Extensive knowledge and hands‑on experience with Microsoft Fabric. Including knowledge of medallion architecture using Lakehouse, Pyspark notebooks, data and deployment pipelines.
• Experience designing and maintaining scalable semantic models (Power BI / Tabular / DAX) to provide a consistent, 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 techniques using Power BI / DAX.
• Strong problem‑solving skills and ability to design scalable and efficient data analytics architectures.
• Excellent understanding of data warehousing concepts, data governance, and data quality principles.
• Solid knowledge of data security and compliance considerations in the context of data analytics.
• Strong customer service focus for helping the team and business functions with their data analytics needs.
• Ability to present, facilitate and participate in requirements elicitation and brainstorming sessions with internal and external teams in small and medium group environments.
• Track record of building impactful solutions that you are proud to stand behind!