Fabric Analytics Engineer

Fabric Analytics Engineer
Salt Lake City, UT
3-6 Month Contract: $65-$85 per hour

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

• Power BI: This is the reporting layer. The person must be an expert in Power BI,
• • 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.

Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.

Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.

Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.

Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at .

We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.