Data Analyst, Aurora Control Plane

2 weeks ago


Vancouver, Canada Amazon Dev Centre Canada ULC Full time

Bachelor’s degree in a quantitative area such as math, statistics, computer science, engineering or equivalent experience
- 4+ years of relevant experience in analytics, business intelligence, data engineering, or related field
- Proficient in SQL working with large-scale, complex datasets from multiple sources
- Experience with data modeling, ETL development, and data warehousing
- Advanced skills in Excel as well as additional data visualization tools like Tableau, Amazon QuickSight or similar BI tools
- Advanced ability to draw insights from data and clearly communicate them to the stakeholders and senior management as required

Job summary

We build the Amazon Aurora control plane that:

- Reliably manages a large fleet of databases for our customers freeing them from traditional database operations
- Guarantees best-in-class availability and failover capabilities to sustain the world’s most demanding workloads
- Orchestrates and automates the complete lifecycle of a database cluster from creation to operation to scale-out and fail-over
- Has the unique opportunity to integrate closely with our engine and storage layers to build an end-to-end solution that is easy-to-use and at the same time full-fills the demanding requirements of an enterprise-grade solution

Amazon Aurora is a cloud-native relational database which combines the scalability and performance of the best NoSQL databases paired with full compatibility to the most popular relational open source databases - MySQL and PostgreSQL. Amazon Aurora can store terabytes of customer data and can handle peaks of millions of queries per second.

We don’t need you to be an expert in databases or distributed systems as you will have a chance to learn and grow with your team. We are attracted to engineers who love what they do and are passionate about their work. We appreciate curiosity and craftsmanship over knowledge in certain technologies and frameworks. Here are some other qualities we are looking for:

- Be great fun to work with. At Amazon, we have a credo of “Work hard. Have fun. Make history”. In this role, you will love what you do, and instinctively know how to make work fun. You will be dynamic and creative, and willing to take on any challenge and make a big impact.
- Display flexibility to manage shifting priorities and influence in the face of ambiguity. You will help create critical data insights for a rapidly growing and evolving service
- Enjoy developing solutions for technical talent to achieve great things. You will have a passion for enabling cloud computing experts through your data products for a diverse and challenging set of customers.

Key job responsibilities
- Own, design, develop, document, and manage scalable solutions for new and ongoing metrics, reports, analyses, visualizations, and dashboards to support business needs
- Own and develop queries and data visualizations for ad-hoc, recurring, troubleshooting requests and projects, as well as for ongoing reporting by leveraging SQL, Redshift, QuickSight and Tableau skillsets
- Dive deep to understand frameworks utilized for storing data and different tools and solutions used to gain access to it
- Use data mining, data modelling ,data warehousing, and other analytical techniques to develop and maintain data segmentation and predictive models to drive the availability analysis
- Design and drive experiments to form actionable recommendations. Present to business leaders in both ad-hoc forums and routine business reviews (MBR/QBR) to drive decisions

About the team

Mentorship & Career Growth

We recognize new team members need time to ramp-up and feel fully comfortable within the team. You will have a launch buddy, an engineer who will help you navigate through this processes offering you help and mentorship.

Work/Life Balance

We offer flexibility in working hours and encourage you to find your own balance between your work and personal life.

Inclusive Team Culture

Here at AWS, we embrace our differences. We are committed to furthering our culture of inclusion. We have ten employee-led affinity groups, reaching 40,000 employees in over 190 chapters globally. We have innovative benefit offerings, and host annual and ongoing learning experiences, including our Conversations on Race and Ethnicity (CORE) and AmazeCon (gender diversity) conferences. Amazon’s culture of inclusion is reinforced within our 14 Leadership Principles, which remind team members to seek diverse perspectives, learn and be curious, and earn trust.
- MBA or Master’s degree in Computer Science, Engineering, Statistics, Mathematics or related field
- Expert in writing and tuning SQL scripts
- Experience working in large data warehouse environments
- 5+ years of experience in a BIE or data engineer role with a technology company
- Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical teams
- Ability t


  • Data Analyst

    3 days ago


    Vancouver, British Columbia, Canada Blue Boat Data Full time

    Blue Boat Data   Analyst / Senior AnalystBlue Boat Data is an enterprise analytics SaaS company based out of New York city and Vancouver, Canada. We are a young company growing rapidly and building the next generation of Enterprise Intelligence software. Our leadership team has a combined 50 years+ of experience building and managing data, analytics,...


  • Vancouver, Canada Aurora Cannabis Full time

    **Manager, Finance and Accounting** **Division: Finance and Accounting** **Job location: Anywhere in Canada** **Hours: 40 hours per week, Monday - Friday** **Employment type: Full-time permanent employment in a remote work-setting **A little about us** Hi, we’re Aurora Cannabis, and we’re so excited to meet you! We’re a global cannabis company...


  • Vancouver, Canada Aurora Solar Inc Full time

    About Aurora Solar Aurora is on a mission to create a future of solar for all. Our award-winning software puts the power of data and technology into the hands of every solar professional to make solar adoption simple and predictable. Our software has designed millions of solar projects so far, empowering solar companies to sell, design, and install...


  • Vancouver, Canada Aurora Cannabis Inc. Full time

    Division: FinanceJob location: Remote (Ontario, Quebec, Alberta)Hours: 40 hours per week, Monday to FridayEmployment type: Full Time A little about us Hi, we’re Aurora Cannabis, and we’re so excited to meet you! Aurora Cannabis is a leader in the rapidly evolving global cannabis industry, serving both medical and consumer markets worldwide. Dedicated to...


  • Vancouver, Canada Aurora Cannabis Inc. Full time

    Join to apply for the Accounts Payable Specialist - Remote role at Aurora Cannabis Inc. Accounts Payable Specialist Division: Finance Job location: Remote (Ontario, Quebec, Alberta) Hours: 40 hours per week, Monday to Friday Employment type: Full Time A little about us Hi, we’re Aurora Cannabis, and we’re so excited to meet you! Aurora Cannabis is a...


  • Vancouver, Canada Aurora Solar Inc Full time

    About Aurora Solar Aurora is on a mission to create a future of solar for all. Our award-winning software puts the power of data and technology into the hands of every solar professional to make solar adoption simple and predictable. Our software has designed millions of solar projects so far, empowering solar companies to sell, design, and install...


  • Vancouver, Canada Aurora Solar Inc Full time

    About Aurora Solar Aurora is on a mission to create a future of solar for all. Our award-winning software puts the power of data and technology into the hands of every solar professional to make solar adoption simple and predictable. Our software has designed millions of solar projects so far, empowering solar companies to sell, design, and install...


  • Vancouver, British Columbia, Canada Aurora Cannabis Inc. Full time

    Accounts Payable SpecialistDivision: FinanceJob location:Remote (Ontario, Quebec, Alberta)Hours:40 hours per week, Monday to FridayEmployment type:Full TimeA little about usHi, we're Aurora Cannabis, and we're so excited to meet youAurora Cannabis is a leader in the rapidly evolving global cannabis industry, serving both medical and consumer markets...


  • Vancouver, British Columbia, Canada Aurora Cannabis, Inc Full time

    Accounts Payable SpecialistDivision: FinanceJob location: Remote (Ontario, Quebec, Alberta)Hours: 40 hours per week, Monday to FridayEmployment type: Full TimeA little about usHi, we're Aurora Cannabis, and we're so excited to meet youAurora Cannabis is a leader in the rapidly evolving global cannabis industry, serving both medical and consumer markets...

  • Data Analyst

    5 hours ago


    Vancouver, Canada University of British Columbia Full time

    Staff - Non Union Job Category M&P - AAPS Job Profile AAPS Salaried - Statistical Analysis, Level B Job Title Data Analyst Department Vigo Laboratory | Department of Psychiatry | Faculty of Medicine Compensation Range $7,622.83 - $11,886.67 CAD Monthly The Compensation Range is the span between the minimum and maximum base salary for a position....