AWS Database Engineer and QuickSight Sepcialist

Job Title:

AWS Database Engineer and QuickSight Sepcialist

Location:

CA - Santa Monica

What you'll do:

Digital Disbursements (DD) is a fintech company, led by a team with deep industry experience and a strong track record of value creation. We operate in the digital payments space and have a proven product-market fit. We specialize in helping bring B2C payments to the digital age and are poised for significant growth in the months ahead. Digital Disbursements was acquired by Western Alliance Bank (NYSE:WAL) in January 2022 and operates as a wholly owned subsidiary of WAL.

The AWS Database Engineer & QuickSight Specialist is responsible for designing, optimizing, and managing AWS Aurora MySQL and Amazon Redshift architectures, as well as developing and managing Amazon QuickSight reporting solutions. This role is crucial for supporting scalable, high-performance data processing and enabling data-driven decision-making across teams. The ideal candidate will have expertise in database architecture, administration, and Amazon QuickSight, with a focus on optimizing performance, ensuring high availability, and supporting self-service analytics.

Database Architecture & Optimization:

• Design and optimize AWS Aurora MySQL and Amazon Redshift architectures to support scalable, high-performance data processing.

• Implement efficient indexing, partitioning, and query optimization strategies to enhance performance.
• Ensure high availability and disaster recovery configurations for Aurora and Redshift.
• Manage data replication, backups, and failover strategies to prevent data loss and downtime

Database Administration & Security:

• Oversee database monitoring, performance tuning, and maintenance to ensure optimal operation.
• Automate database deployments, schema migrations, and maintenance tasks using infrastructure as code principles.
• Manage zero-ETL pipelines and real-time data streaming for seamless data integration.

Amazon QuickSight Reporting & BI Integration:

• Develop and manage interactive dashboards and reports in Amazon QuickSight.
• Implement real-time and scheduled reporting solutions.
• Optimize dataset preparation, calculated fields, and visualization performance in QuickSight.
• Integrate QuickSight with Aurora, Redshift, and S3 data sources for a unified reporting experience.
• Build and maintain QuickSight CI/CD workflows to integrate QuickSight into release management cycles.

Scalability:

• Implement scaling strategies for Aurora and Redshift to optimize resource usage.
• Monitor query performance, concurrency limits, and workload management configurations to enhance efficiency.
• Ensure elastic scaling of Redshift clusters to accommodate workload fluctuations without excessive costs.

Cross-Team Collaboration:

• Work closely with engineering, data science, and product teams to support data-driven decision-making.
• Support self-service analytics for business users by optimizing QuickSight usability.

What you'll need:

• 7+ years proven experience in database architecture, administration, and development with AWS Aurora and Amazon Redshift.
• Bachelor's degree in related field required.
• Expertise in Amazon QuickSight reporting and BI integration.
• Strong knowledge of database optimization techniques, including indexing, partitioning, and query optimization.
• Experience with infrastructure as code (IaC) principles and tools.
• Proficiency in managing zero-ETL pipelines and real-time data streaming.
• Strong understanding of high availability and disaster recovery configurations.
• Excellent troubleshooting and problem-solving skills.
• Strong communication and documentation skills.
• Ability to work collaboratively with cross-functional teams.

Benefits you’ll love:
We offer all the important things you'd want — like competitive salaries, an ownership stake in the company, medical and dental insurance, time off, a great 401k matching program, tuition assistance program, an employee volunteer program, and a wellness program. In addition, you’ll have the opportunity to bolster your business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career!

About the company:

Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC.  AmeriHome Mortgage is a Western Alliance Bank company.

Western Alliance Bancorporation is committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, nation origin, marital status, disability, protected veteran status, sexual orientation, gender identity or genetic information. Western Alliance Bancorporation is committed to working with and providing reasonable accommodations for individuals with disabilities. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process and/or need an alternative method of applying, please email HR@westernalliancebank.com or call 602-386-2488.  When contacting us, please provide your contact information and state the nature of your accessibility issue.  We will only respond to inquiries concerning requests that involve a reasonable accommodation in the application process.

© Western Alliance Bancorporation