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