Data Analytics Analyst II 4P/526

Data Analytics Analyst IIExperience Level: 3-5 YearsLocation- Birmingham, AL ( ONSITE)Client- Alabama PowerContract- 3 years Position SummaryThe 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 ResponsibilitiesData Analysis & ReportingAnalyze large, complex datasets to support enterprise reporting and analytics productsSupport and maintain dashboards and reports using Power BI, Tableau, or similar BI toolsTranslate business questions into efficient, analytics-ready datasetsEnsure datasets are optimized for visualization performance and usabilitySQL & Data DevelopmentWrite, optimize, and maintain advanced SQL queries, including:Complex joinsCTEsWindow functionsPerformance optimizationDevelop reusable, well-documented SQL assetsCloud Data PlatformsWork with cloud-based data platforms such as:DatabricksAzure SynapseSnowflakeBigQuery (or similar)Understand and support data ingestion flows from source systems to cloud storage and analytics layersData Modeling & TransformationStructure data for analytics using:Fact and dimension modelsWide vs. narrow table designsPrepare datasets optimized for dashboards and enterprise reportingData Quality & ValidationIdentify data discrepancies between source systems and cloud datasetsTroubleshoot data quality, ingestion, and pipeline issuesFacilitate root-cause analysis and coordinate issue resolution across teamsRequired Qualifications3-5 years of professional experience in data analytics, business intelligence, or a related roleProven experience working with large datasets in cloud environmentsAdvanced SQL proficiency (required)Experience supporting enterprise dashboards and analytics productsStrong analytical, problem-solving, and troubleshooting skillsAbility to work independently while collaborating with data engineers and SMEsStrong written and verbal communication skillsPreferred QualificationsExperience with Power BIExperience within the Microsoft Azure ecosystem, including:Azure Data FactoryAzure SQLAzure Data Lake Storage (ADLS)Experience with PySpark or Python for data analysis and transformationsFamiliarity with ETL / ELT pipelines and orchestration conceptsExperience using version control systems (Git or similar)Basic understanding of data governance, lineage, or metadata managementDomain & Business Experience (Preferred)Experience in utilities, energy, infrastructure, or regulated industriesFamiliarity with operational, asset, or time-series dataExperience working with imperfect or operational source systems Data Analytics Analyst IIExperience Level: 3-5 YearsLocation- Birmingham, AL ( ONSITE)Client- Alabama PowerContract- 3 years Position SummaryThe 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 ResponsibilitiesData Analysis & ReportingAnalyze large, complex datasets to support enterprise reporting and analytics productsSupport and maintain dashboards and reports using Power BI, Tableau, or similar BI toolsTranslate business questions into efficient, analytics-ready datasetsEnsure datasets are optimized for visualization performance and usabilitySQL & Data DevelopmentWrite, optimize, and maintain advanced SQL queries, including:Complex joinsCTEsWindow functionsPerformance optimizationDevelop reusable, well-documented SQL assetsCloud Data PlatformsWork with cloud-based data platforms such as:DatabricksAzure SynapseSnowflakeBigQuery (or similar)Understand and support data ingestion flows from source systems to cloud storage and analytics layersData Modeling & TransformationStructure data for analytics using:Fact and dimension modelsWide vs. narrow table designsPrepare datasets optimized for dashboards and enterprise reportingData Quality & ValidationIdentify data discrepancies between source systems and cloud datasetsTroubleshoot data quality, ingestion, and pipeline issuesFacilitate root-cause analysis and coordinate issue resolution across teamsRequired Qualifications3-5 years of professional experience in data analytics, business intelligence, or a related roleProven experience working with large datasets in cloud environmentsAdvanced SQL proficiency (required)Experience supporting enterprise dashboards and analytics productsStrong analytical, problem-solving, and troubleshooting skillsAbility to work independently while collaborating with data engineers and SMEsStrong written and verbal communication skillsPreferred QualificationsExperience with Power BIExperience within the Microsoft Azure ecosystem, including:Azure Data FactoryAzure SQLAzure Data Lake Storage (ADLS)Experience with PySpark or Python for data analysis and transformationsFamiliarity with ETL / ELT pipelines and orchestration conceptsExperience using version control systems (Git or similar)Basic understanding of data governance, lineage, or metadata managementDomain & Business Experience (Preferred)Experience in utilities, energy, infrastructure, or regulated industriesFamiliarity with operational, asset, or time-series dataExperience working with imperfect or operational source systems

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., * 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 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