Talent.com
Azure Data Engineer (Only locals to Utah - Hybrid)

Azure Data Engineer (Only locals to Utah - Hybrid)

Cleo ConsultingSalt Lake Cty, UT, United States
4 days ago
Job type
  • Full-time
  • Quick Apply
Job description

Client : State of Utah

Job ID : 150760

Job Title : Salt Lake City, UT - IT - Salt Lake County - N / A - Microsoft Fabric Analytics Engineer

Job Location : 2001 South State Street, Salt Lake City, Utah, 84114

Projected Start date : 12 / 01 / 2025

Duration : Length of assignment is anticipated to be 2 6 months

This is a repost of 148923. Previously interviewed candidates should not reapply but previously submitted candidates who did not interview but meet requirements can apply.

Hybrid schedule : All SLC employees and contractors are to be onsite two days of the week (Tuesdays and Wednesdays)

Candidate must be a US Citizen, Local candidates only. This is a job requirement. If bid is a non-local candidate that person will be rejected.

No not-to-exceed bill rate. Bids should be in line with market rates.

Salt Lake County is looking for a Microsoft Fabric Analytics Engineer

Why is this a need? They have an Immediate need to provide Tax admin agencies reporting as TORUS goes live

Required skills :

  • Azure Cosmos DB (2-3 years of hands-on experience, specifically with the NoSQL API and complex JSON data.)
  • Azure Synapse Analytics (3-5 years of experience, with a focus on Synapse Link and T-SQL)
  • Synapse Serverless SQL Pools (3-5 years of experience, with a focus on Synapse Link and T-SQL)
  • Data Integration (Azure Data Factory) (3-5 years of experience building and managing data pipelines.)
  • Power BI (5+ years of experience as a Power BI expert, with a strong portfolio showcasing advanced skills in data modeling, DAX, and Power Query (M Language).)
  • SQL (5+ years of experience with advanced SQL for querying and manipulation.)
  • Proven experience in a collaborative, cross-functional team environment

Preferred Skills

  • Spark Pools
  • Git or Azure DevOps for code management
  • AWS or Google Cloud
  • Azure Data Analyst Associate (PL-300)
  • Azure Data Engineer Associate (DP-203)
  • 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.
  • Create a job alert for this search

    Azure Data Engineer • Salt Lake Cty, UT, United States

    Related jobs
    • Promoted
    Data Engineer (AML)

    Data Engineer (AML)

    ASCENDINGSalt Lake City, UT, US
    Permanent
    Data Engineer – Identity & Age Verification.Remote within the United States.Join a mission-driven team working to revolutionize how data is used while helping clients meet AML, KYC, and A...Show moreLast updated: 18 days ago
    • Promoted
    • New!
    NG Fellow 1 - SDS Division Chief Data Engineer

    NG Fellow 1 - SDS Division Chief Data Engineer

    Northrop GrummanRoy, UT, US
    Full-time
    RELOCATION ASSISTANCE : Relocation assistance may be available.At Northrop Grumman, our employees have incredible opportunities to work on revolutionary systems that impact people's lives around the...Show moreLast updated: less than 1 hour ago
    Data Engineer

    Data Engineer

    RICEFW Technologies IncSalt Lake City, UT, United States
    Full-time
    Quick Apply
    Microsoft Fabric Analytics Engineer Job Requirements &...Show moreLast updated: 4 days ago
    • Promoted
    Senior Data Engineer

    Senior Data Engineer

    JobotSalt Lake City, UT, US
    Full-time
    REMOTE Senior Data Solutions Engineer / Lead Data Engineer Needed for Industry-Leader!.This Jobot Job is hosted by : Reed Kellick. Are you a fit? Easy Apply now by clicking the "Apply Now" button and...Show moreLast updated: 9 days ago
    • Promoted
    NG Fellow 1 – SDS Division Chief Data Engineer

    NG Fellow 1 – SDS Division Chief Data Engineer

    Northrop GrummanRoy, UT, US
    Full-time
    RELOCATION ASSISTANCE : Relocation assistance may be available.At Northrop Grumman, our employees have incredible opportunities to work on revolutionary systems that impact people's lives around th...Show moreLast updated: 7 days ago
    • Promoted
    Sr. DataOps Engineer

    Sr. DataOps Engineer

    BambooHRDraper, UT, US
    Full-time
    Please Note : This is a Utah-based hybrid position which will require some regular in-office days each week.Additionally, employment with BambooHR is contingent on passing both a background and cred...Show moreLast updated: 2 days ago
    • Promoted
    Data Engineer (First hire!)

    Data Engineer (First hire!)

    LelandLehi, UT, US
    Full-time
    Leland’s mission is to unlock human potential by making the world’s expertise more accessible.We do that through a platform that connects people with coaching, content, and courses that...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Cloud Engineer

    Senior Cloud Engineer

    Western Governors UniversitySalt Lake City, UT, United States
    Full-time +1
    If you're passionate about building a better future for individuals, communities, and our country-and you're committed to working hard to play your part in building that future-consider WGU as the ...Show moreLast updated: 30+ days ago
    • Promoted
    Senior AI Engineer - USA

    Senior AI Engineer - USA

    PodiumLehi, UT, US
    Full-time
    At Podium, our mission is to arm every local business with a complete platform and outcome-driven AI employees that convert leads into real, paying customers. Every day, millions of workers use our ...Show moreLast updated: 20 days ago
    • Promoted
    Azure Data Developer

    Azure Data Developer

    GovCIOSalt Lake City, UT, United States
    Full-time
    GovCIO is currently hiring for anAzure Cloud Notebook Python / PySpark developer to develop, test and implement AzureNotebook, PySpark / Python ETL and is experienced in Synapse database and SQL develo...Show moreLast updated: 7 days ago
    • Promoted
    Software Engineer, Data Infrastructure & Acquisition - Salt Lake City, USA

    Software Engineer, Data Infrastructure & Acquisition - Salt Lake City, USA

    SpeechifySalt Lake City, UT, US
    Full-time
    PLEASE APPLY THROUGH THIS LINK : https : / / job-.The mission of Speechify is to make sure that reading is never a barrier to learning. Over 50 million people use Speechify's text-to-speech products ...Show moreLast updated: 30+ days ago
    • Promoted
    Project Engineer - Data Center - PM Standardized

    Project Engineer - Data Center - PM Standardized

    Cupertino ElectricEagle Mountain, UT, United States
    Full-time
    Project Engineer - Data Center.San Jose, California | Los Lunas, New Mexico | Columbus, Ohio | New Albany, Ohio | Eagle Mountain, Utah | Urbandale, Iowa | Sparks, Nevada | Bowling Green, Ohio | Ced...Show moreLast updated: 3 days ago
    • Promoted
    Sr AWS Cloud DevOps Engineer

    Sr AWS Cloud DevOps Engineer

    Unisys CorporationSalt Lake City, UT, United States
    Full-time
    What success looks like in this role : .DevSecOps Pipeline Design & Automation : .Design and implement secure, automated CI / CD pipelines in AWS using tools like AWS CodePipeline, Jenkins, GitLab CI, an...Show moreLast updated: 30+ days ago
    • Promoted
    Lead Software Engineer - Data Platform

    Lead Software Engineer - Data Platform

    RelativitySalt Lake City, UT, United States
    Full-time
    Join our team as we reimagine and modernize the core of Relativity's data architecture.You'll play a pivotal role in transforming the Document Domain - a foundational component of our platform-into...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Data Architect

    Senior Data Architect

    Entrata, Inc.Lehi, UT, US
    Full-time
    Senior Data Architect (Entrata, Inc.Lehi, UT) Lead the design of performant, scalable systems using machine learning and data engineering best practices. establish coding standards and mentor data ...Show moreLast updated: 12 days ago
    • Promoted
    Data Engineer

    Data Engineer

    England LogisticsSalt Lake City, UT, US
    Full-time
    Build the Future of Data at England Logistics!.At England Logistics, our business is logistics, but our passion is people. As a top third-party logistics provider, we’re committed to leveragin...Show moreLast updated: 9 days ago
    • Promoted
    Data Engineer

    Data Engineer

    AristotleProvo, UT, US
    Full-time
    Aristotle, a leading player in the computer software industry, is currently seeking a talented and driven Data Engineer to join our dynamic team. At Aristotle, we have a deep-rooted belief in the im...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Cloud Engineer (Azure)

    Senior Cloud Engineer (Azure)

    Medallion BankSalt Lake City, UT, US
    Full-time
    At Medallion Bank we finance fun! We are an industrial loan bank that specializes in providing consumer loans for the purchase of recreational vehicles, boats, home improvement, and offering loan o...Show moreLast updated: 30+ days ago