Data Analytics Engineer at Murdoch's Ranch & Home Supply

United States

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, ID, 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. Requirements 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! Physical Demands: Sitting for long periods of time. Repetitive wrist movements on keyboard. Close vision for PC work. Bending, carrying, and pushing. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Competitive Benefits + Compensation: Amazing Employee Discount on everything from clothes to power tools to pet food. Multiple Health Insurance* options to best suit your needs after 60 days. Dental & Vision options to complete your health plan. Life Insurance to secure your family’s financial future. Paid Vacation* allows you to relax and recharge. Holiday Pay throughout the year so you can celebrate with your family. Paid Sick Time** empowers you to stay home and focus on your health without losing pay. 401(k) with a generous 4% company match to help plan for retirement. Paid Parental Leave* to take time to bond with your family’s new addition. Community Giving Program matches your donations and provides paid volunteer hours. Wellness Program* saves you money by lowering medical premiums with credits earned. Training Program helps you expand your knowledge and skills with over 250 courses. Other various Voluntary Insurance Options. #LI-CS1