Hybrid Details:  Onsite Tuesdays & Wednesdays

Duration: 3 months to start

Job Description
Our client is looking for a Microsoft Fabric Analytics Engineer. They have an Immediate need to provide agencies reporting.

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.

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

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