Business Intelligence Engineer

Job Title: Business Intelligence Engineer

Location: Overland Park KS

Duration: / Term: Contract

Experience Desired: 8 Years

Job Description:

We are seeking a skilled Business Intelligence (BI) Engineer with strong expertise in Amazon QuickSight and AWS analytics services to support business teams in building scalable self-service reporting solutions.

The ideal candidate will partner closely with business stakeholders to understand reporting needs enable self-service analytics and design reusable reporting frameworks templates and data flows that reduce compute costs and improve reporting efficiency across the organization.

This role requires a mix of technical BI development data modeling stakeholder collaboration and cost optimization within AWS.

Key Responsibilities

1. QuickSight Development & Dashboard Engineering

• Design develop and maintain interactive dashboards datasets and visualizations in Amazon QuickSight.
• Build high-performance dashboards optimized for large datasets and fast refresh times.
• Implement row-level security (RLS) and governance controls for business users.
• Create standardized QuickSight templates and dashboard frameworks that can be reused across teams.
• Design and maintain semantic layers and curated datasets for reporting.
• Optimize dashboards to reduce SPICE usage refresh costs and compute consumption.

2. Self-Service BI Enablement

• Work directly with business users and analysts to enable self-service reporting capabilities.
• Provide guidance on best practices for dashboard design and data consumption.
• Create reusable data models templates and reporting accelerators.
• Develop training materials and documentation for business teams to build their own dashboards.
• Conduct workshops and enablement sessions for business users on QuickSight usage.

3. Data Modeling & Dataset Engineering

• Design and maintain optimized datasets and data models for BI reporting.
• Build reusable data flows and data pipelines that serve multiple reporting use cases.
• Work with engineering teams to integrate data from sources such as:
  • AWS Redshift
  • S3
  • Athena
  • RDS
  • Glue Data Catalog
• Ensure datasets follow governance quality and consistency standards.

4. Reporting Frameworks & Reusable Components

• Create reusable reporting templates dataset templates and QuickSight themes.
• Build standardized KPIs calculated fields and metric definitions.
• Design modular reporting components that can be used across multiple dashboards.
• Implement parameterized dashboards and reusable visual components.

5. Performance Optimization & Cost Management

• Identify opportunities to reduce compute costs associated with reporting workloads.
• Optimize use of SPICE vs direct query based on performance and cost requirements.
• Monitor and tune query performance across Athena Redshift and other data sources.
• Implement efficient refresh schedules and dataset management strategies.
• Provide recommendations for cost-efficient reporting architectures on AWS.

6. Collaboration with Business & Data Teams

• Partner with product owners business analysts and leadership teams to understand reporting requirements.
• Translate business needs into scalable BI solutions.
• Work with data engineering teams to ensure required datasets are available and optimized.
• Participate in requirements gathering and reporting roadmap planning.

7. Governance Documentation & Standards

• Establish BI standards and governance for QuickSight dashboards.
• Maintain documentation for:
  • datasets
  • metrics
  • dashboard logic
  • reporting frameworks
• Ensure adherence to data security and access policies.
• Implement naming conventions and versioning for dashboards and datasets.

Required Qualifications

• 8 years of experience in Business Intelligence Analytics Engineering or Data Visualization.
• Strong hands-on experience with Amazon QuickSight.
• Experience designing interactive dashboards and enterprise reporting solutions.
• Solid knowledge of SQL and data modeling.
• Experience working with AWS analytics services such as:
  • Athena
  • Redshift
  • S3
  • Glue
• Experience enabling self-service analytics for business users.
• Strong understanding of data visualization best practices.
• Experience optimizing reporting performance and cost efficiency.

Preferred Qualifications

• Experience building QuickSight templates themes and reusable datasets.
• Experience with BI governance and semantic layer design.
• Familiarity with data pipelines and ETL frameworks.
• Knowledge of AWS cost optimization strategies.
• Experience supporting large-scale enterprise reporting environments.
• Experience with other BI tools such as Tableau Power BI or Looker.

Key Skills

• Amazon QuickSight
• SQL & Data Modeling
• AWS Analytics Stack
• Dashboard Design
• BI Architecture
• Self-Service Analytics Enablement
• Performance Optimization
• Cost Optimization
• Stakeholder Communication

Deliverables / Expected Outcomes

• Standardized QuickSight reporting templates
• Reusable datasets and semantic reporting layers
• Improved self-service BI adoption across business teams
• Reduced compute and reporting infrastructure costs
• Scalable dashboard frameworks and governance standards

Key Skills:

Business Intelligence AWS QuickSight SQL Data Modeling Athena Redshift S3 Glue