AWS BI & Data Platform Administrator

Gainwell Technologies LLC•Rancho Cordova, CA

11d•$107,000 - $152,800•Remote

About The Position

We are seeking a detail-oriented and experienced AWS BI & Data Platform Administrator to manage and maintain our business intelligence (BI) and data lake environments. The ideal candidate will have hands-on expertise with AWS data analytics services and BI tools, particularly in managing and optimizing data access, query performance, and user experience. Experience with Amazon QuickSight/Quick Suite administration, and knowledge of AWS Athena and Lake Formation is preferred. This role is crucial for ensuring the security, integrity, and performance of our data platform, enabling seamless data analysis for the organization. Your role in our mission

Requirements

Proven experience in a data administration or BI administration role, with specific experience managing AWS services.
Hands-on experience with Amazon QuickSight/Quick Suite, including user management, dataset creation, and analysis sharing.
Strong knowledge of SQL and experience with Amazon Athena for querying data lakes.
Familiarity with data lake concepts and practical experience with AWS Lake Formation for data governance and permission management.
Understanding of data warehousing concepts, data modeling, and ETL processes is a plus.
Excellent problem-solving, analytical, and communication skills.

Responsibilities

Amazon QuickSight/Quick Suite Administration: Manage QuickSight/Quick Suite user accounts, groups, and permissions, adhering to the principle of least privilege.
Data Management: Create, manage, and share datasets and analyses within QuickSight/Quick Suite, ensuring data accuracy and integrity in all reports.
Database and Data Lake Management: Utilize AWS Athena for ad-hoc queries and data analysis, and configure/manage AWS Lake Formation for centralized data access control and governance of S3 data lake locations.
Security and Access Control: Implement fine-grained access controls using Lake Formation permissions and IAM roles to secure sensitive data at the table, row, and column levels.
Collaboration and Support: Work closely with data engineers and business analysts to understand data requirements and provide support and training to end-users on QuickSight/Quick Suite functionalities.
Monitoring and Optimization: Monitor platform usage and performance, troubleshoot issues, and optimize QuickSight/Quick Suite dashboards and data queries for efficiency.