Data Analytics Analyst III 4P/650

4P Consulting

  • Atlanta, Georgia
  • 30+ days ago

    Highlights

    The ideal candidate can translate business questions into structured analytical datasets and actionable dashboards while coordinating small-to-mid-sized analytics workstreams. We are seeking an experienced Data Analytics Analyst III with strong expertise in data modeling, Power BI, SQL, and Azure-based analytics environments .

    Numbers & Facts

    LocationAtlanta, Georgia

    Description

    Data Analytics Analyst III 

     Location: Atlanta, Ga
     Contract- 6 Months on W-2 
    Client- Georgia Power
    GC & US Citizen only

    Position Overview

    We are seeking an experienced Data Analytics Analyst III with strong expertise in data modeling, Power BI, SQL, and Azure-based analytics environments.

    This role blends advanced analytics, BI development, and cloud-based data preparation within a modern lakehouse architecture (Databricks / Delta Lake). The ideal candidate can translate business questions into structured analytical datasets and actionable dashboards while coordinating small-to-mid-sized analytics workstreams.

    Key Responsibilities

    Data Modeling & Architecture

    • Design and implement dimensional and relational data models:
      • Star schema
      • Conceptual, logical, and physical models
      • Enterprise data structures
    • Apply best practices for performance optimization and scalability.

    SQL & Data Engineering

    • Develop advanced SQL queries across relational databases:
      • Azure SQL
      • SQL Server
      • PostgreSQL
    • Work within Databricks and Delta Lake notebook environments.
    • Support ETL/ELT processes, data validation, and data performance tuning.

    Business Intelligence & Reporting

    • Develop and maintain enterprise dashboards using Power BI.
    • Create semantic models using:
      • DAX
      • Power Query (M)
    • Apply visualization best practices and dashboard UI/UX standards.
    • Translate business requirements into analytical datasets and KPIs.

    Data Preparation & Cloud Analytics

    • Work within Azure analytics ecosystems:
      • Azure Data Factory
      • Azure Synapse
      • Microsoft Fabric
    • Utilize Databricks SQL or Spark SQL for advanced analytical queries.

    Project & Stakeholder Coordination

    • Coordinate small to mid-sized analytics projects or workstreams.
    • Partner with business stakeholders to clarify requirements.
    • Provide data-driven insights to support strategic decisions.

    Required Qualifications

    • 5–10 years of experience in data analytics or BI roles.
    • Strong experience with:
      • Data modeling (dimensional/star schema)
      • SQL and relational databases
      • Power BI (DAX, Power Query, dataset modeling)
    • Hands-on experience with:
      • Databricks
      • Delta Lake
      • Notebook-based development
    • Strong Excel skills:
      • Power Query
      • Power Pivot
      • Advanced formulas
    • Ability to convert business questions into structured analytical outputs.

    Preferred Qualifications

    • Experience with:
      • Power Apps
      • Power Automate
    • Exposure to Azure analytics tools (ADF, Synapse, Fabric).
    • Experience with Python or R for data transformation.
    • Knowledge of:
      • Data governance
      • Metadata management
      • Data stewardship
    • Familiarity with Spark SQL or Databricks SQL.

    Technical Skills Summary

    • SQL (Azure SQL / SQL Server / PostgreSQL)
    • Power BI (DAX / M / Semantic Modeling)
    • Databricks / Delta Lake
    • Data Modeling (Star Schema / Lakehouse)
    • ETL / ELT Concepts
    • Excel (Advanced)
    • Azure Cloud Analytics
    • Spark SQL (Preferred)

    Core Competencies

    • Strong analytical and critical thinking skills
    • Business translation capability (technical business)
    • Attention to data quality and validation
    • Project coordination and stakeholder management
    • Ability to work in cloud-based, modern data ecosystems

    Similar Jobs