Data Analytics Analyst II
Experience Level: 3-5 Years
Location: Birmingham, AL ( ONSITE)
Client: Alabama Power
Contract- 3 years
Position Summary:
TheData Analytics Analyst IIsupports enterprise analytics, reporting, and data-driven decision-making by working withlarge, 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 strongSQL expertise, experience withcloud data platforms, and the ability to troubleshoot data quality and pipeline issues in a fast-paced, enterprise environment.
Key Responsibilities:
Data Analysis & Reporting
Analyze large, complex datasets to supportenterprise reporting and analytics products
Support and maintaindashboards and reportsusing Power BI, Tableau, or similar BI tools
Translate business questions intoefficient, analytics-ready datasets
Ensure datasets are optimized for visualization performance and usability
SQL & Data Development
Write, optimize, and maintainadvanced SQL queries, including:
Complex joins
CTEs
Window functions
Performance optimization Develop reusable, well-documented SQL assets
Cloud Data Platforms
Work with cloud-based data platforms such as:
Databricks
Azure Synapse
Snowflake
BigQuery (or similar) Understand and supportdata ingestion flowsfrom source systems to cloud storage and analytics layers
Data Modeling & Transformation
Structure data for analytics using:
Fact and dimension models
Wide vs. narrow table designs Prepare datasets optimized for dashboards and enterprise reporting
Data Quality & Validation
Identify data discrepancies betweensource systems and cloud datasets
Troubleshootdata quality, ingestion, and pipeline issues
Facilitateroot-cause analysisand coordinate issue resolution across teams
Required Qualifications:
3-5 years of professional experiencein data analytics, business intelligence, or a related role
Proven experience working withlarge datasets in cloud environments
Advanced SQL proficiency(required)
Experience supportingenterprise 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
Preferred Qualifications:
Experience with Power BI
Experience within the Microsoft Azure ecosystem, including:
Azure Data Factory
Azure SQL
Azure Data Lake Storage (ADLS) Experience with PySpark or Pythonfor data analysis and transformations
Familiarity withETL / ELT pipelinesand orchestration concepts
Experience usingversion control systems(Git or similar)
Basic understanding ofdata governance, lineage, or metadata management
Domain & Business Experience (Preferred)
Experience inutilities, energy, infrastructure, or regulated industries
Familiarity withoperational, asset, or time-series data
Experience working withimperfect or operational source systems