Senior Business Intelligence & Automation Analyst

• Senior Business Intelligence & Automation Analyst
• 📍 Location: Atlanta, GA, US
• 🏢 Industry: Hospital and healhcare
• 💼 Work Setting: Hybrid

• Are you a highly technical Business Intelligence professional who can independently design, build, automate, govern, and support enterprise reporting solutions while partnering directly with Finance leaders?
• We are seeking a Finance Business Intelligence & Analytics Engineer to serve as the sole technical analytics expert supporting a large-scale transformation portfolio. Unlike traditional BI roles embedded within centralized analytics organizations, this position sits directly within Finance and requires full ownership of the analytics lifecycle, from requirements gathering and data modeling through ETL development, dashboard delivery, automation, executive reporting, and ongoing support.
• The ideal candidate combines expertise in business intelligence, data engineering, analytics, finance partnership, KPI governance, automation, and executive reporting with a strong understanding of financial concepts including ROI, forecasting, value realization, business cases, and P&L performance.

• Key Responsibilities
• Program & Transformation Reporting
• Design, develop, and maintain enterprise reporting solutions for transformation initiatives.
• Create program-level and initiative-level dashboards that serve as the organization's trusted source of performance data.
• Track and report:
• KPIs
• Benefits Realization
• Investment Performance
• Project Milestones
• Value Delivery
• Financial Outcomes
• Deliver executive-ready reporting for leadership reviews and governance meetings.
• Translate complex data into actionable business insights.
• Executive Analytics & Leadership Reporting
• Develop dashboards and reporting solutions for senior leadership audiences.
• Create:
• Executive Scorecards
• Steering Committee Reporting
• Leadership Performance Reviews
• Monthly Business Reviews (MBRs)
• Transformation Metrics Reporting
• Convert data into clear business narratives and recommendations.
• Support strategic decision-making through analytical insights.
• Reporting Automation
• Replace manual reporting processes with scalable, automated solutions.
• Automate recurring:
• KPI Reporting
• Benefits Tracking
• Investment Monitoring
• Executive Reporting Packages
• Implement scheduled and monitored reporting workflows.
• Improve reporting accuracy, efficiency, and sustainability.
• Automation Areas
• Financial Reporting
• Benefits Realization Tracking
• Program Performance Reporting
• Executive Summaries
• Variance Analysis
• AI-Driven Analytics Innovation
• Identify opportunities to embed Generative AI into analytics workflows.
• Implement AI-enabled solutions for:
• Automated Narratives
• Executive Summaries
• Insight Generation
• Variance Explanations
• Conversational Analytics
• Support development of AI-ready reporting architectures.
• Evaluate emerging AI tools that improve reporting productivity and insight generation.
• Data Engineering & Pipeline Development
• Design and maintain scalable ETL/ELT solutions.
• Build data pipelines that integrate information from multiple business sources.
• Extract, transform, validate, and cleanse data used for executive reporting.
• Support large, complex, multi-source datasets.
• Ensure reliable and repeatable reporting processes.
• Data Sources May Include
• ERP Systems
• Operational Platforms
• Transformation Programs
• Business Dashboards
• Legacy Systems
• Manual Files and Spreadsheets
• Data Integration & Modeling
• Integrate disparate data sources into governed reporting environments.
• Design:
• Data Models
• Semantic Models
• Curated Data Sets
• Reporting Layers
• Build scalable structures for current reporting requirements and future AI capabilities.
• Maintain enterprise-grade data architecture standards.
• KPI Governance & Benefit Frameworks
• Partner with Finance leadership to formalize KPI definitions.
• Translate value-realization methodologies into governed reporting logic.
• Establish standardized metrics across transformation initiatives.
• Ensure consistency and accuracy of reporting outputs.
• Support enterprise KPI governance.
• Areas of Focus
• Value Realization
• Financial Benefits Tracking
• ROI Measurement
• Program Performance
• Investment Effectiveness
• Data Quality & Controls
• Implement data quality frameworks and validation controls.
• Establish:
• Reconciliation Processes
• Data Validation Rules
• Anomaly Detection
• Reporting Certifications
• Maintain trust and confidence in reported metrics.
• Ensure reporting integrity and transparency.
• Deep-Dive Analytics & Investigations
• Analyze KPI fluctuations and program performance trends.
• Conduct root-cause analysis on:
• Variance Drivers
• Benefit Gaps
• Performance Issues
• Reporting Discrepancies
• Deliver recommendations based on analytical findings.
• Support executive-level investigations and decision-making.
• Self-Service Analytics Enablement
• Develop governed self-service analytics capabilities.
• Reduce dependency on ad-hoc reporting requests.
• Enable stakeholders to access trusted reporting and data independently.
• Establish usage standards and governance controls.
• Improve reporting efficiency across the organization.
• End-to-End Solution Delivery
• Own the complete analytics lifecycle:
• Requirements Gathering
• Solution Design
• Data Modeling
• Pipeline Development
• Dashboard Development
• User Acceptance Testing
• Deployment
• Adoption Support
• Ongoing Maintenance
• Serve as the primary analytics owner for all assigned initiatives.
• Reporting Governance & Standards
• Establish standards for:
• Data Integrity
• Documentation
• Version Control
• Reporting Governance
• Metric Definitions
• Promote consistent analytics practices across teams.
• Coach business users building their own reporting solutions.
• Improve organizational reporting maturity.
• Qualifications
• Education
• Required
• Bachelor's Degree in:
• Computer Science
• Engineering
• Mathematics
• Statistics
• Information Systems
• Economics
• Related Quantitative Field
• Preferred
• Master's Degree
• Advanced Analytics or Data-related Qualification

Experience

• Required
• 7+ years of experience in:
• Business Intelligence
• Data Analytics
• Analytics Engineering
• Data Engineering
• Reporting Solutions Development
• Experience building end-to-end reporting and analytics solutions.
• Experience functioning as an independent technical contributor.
• Experience partnering closely with Finance or FP&A teams.
• Technical Skills
• Data & Analytics
• Advanced SQL
• Complex Query Development
• Data Modeling
• Star Schema Design
• Semantic Layer Development
• KPI Framework Design
• Business Intelligence
• Power BI
• Tableau
• Executive Dashboard Design
• DAX
• Data Visualization
• Self-Service Analytics
• Data Engineering
• ETL / ELT Development
• Data Transformation
• Pipeline Automation
• Data Integration
• Data Cleansing
• Preferred Platforms
• Databricks
• Microsoft Fabric
• Azure Data Factory
• Snowflake
• Programming
• Python
• Data Automation Scripts
• Reporting Automation Frameworks
• Workflow Automation
• Power Automate
• Power Apps
• Low-Code Automation Platforms
• AI & Analytics Innovation
• Generative AI Applications
• Automated Narrative Generation
• Conversational Analytics
• Agent-Ready Semantic Models
• AI-Enhanced Reporting
• Finance & Business Knowledge
• Required
• Strong understanding of:
• ROI Analysis
• Forecasting
• Variance-to-Plan Analysis
• Business Cases
• P&L Structures
• Financial Performance Management
• Value Realization Methodologies
• Preferred
• ERP Reporting Environments
• SAP
• S/4HANA
• Enterprise Finance Systems
• Professional Competencies
• Independent Problem Solving
• Executive Communication
• Stakeholder Management
• Business Acumen
• Critical Thinking
• Data Storytelling
• Organizational Skills
• Prioritization & Time Management
• Attention to Detail
• Ownership Mindset

• Core Competencies
• Business Intelligence
• Analytics Engineering
• Data Engineering
• Power BI
• Tableau
• SQL
• Python
• ETL/ELT Pipelines
• KPI Development
• Value Realization Analytics
• Finance Analytics
• Executive Reporting
• Data Modeling
• Reporting Automation
• Power Automate
• Financial Performance Management
• Transformation Analytics
• AI-Enabled Analytics
• Self-Service BI