Data Analytics Analyst II

Data Analytics Analyst II

Experience Level: 3–5 Years
Location
- Birmingham, AL (ONSITE)

Client
- Alabama Power

Contract- 3 years

The Data Analytics Analyst II supports enterprise analytics, reporting, and data-driven decision-making by working with large, complex datasets in cloud-based environments
. This role partners closely with data engineers, business stakeholders, and subject matter experts to ensure accurate, reliable, and well-structured data for dashboards, reports, and analytical products.

The ideal candidate brings strong SQL expertise
, experience with cloud data platforms
, and the ability to troubleshoot data quality and pipeline issues in a fast-paced, enterprise environment.

• Analyze large, complex datasets to support enterprise reporting and analytics products

• Support and maintain dashboards and reports using Power BI, Tableau, or similar BI tools

• Translate business questions into efficient, analytics-ready datasets

• Ensure datasets are optimized for visualization performance and usability

• Write, optimize, and maintain advanced SQL queries
  , including:

  • Complex joins

  • CTEs

  • Window functions

  • Performance optimization

• Develop reusable, well-documented SQL assets

• Work with cloud-based data platforms such as:

  • Databricks

  • Azure Synapse

  • Snowflake

  • Big Query (or similar)

• Understand and support data ingestion flows from source systems to cloud storage and analytics layers

• Structure data for analytics using:

  • Fact and dimension models

  • Wide vs. narrow table designs

• Prepare datasets optimized for dashboards and enterprise reporting

• Identify data discrepancies between source systems and cloud datasets

• Troubleshoot data quality, ingestion, and pipeline issues

• Facilitate root-cause analysis and coordinate issue resolution across teams

• 3–5 years of professional experience in data analytics, business intelligence, or a related role

• Proven experience working with large datasets in cloud environments

• Advanced SQL proficiency (required)

• Experience supporting enterprise dashboards and analytics products

• Strong analytical, problem-solving, and troubleshooting skills

• Ability to work independently while collaborating with data engineers and SMEs

• Strong written and verbal communication skills

• Experience with
  Power BI

• Experience with in the Microsoft Azure ecosystem
  , including:

  • Azure Data Factory

  • Azure SQL

  • Azure Data Lake Storage (ADLS)

• Experience with
  PySpark or Python for data analysis and transformations

• Familiarity with ETL / ELT pipelines and orchestration concepts

• Experience using version control systems (Git or similar)

• Basic understanding of data governance, lineage, or metadata management

• Experience in utilities, energy, infrastructure, or regulated industries

• Familiarity with operational, asset, or time-series data

• Experience working with imperfect or operational source systems