Business Intelligence Architect (AWS)

Location: Onsite - Neenah, WI (preferred) or Oconomowoc, WI
Reports To: IT Senior Director - Data & Analytics

Position Overview

We are seeking an experienced AWS BI Solution Architect with strong SAP expertise to lead and evolve our established AWS-based analytics platform. This role will serve as the technical leader of our enterprise BI architecture, driving continuous improvement, scalability, performance optimization, governance, and innovation.

Our AWS data platform has been established, and the current focus is on increasing data ingestion from SAP (ECC and S/4) and other non-SAP systems for enterprise reporting. The next phase requires strong architectural leadership to enhance integration, improve data modeling standards, optimize cost and performance, and expand advanced analytics capabilities.

This is a high-impact leadership role with visibility across the organization.

Key Responsibilities
1. Player/Coach Technical Leadership

• Architect solutions while remaining hands-on in design reviews, SQL development, and pipeline troubleshooting.
• Lead by example in writing performant queries and optimizing ETL jobs.
• Mentor data engineers and BI developers through code reviews and architectural guidance.
• Establish engineering standards and development best practices.
• Coach team members on dimensional modeling and data structures.

• Lead ingestion for SAP data (ECC and S/4HANA).
• Lead integration of additional enterprise systems and flat files into AWS.
• Define full load vs. incremental load standards.
• Establish monitoring and alerting for pipeline reliability.
• Reduce ingestion latency where appropriate.

• Own and enhance AWS architecture leveraging appropriate AWS Services
• Optimize Glue jobs and ETL frameworks.
• Improve S3 lifecycle and storage tiering strategies.
• Implement cost optimization strategies across compute and storage.
• Drive performance benchmarking and continuous improvement.

• Lead enterprise dimensional modeling standards.
• Improve semantic layers and curated data marts.
• Position platform for advanced analytics and AI/ML readiness.

• Strengthen IAM, row-level security, and data access controls.
• Implement data quality monitoring frameworks.
• Document lineage and data definitions.
• Define SLAs and reliability metrics.
• Ensure compliance with enterprise security policies.

Required Qualifications

• 8+ years in data architecture, BI, or data engineering roles.
• 5+ years hands-on experience designing AWS data platforms.
• SAP data expertise (ECC and/or S/4HANA).
• Proven experience with SAP data ingestion into a cloud warehouse.
• Strong experience with:
  
  • AWS Glue ETL frameworks
  • S3 data lake architecture

• Advanced SQL and dimensional modeling expertise.
• Experience leading technical teams while remaining hands-on.

Preferred Qualifications

• AWS Solutions Architect Certification.
• Experience with SAP SLT, ODP, CDS views, or SAP BW.
• Experience with Infrastructure as Code (Terraform, CloudFormation).

What Success Looks Like

• SAP and enterprise data ingestion pipelines run reliably with defined SLAs.
• AWS BI platform performance and cost efficiency improve measurably.
• Platform stability increases while technical debt decreases.
• Engineering standards elevate team capability.
• Business stakeholders trust and actively use analytics outputs.
• The AWS BI platform is scalable and positioned for future innovation.

Ideal Candidate Profile

• Architect mindset with engineer execution capability.
• Comfortable rolling up sleeves to solve complex data problems.
• Strong communicator who can translate business needs into technical solutions.
• Naturally accountable and ownership-driven.
• Passionate about building scalable, governed data ecosystems