Reporting Analyst2

Description

Position Overview

BLOC Resources is seeking an experienced and highly analytical Reporting Analyst 2 to support Southern Company operations in Atlanta, Georgia.

The Reporting Analyst 2 will be responsible for analyzing business processes, collecting and validating data, developing reports and dashboards, investigating reporting and data discrepancies, and providing actionable insights that support operational efficiency and data-driven decision-making.

This position requires a professional with approximately 5-10 years of experience in reporting, business analysis, data analytics, process improvement, business intelligence, or a related discipline.

The successful candidate will work collaboratively with business stakeholders, process owners, subject-matter experts, reporting teams, and technical teams to gather requirements, analyze complex datasets, develop meaningful performance metrics, identify process inefficiencies, investigate reporting issues, and communicate findings to both technical and nontechnical audiences.

The ideal candidate will bring strong experience with Power BI, SQL, Microsoft Excel, data visualization, reporting dashboards, data validation, and business-process analysis. Experience with Databricks or a comparable cloud data and analytics platform is highly valuable.

Requirements

Key Responsibilities
Data Analysis & Business Insights

• Collect, analyze, interpret, and validate data associated with business processes and operational performance.
• Analyze complex datasets to identify trends, patterns, anomalies, and opportunities for improvement.
• Utilize analytical and statistical techniques to generate meaningful business insights.
• Perform expected-versus-actual comparisons and data reconciliations.
• Translate data findings into actionable recommendations.
• Investigate discrepancies and determine whether issues originate from source data, business rules, reporting logic, configuration, security, or user interpretation.
• Support management and business stakeholders with reliable information for decision-making.

Reporting & Dashboard Development

• Develop, maintain, and enhance reports, dashboards, KPIs, and performance metrics.
• Create reporting solutions that provide meaningful visibility into business and process performance.
• Develop clear, visually effective, and easy-to-understand reports for stakeholders at multiple organizational levels.
• Support Power BI reports, dashboards, paginated reports, parameters, refreshes, subscriptions, and report validation.
• Monitor reporting outputs for accuracy, completeness, and consistency.
• Validate calculations, filters, parameters, relationships, and business rules used within reports.
• Assist with production validation following report changes, fixes, reruns, or deployments.

Power BI & Business Intelligence

• Utilize Microsoft Power BI to analyze, visualize, and communicate business information.
• Support existing Power BI reporting solutions and dashboards.
• Investigate report questions, data discrepancies, refresh issues, and access concerns.
• Validate Power BI report behavior against expected business results.
• Assist users in understanding report calculations, definitions, filters, refresh timing, and known limitations.
• Support reporting adoption and business-user understanding.
• Work with reporting-development teams when issues require technical escalation.

SQL & Data Investigation

• Write and interpret SQL queries for data analysis, investigation, reconciliation, and validation.
• Use joins, filters, aggregations, and other query techniques to analyze data.
• Trace data through applicable source and reporting environments.
• Compare source information against report outputs to identify discrepancies.
• Investigate anomalies and support root-cause analysis.
• Validate transformations and business rules when troubleshooting reporting issues.
• Document analytical findings and supporting evidence.

Databricks & Data Platform Support

• Utilize Databricks or comparable cloud data and analytics platforms to support reporting investigations.
• Navigate data environments to identify relevant tables, views, and reporting data.
• Use SQL-based analysis to investigate data anomalies and discrepancies.
• Trace information from source systems through data-processing and reporting layers.
• Review data transformations, joins, filters, aggregations, and source-to-target results.
• Recognize potential data-quality, processing, transformation, or reporting issues.
• Partner with Data Engineering and reporting-development teams when deeper technical investigation is required.
• Support testing, release validation, and post-deployment monitoring.

Business Process Analysis

• Collaborate with process owners and subject-matter experts to understand and document current business processes.
• Develop or support process maps and related documentation.
• Identify process bottlenecks, inefficiencies, control gaps, and improvement opportunities.
• Analyze how data and reporting can improve operational performance.
• Evaluate existing processes using quantitative and qualitative information.
• Recommend practical solutions based on analytical findings.

Process Improvement

• Work with cross-functional teams to identify opportunities to improve business processes.
• Recommend changes designed to enhance efficiency, effectiveness, accuracy, and consistency.
• Assist with the design and implementation of process improvements.
• Support continuous-improvement initiatives.
• Apply process-improvement principles and methodologies when appropriate.
• Monitor results following implementation to determine whether changes are producing the intended outcomes.
• Proactively identify opportunities to improve reporting processes and analytical methodologies.

Data Quality & Validation

• Ensure data used for analysis and reporting is accurate, complete, consistent, and reliable.
• Develop and perform data-quality checks.
• Conduct reconciliation and validation activities.
• Identify missing, inaccurate, duplicated, or inconsistent information.
• Investigate data-quality issues and coordinate appropriate resolution.
• Validate source-to-report results.
• Document data issues, findings, corrective actions, and outcomes.
• Support data-governance and quality-management practices.

Reporting Support & Incident Management

• Serve as a resource for reporting questions, data discrepancies, access concerns, refresh issues, and report-related inquiries.
• Investigate reporting issues using available data and supporting evidence.
• Triage issues based on operational impact and urgency.
• Develop clear problem statements when escalating technical defects.
• Coordinate with analysts, developers, data engineers, platform teams, and business subject-matter experts.
• Provide timely status updates regarding findings, ownership, next steps, and resolution.
• Validate that reported issues have been resolved.
• Maintain appropriate records of investigations and outcomes.
• Participate in root-cause reviews and identify opportunities to prevent recurring issues.

Stakeholder Communication

• Communicate analytical findings through:
  
  • Written reports
  • Dashboards
  • Data visualizations
  • Presentations
  • Business summaries
• Translate complex analytical findings into clear, actionable business information.
• Present information appropriately for technical, operational, management, and leadership audiences.
• Collaborate with cross-functional teams to gather reporting and analytical requirements.
• Build productive relationships with process owners, subject-matter experts, technical teams, and business stakeholders.
• Manage stakeholder expectations professionally when resolving reporting or data issues.

Requirements Gathering

• Work with stakeholders to understand business and reporting needs.
• Gather and document requirements for reports, dashboards, metrics, and analytical projects.
• Translate business requirements into reporting and data-analysis specifications.
• Clarify definitions, calculations, business rules, and expected outcomes.
• Validate completed reporting solutions against stakeholder requirements.
• Identify opportunities to standardize recurring reporting needs.

Data Governance, Security & Compliance

• Follow applicable data-governance policies and procedures.
• Ensure data handling and reporting activities comply with relevant security and regulatory requirements.
• Maintain appropriate controls when accessing and analyzing business data.
• Protect sensitive and confidential information.
• Support audit and compliance requirements when applicable.
• Maintain appropriate documentation and analytical evidence.
• Follow established reporting, security, escalation, and documentation standards.

Documentation & Knowledge Management

• Maintain clear documentation of reporting processes, business rules, data definitions, analytical methodologies, and investigation findings.
• Create and maintain reporting support documentation when appropriate.
• Document recurring issues and proven solutions.
• Develop process documentation and stakeholder-ready summaries.
• Support knowledge sharing and cross-training.
• Help establish repeatable reporting and analytical processes.

Required Qualifications

• Bachelor's degree in Business, Finance, Data Science, Data Analytics, Business Analytics, Information Systems, Computer Science, or a related field.
• 5-10 years of relevant experience in business analysis, reporting, process improvement, data analysis, business intelligence, analytics, or a related role.
• Strong experience collecting, analyzing, validating, and interpreting business data.
• Experience developing reports, dashboards, KPIs, and performance metrics.
• Strong analytical and problem-solving skills.
• Strong attention to detail.
• Experience with process mapping and business-process documentation.
• Ability to translate complex data into actionable business insights.
• Excellent written and verbal communication skills.
• Strong organizational and project-management capabilities.
• Ability to manage multiple assignments and priorities simultaneously.
• Ability to work independently and collaboratively within cross-functional teams.

Required/Highly Relevant Technical Skills

Candidates should demonstrate experience with several of the following:

• Microsoft Power BI
• SQL
• Microsoft Excel
• Data Analysis
• Data Visualization
• Dashboard Development
• KPI & Metrics Reporting
• Data Reconciliation
• Data Validation
• Business Intelligence
• Reporting Analytics
• Process Mapping
• Process Improvement
• Requirements Gathering
• Data Quality
• Data Governance
• Root-Cause Analysis

Advanced Excel capabilities should include experience with reconciliation, analysis, lookups, PivotTables, and structured data validation.
Preferred Technical Qualifications

• Working knowledge or hands-on experience with Databricks.
• Databricks SQL experience.
• Experience with cloud-based data and analytics platforms.
• Experience with Tableau or comparable visualization platforms.
• Microsoft Fabric experience.
• Familiarity with data warehouses and enterprise semantic models.
• Knowledge of Delta Lake or lakehouse concepts.
• Understanding of data lineage and source-to-report data flows.
• Experience with enterprise scheduling or job-monitoring tools.
• Experience with ticketing/work-management platforms such as ServiceNow, Jira, Remedy Helix, or similar systems.
• SharePoint experience.
• Experience supporting regulated or controlled reporting environments.

Process Improvement Knowledge

Familiarity with process-improvement methodologies is highly desirable, including:

• Lean
• Six Sigma
• Lean Six Sigma
• Root-Cause Analysis
• Continuous Improvement
• Process Mapping
• Workflow Optimization

A relevant professional certification, such as Lean Six Sigma, is considered advantageous.
Preferred Qualifications

• Master's degree in a relevant discipline.
• Lean Six Sigma or related process-improvement certification.
• 5-10 years of progressively responsible reporting, analytics, or business analysis experience.
• Experience supporting enterprise-scale reporting environments.
• Experience with Power BI production support.
• Experience investigating complex reporting or data-quality issues.
• Utility-industry experience.
• Knowledge of customer operations, billing, payments, field operations, or related utility business processes.
• Knowledge of data governance and data quality principles.
• Understanding of data security and compliance requirements.
• Experience collaborating with Data Engineering, Reporting Development, IT, and business teams.

Core Competencies

The successful candidate should demonstrate:

• Analytical Thinking
• Data-Driven Decision Making
• Problem Solving
• Business Analysis
• Reporting & Visualization
• Process Improvement
• Data Quality
• Attention to Detail
• Root-Cause Analysis
• Stakeholder Management
• Technical Communication</