Job description

Role: Microsoft Fabric Analytics Engineer Location: Salt Lake City, UT (Hybrid – 2x/week) Local Candidates Only*** Skill Requirements: Skill Type Skill Name Experience / Details Skill Azure Cosmos DB 2–3 years hands-on, specifically with NoSQL API and complex JSON data Skill Azure Synapse Analytics 3–5 years, focus on Synapse Link and T-SQL Skill Synapse Serverless SQL Pools 3–5 years, focus on Synapse Link and T-SQL Skill Data Integration (Azure Data Factory) 3–5 years building and managing data pipelines Skill Power BI 5+ years as a Power BI expert; advanced data modeling, DAX, Power Query (M Language), report & dashboard development Skill SQL 5+ years advanced SQL for querying and manipulation Other Collaborative, cross-functional team experience Proven ability to work in a collaborative environment ________________________________________ Preferred Skills Skill Type Skill Name Skill: Spark Pools Skill: Git or Azure DevOps for code management Skill: AWS or Google Cloud ________________________________________ Certifications Certification Type Certification Name Certification: Azure Data Analyst Associate (PL-300) Certification: Azure Data Engineer Associate (DP-203) Certification: Azure Cosmos DB Developer Specialty Job Requirements · Azure Cosmos DB: This is the foundational skill. The contractor must have knowledge of Cosmos DB, including its different APIs (especially for NoSQL), and a strong understanding of how to query and handle complex, unstructured JSON data. · Azure Synapse Analytics: This is the central hub for the reporting solution. The contractor needs to be proficient in Azure Synapse, particularly in using Synapse Link for Cosmos DB to enable near-real-time analytics without impacting transactional workloads. This includes: · Synapse Serverless SQL Pools: The ability to write T-SQL queries against the Cosmos DB analytical store. · Data Integration (Azure Data Factory): Experience with building data pipelines to ingest, transform, and load data from various sources into Synapse. · Power BI: This is the reporting layer. The person must be an expert in Power BI, including: · Data Modeling: Strong skills in creating efficient data models, including star schemas, to handle a large volume of data and complex relationships. · DAX (Data Analysis Expressions): Proficiency in writing complex DAX measures, calculated columns, and tables to create meaningful metrics and insights. · Power Query (M Language): Experience with data cleansing, shaping, and transformation in the Power Query editor. · Report & Dashboard Development: The ability to design and build interactive, visually appealing, and high-performance reports and dashboards. · SQL: A solid understanding of SQL is critical for querying and manipulating data in Synapse. Key Responsibilities · The contractor should be able to handle the entire project lifecycle, from initial design to final deployment. Their responsibilities should include: · Solution Architecture: Designing a scalable and cost-effective reporting solution on Azure that leverages Cosmos DB, Azure Synapse, and Power BI. · Data Engineering: Setting up and configuring Azure Synapse Link for your Cosmos DB containers and developing data pipelines to prepare data for reporting. This includes creating T-SQL views in Synapse Serverless SQL pools. · Business Intelligence Development: Developing Power BI reports and dashboards, including data models, DAX measures, and visualizations, to meet complex reporting requirements. · Performance Tuning: Optimizing queries in Synapse and DAX calculations in Power BI to ensure fast report load times and data refreshes. · Stakeholder Collaboration: Working with you and other stakeholders to understand business requirements and translate them into technical specifications and reports. Desirable Qualifications · Experience with large datasets: Proven experience working with large-scale data and optimizing solutions for performance and cost. · Communication Skills: The ability to clearly explain complex technical concepts to non-technical business users. · Spark Pools (nice-to have): Familiarity with PySpark or other languages for more complex data transformations within Synapse.

Requirements