Skip to main content

Data Analytics Analyst II 4P/526

4p consultingVestavia Hills, ALSenior L5
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
APPLY NOW (opens in a new tab)

Matching similar jobs

Level

Senior L5

Location

Vestavia Hills, AL

Occupation

Business Intelligence Analysts

Industry

Computer Systems Design Services

Posted

yesterday

APPLY NOW (opens in a new tab)