What are the responsibilities and job description for the BI Engineer Amazon QuickSight / AWS Analytics position at KONNECTINGTREE INC?
Role Overview
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
Salary : $50 - $60