Data Analytics Engineer

Role Overview

• 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

• 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!

Tech Stack

• Azure
• PySpark
• SQL

Benefits

• 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.