Data Analytics Analyst III  4P/650

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