Amazon QuickSight Administrator & BI Analyst
RequirementsCore BI & QuickSight Skills
- 2+ years in BI, analytics, or data operations.
- 1+ year of hands-on Amazon QuickSight administration.
- Experience handling permissions, namespaces, dashboards, and RLS.
- Strong SQL across multiple relational databases.
- Experience with data warehousing concepts and ETL processes.
Scripting & Automation
- Proficiency with Python for automating QuickSight operations via Boto3.
- Experience with AWS CLI, SDKs, and infrastructure scripting.
- Ability to build reusable automation frameworks.
AWS Data Services Knowledge
- Familiarity with Glue, Redshift, IAM, S3, and Kinesis.
- Experience evaluating AWS architectures for scalability and cost efficiency.
- Understanding of cloud security governance and compliance best practices.
General Skills
- Strong problem-solving capabilities.
- Excellent communication and stakeholder-management skills.
- Ability to work independently within a distributed team.
- Attention to detail in governance, permissions, and BI correctness.
Nice to Have
- 5+ years of broader AWS experience.
- Familiarity with Redshift data modelling.
- Experience in enterprise payment, fintech, or high-security industries.
- AWS Certification:
- Solutions Architect
- Data Analytics Speciality
- SysOps Administrator
- Experience building BI governance frameworks.
- Experience with cost-optimisation strategies in AWS.
ResponsibilitiesQuickSight User & Access Administration
- Manage QuickSight users, groups, namespaces, and roles (Reader/Author/Admin).
- Provision and de-provision accounts in accordance with governance rules.
- Enforce secure access controls, row-level security (RLS), and usage policies.
- Maintain consistent permissions and enforce BI governance across teams.
Automation & Scripting
- Automate BI administrative tasks using AWS CLI, SDKs, or Python Boto3:
- User provisioning & permission updates
- Dataset refresh automation
- Scheduled reporting workflows
- SPICE capacity monitoring
- Develop repeatable, scalable processes for BI operations.
Dashboard & Reporting Development
- Design, build, and maintain dashboards and analyses in QuickSight.
- Collaborate with data engineers and business stakeholders to define requirements.
- Transform raw datasets into governed, user-friendly BI models.
- Ensure dashboards are accurate, performant, and aligned with business KPIs.
Performance Monitoring & Optimisation
- Monitor dataset refreshes, usage metrics, error logs, and failure events.
- Optimise SPICE usage, query performance, and dataset preparation.
- Troubleshoot issues related to permissions, refresh schedules, or data quality.
Governance, Documentation & Support
- Maintain documentation of datasets, lineage, transformations, and BI standards.
- Establish governance frameworks for BI usage, dataset ownership, and versioning.
- Provide training and best-practice guidance to business users and analysts.
AWS Architecture Advisory Responsibilities
(Integrated into the role — supports data modernisation initiative)
- Review the feasibility and architecture of ingestion strategies using:
AWS Kinesis, Glue ETL, Redshift, S3, IAM
- Ensure security best practices, IAM policies, encryption, and logging compliance.
- Evaluate performance and scalability of AWS compute & storage configurations.
- Provide cost-optimisation recommendations for QuickSight, Redshift, SPICE, and data flows.
- Ensure AWS-native architectural patterns are followed across BI and analytics workloads.
About the ProjectA global payments company is undergoing a major data modernisation initiative to address several critical challenges affecting day-to-day operations and long-term scalability, including:
- Production reporting overload
- Missing governance and compliance controls
- Fragmented ingestion and data flows
- Lack of a scalable BI and analytics layer
The project aims to establish a secure, governed, AWS-native analytics foundation powered by QuickSight, Glue, Redshift, Kinesis, and S3.
Your role will be essential in enabling BI governance, user access control, dashboard automation, and AWS architecture advisory.