Data Analytics Analyst II 4P/526

4P Consulting Inc.; Birmingham (AL); On-site; USD 75,000 - 95,000; Full time

Job summary

A consulting firm is looking for a Data Analytics Analyst II in Birmingham, AL. The role involves analyzing complex datasets, ensuring data quality, and working with cloud platforms like Databricks and Azure Synapse. Candidates should have 3–5 years of experience in data analytics, possess advanced SQL skills, and be adept at troubleshooting data issues. The position supports enterprise analytics and reporting, making a significant impact on data-driven decision-making within the organization.

Qualifications

• 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).

Responsibilities

• Analyze large, complex datasets to support enterprise reporting and analytics products.
• Write, optimize, and maintain advanced SQL queries, including complex joins and CTEs.
• Work with cloud-based data platforms such as Databricks and Azure Synapse.

Skills

SQL expertise

Data analysis

Problem-solving

Cloud data platforms

Data quality troubleshooting

Education

3–5 years of experience in data analytics or related role

Tools

Power BI

Tableau

Databricks

Azure Synapse

Snowflake

BigQuery

Job description

Data Analytics Analyst II

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

Client- Alabama Power

Contract- 3 years

Position Summary

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.

Key Responsibilities

Data Analysis & Reporting

• 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

SQL & Data Development

• Write, optimize, and maintain advanced 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 support data ingestion flows from 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 between source systems and cloud datasets
• Troubleshoot data quality, ingestion, and pipeline issues
• Facilitate root-cause analysis and coordinate issue resolution across teams

Required Qualifications

• 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

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 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

Domain & Business Experience (Preferred)

• Experience in utilities, energy, infrastructure, or regulated industries
• Familiarity with operational, asset, or time-series data
• Experience working with imperfect or operational source systems